I currently manage the Publix POI

 

But when I first sent the file in a mod did the mojo on it to make it GPS compatible. We now have more stores open so I want to upload a new file. My question is how do I get into a "gps" format from excel? I'd like to know as we build about 35 new stores per year. Any help would be appreciated. BTW, I use a Mac in case that matters.

.CSV

equality72521 wrote:

But when I first sent the file in a mod did the mojo on it to make it GPS compatible. We now have more stores open so I want to upload a new file. My question is how do I get into a "gps" format from excel? I'd like to know as we build about 35 new stores per year. Any help would be appreciated. BTW, I use a Mac in case that matters.

An Excel spreadsheet can be saved as a .csv file (comma separated values) in either MS-DOS or Macintosh mode from my Win machine. I would assume you are using a version of Excel on your Mac and that version would have similar ability.

The file needs columns in the order according to POI Loader

Quote:

Creating .CSV Files

POI Loader accepts .csv files that contain longitude, latitude, speed alert information, and optional comments. You can create .csv files using a text editor, MS Excel, or a similar program.

POI Loader assumes a .csv file utilizes the following format for each POI (brackets [ ] denote optional text):

,,["][@]["],["] [comment]["]

Longitude and latitude must appear in WGS84 decimal degrees format (ddd.ddddd; negative numbers indicate West and South).

If you include quotes around the name or comment, you can include line breaks in the text.

The following are examples of Custom POIs in the proper format:

-94.81549,38.80390,Bonita

-94.79731,38.81099,Ridgeview@25

-94.74240,38.81952,Heritage Park,Perfect site for a picnic

-94.76416,38.81227,Garmin,"1200 E. 151st Street
Olathe,KS 66062
913/397.8300"

Can you give us details of the "columns" you have in your spreadsheet.

It already is

The .csv file format is one that Excel can read in directly.

The 4 columns are longitude, latitude, name, description

If in doubt, just download the .csv file already on this site, add the new stores, then re-upload it.

--
Garmin Nuvi 2450