imporint poi from excel

 

Hello:

My company is considering Garmin gps for the field guys.

We can export our client list into excel from Lotus Notes.

Is there a way to import the excel file into the garmin gps units and avoid typing in hundreds of addresses?

Thanks in advance.

Chuck

Yes, it is very simple.

Yes, it is very simple. Save the XLS file in CSV format with the following columns (no header):
lat
long
name
description

and use the free Garmin program POI Loader to put them on the GPS.

--
><> Glenn <>< Garmin nüvi 2598

.

If you click on the getting started and faqs links at the top of the page, you will find lots of info about creating POI files.

Also if you download POI Loader and take a look at the help file, you will find specific information about formatting the file.

Here are the basics from the help file.
-----------------------------------------------
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):

Lon,Lat,["]Name[@Alert Speed]["],["] [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"

Based on MM's followup

gdfaini wrote:

Yes, it is very simple. Save the XLS file in CSV format with the following columns (no header):
lat
long
name
description

and use the free Garmin program POI Loader to put them on the GPS.

Based on MM's followup it looks like the order is:
long
lat
name
description

--
><> Glenn <>< Garmin nüvi 2598

If you only have the addresses...

gdfaini wrote:

Yes, it is very simple. Save the XLS file in CSV format with the following columns (no header):
lat
long
name
description

and use the free Garmin program POI Loader to put them on the GPS.

You can use this website ( http://www.gpsvisualizer.com/geocoder/ ) to gather the lat/long for the .CSV files to load via POILoader