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
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):
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.74240,38.81952,Heritage Park,Perfect site for a picnic
-94.76416,38.81227,Garmin,"1200 E. 151st Street
Can you give us details of the "columns" you have in your spreadsheet.
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.
terms | privacy | contactCopyright © 2006-2023