Excel spreadsheet with selectable fields

 

Below is a link to an Excel spreadsheet that I generated to specifically work with Extra POI Editor. I setup EPE to read all of the fields in the Excel column header rows. Some of the Excel columns can be toggled on and off and some columns include selectable choices within fields (click the yellow header columns to make your selections). A total of 22 fields are used and 18 of those have selections available. You can select the fields you want to use (or turn off) from within Excel while using a single EPE multi column field setup.

There are no macros in the Excel file. All POI data is entered on the first worksheet. The second sheet uses formulas to load the data. After entering your data and saving the .xls file, save the second worksheet as a .CSV file and use EPE to convert it to a .GPX file. The Excel formulas are setup to handle 1000 POIs, so if you have only 50 POIs, the CSV file will have 950 rows of commas. I don’t bother to clean the CSV file at all because EPE ignores the extra commas.

Some cells have conditional formatting to alert you to duplicate entries and placing commas (where they shouldn’t be). To protect the formulas and the formatting, the worksheets are protected. There is no password, so if you want to unprotect the sheets, you can. This file was created with Excel 2003.

Large amounts of comment or description field data may create problems when saving the CSV file. If using line breaks for your comments and descriptions, enter your preferred type of line break. For “canned” comments and descriptions, line break types are selectable. It is probably very few people who will use this file, but if you are into using Excel for your POIs, there may be a couple of features that you can use.

http://www.datafilehost.com/download-c60be0fc.html

--
Jake88

Sounds like extra work to

Sounds like extra work to enter a worksheet and then convert it to csv and then convert it again using EPE. I just create my files 1 time and tell EPE which columns hold what field. No extra lines or columns.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

Extra work

You're right, but with two sheets and selectable fields, there is just too much going on in this file for that to work. It will be necessary to take the extra step and convert to a CSV file first.

--
Jake88

Good work in any event

Your file will probably help some in developing their own POI and for that you deserve some thanks. You have come up with some good tools.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet