Select your product to confirm this information applies to you

Creating Custom POIs in Microsoft Excel

CSV (.csv) files containing custom POIs (points of interest) can be created in Microsoft Excel and loaded to compatible Garmin devices using  Points of Interest (POI) Loader.

A basic POI includes the longitude, latitude, name, and an optional comment field. 

To Create a CSV file with Custom POIs in Microsoft Excel, Insert the POI Information into the First 4 Columns of the Excel:

  • Column A = Longitude
  • Column B = Latitude
  • Column C = Name
  • Column D = Comment (optional)

Example:

-94.5009536.35431Roaring River State ParkLight-colored worms
-92.5139437.43547Bennett Spring State ParkMaribu jigs
-94.7641638.81227Garmin1200 E. 151st St.

NOTE: Column A and B cannot include any spaces or special characters other than the dash (-) and period (.) symbols.

Once all of the desired information has been entered, save the file in CSV format.


To Save the File:

NOTE: The file name for the .csv file cannot contain commas, or special characters. 

Windows:

  1. Press F12 to display the Save As dialogue
  2. Browse to the desired folder
  3. Enter the file name
  4. Select CSV (Comma delimited) (*.csv) in the Save as type box
  5. Click Save

Mac:

  1. On the File menu, click Save As
  2. Browse to the desired folder
  3. Enter the file name
  4. Select CSV (Comma delimited) (*.csv) in the Format type
  5. Click Save

Once the CSV file has been saved, the custom Points of Interest can be loaded to the device using POI Loader.

Related