new & interesting places for your GPS

Using Excel to Create POI csv file

 

I have several csv files of some custom POI's that I want to combine into a single file using Excel (Mac version. So I copied and pasted the lines from several file into a single file. Using POILoader,for some reason, I only see the POI in the first row of the Excel csv file. I then opened the .csv file in the Mac TextEdit application and appended .csv to the file name but I got the same result: only the POI on the first line shows up. I also tried changing the POI order so the first few lines are different, but still only the POI on the 1st line shows up. This file has only 67 POI's. The file formats look correct.

This is weird!Any clues to what might be going on would be appreciated.

--
Garmin Nuvi 350, v6.2, City Navigator North America NT 2012, City Navigator Europe NT v9

Saved As CSV

After cutting and pasting in Excel, did you "Save As" and change "Save as type:" to CSV (Comma delimited)?

If so, open the file using a simple text editor and copy the first few lines. Post a comment here and include, i.e. paste, the copied text. Maybe someone will be able to see something....

Cheers.

--
- Keith

.

If you want to send me a message, you can email me the file and I will take a look at it.

Works fine now!

Motorcycle Mama and retireiowan thanks for your help with the file format corrections. I'll pay more attention from now on. I'm now set for our trip to Ireland on Sunday with the Nuvi guiding the way!

--
Garmin Nuvi 350, v6.2, City Navigator North America NT 2012, City Navigator Europe NT v9

sponsored links



Navigation



User login

Leave this blank! This field helps block spambots.

poi factory



Who's online

There are currently 8 users and 39 guests online.

Online users

  • lovemy760
  • case1991
  • Luckytom
  • brentrn
  • jackj180
  • larrypat
  • TnPapa
  • mmullins98