Home » Creating POI files

Export data from EPE

 
Thu, 07/09/2015 - 10:44am

I use EPE to maintain a POI file and it works well. Now I wish to share my data with someone else to use on a web site. The problem is that all the file "save as" formats seem to not do as I want. I would like a file that can be opened with Microsoft Excel. The 2 Excel file options discard some of the data I want to keep. The best one is a Garmin .cvs file format. But it is only 4 columns and lumps the extra data in with the address data. Is there a way to export the data into a file that preserves all the data fields in separate columns.

‹ after installing extra poi editor, all i get is a blank white screen. what did i do wrong? HELP: Accuracy of web-based Address Geocoders ›
Thu, 07/09/2015 - 11:04am

You

You could use EPE to convert the csv file to a GPX file. Once converted you can load the GPX file into Excel.

I tried this with an existing GPX file and got the following:

- Excel will warn about the format of the GPX file - Click YES

- Excel will ask how you would like to open the GPX file - Select AS A READ ONLY WORKBOOK.

This appears to load all of the data fields available.

--
Nuvi 350, 760, 1695LM, 3790LMT, 2460LMT, 3597LMTHD, DriveLuxe 50LMTHD, DriveSmart 61, Garmin Drive 52, Garmin Backup Camera 40 and TomTom XXL540s.
Thu, 07/09/2015 - 11:07am

M Column CSV fields

Open EPE and the file you wish to export;
click on Options > M-Column CSV Fields and then pick one of the choices - I usually go to 20-User Profile.

Use the column drop down boxes to indicate the fields you wish to export and their order.

Rename this Profile to something you will be able to associate with the type file you are exporting and finally click Close.

Now do a "Save As" and chose one of the "M-Column" formats.

After you determine that the file opens in Excel and looks correct, I would suggest that you go back into Options > M-Columns and select "1-User Profile" and then close the "Select CSV Profile for M-Column ...) dialog box so you won't mess up loading or exporting another file that has one of the "common" type csv profiles.

Thu, 07/09/2015 - 12:02pm

I tried

t923347 wrote:

You could use EPE to convert the csv file to a GPX file. Once converted you can load the GPX file into Excel.

I tried this with an existing GPX file and got the following:

- Excel will warn about the format of the GPX file - Click YES

- Excel will ask how you would like to open the GPX file - Select AS A READ ONLY WORKBOOK.

This appears to load all of the data fields available.

I tried that and it looked promising but not all the data seemed to be there.

Thanks for the idea.

Thu, 07/09/2015 - 12:05pm

That works.

jgermann wrote:

Open EPE and the file you wish to export;
click on Options > M-Column CSV Fields and then pick one of the choices - I usually go to 20-User Profile.

Use the column drop down boxes to indicate the fields you wish to export and their order.

Rename this Profile to something you will be able to associate with the type file you are exporting and finally click Close.

Now do a "Save As" and chose one of the "M-Column" formats.

After you determine that the file opens in Excel and looks correct, I would suggest that you go back into Options > M-Columns and select "1-User Profile" and then close the "Select CSV Profile for M-Column ...) dialog box so you won't mess up loading or exporting another file that has one of the "common" type csv profiles.

Thank you very much that works the way I want. I knew there had to be a way, I just could not figure it out.