How to Create a POI CSV File

Global Positioning System (GPS) enthusiasts interested in creating a custom Point of Interest (POI) Comma-Separated Values (CSV) file containing information, such as one's favorite restaurant or gas station, can do so by using Microsoft Excel. Microsoft Excel supports the CSV file format. Creating POI CSV files requires GPS users to know the longitude and latitude of the location they are trying to create a POI CSV file for. One of the easiest ways to get this information is by using Google Maps.

Instructions

    • 1

      Visit the Google Maps homepage, enter the address of your POI location in the search field and then select "Search Maps" (See Resources).

    • 2

      Use the Google maps "Hand" tool to move the POI location to the center of the map, and then paste "javascript:void(prompt('',gApplication.getMap().getCenter()));" in your browser. A dialog box appears containing the longitude and latitude of your POI location. Note that the first group of numbers is the longitude while the second group is the latitude.

    • 3

      Open Microsoft Excel, and then enter your POI location details in separate cells as follows "Longitude, Latitude, Name, Description." Use decimal degrees for coordinates. Be sure that you start a new location from a new line.

    • 4

      Create a POI CSV file by clicking on "File," selecting "Save As," entering a file name, choosing "CSV" as the file type, and then selecting "Save." You have successfully created a POI CSV file.

Related Searches:

References

Resources

Comments

You May Also Like

  • How to Convert CSV to a TomTom POI File

    TomTom Points of Interest (POI) files are stored in the OV2 file format. Other Global Positioning System (GPS) devices also use POI...

  • How to Create GPS CSV Files

    A Comma-Separated Values (CSV) file can be used to hold geolocation data. This allows CSV files to be used by Global Positioning...

  • The Structure of Garmin CSV Files

    CSV files are plain text files that notate different values by placing commas between them. Garmin CSV files store information for customized...

  • How to Create CSV Files

    A CSV file (.csv extension) is a comma delimited, plain text file. These files are preferred for applications that transfer information across...

  • How to Convert a CSV File to OFX

    A .CSV file, or comma separated value file, is a text file filled with tabulated data. The data is separated into rows...

  • How to Create Garmin Files

    Creating Garmin files involves the use of third-party programs to format custom Global Positioning System (GPS) data in a file extension recognized...

  • What Is the File Extension Poi?

    Global positioning systems are devices that use information transmitted by government satellites to help users navigate and find their way from one...

  • How to Convert a Garmin POI File

    Garmin GPS devices can only read POI files formatted as GPX. Other devices such as the TomTom GPS are only compatible with...

  • How to Create TomTom POI Files

    A TomTom is a personal GPS (Global Positioning System) device that is manufactured by the Dutch company TomTom NV. A POI (Point...

Related Ads

Featured