Home » Creating POI files

excel docs as pois?

 
Tue, 10/24/2006 - 9:23am

Hey all-

I'm trying to figure out if you can save addresses/points of interest in an excel document and then load that document onto my nuvi. I have quite a few addresses I need for work so I am trying to figure out if this is possible. I can save the document as a CSV file but for some reason when I try to load it, the loader does not recognize it. Anyone have any ideas?

‹ understanding poi Just bought GPS in Australia ›
Tue, 10/24/2006 - 10:56am

Excel works pretty well

Excel works pretty well if you format the data carefully.

Here are a few tips:

  • use exactly 3 or 4 columns (longitude, latitude, name, description)
  • don't use a header row
  • don't add any extra columns
  • don't leave any blank rows in your data
  • use file / save as / CSV (comma delimited)

Beginners should start with just 3 columns, avoid quotation marks, and avoid muli-line cells to keep things simple.

If you're still stuck, I'd be happy to look at your file to help find the trouble spots.

JM