1.Pull up Excel sheet.
2.Column A put in Longitude. (6 decimal places)
3.Column B put in Latitude. (6 decimal places)
4.Column C put in Name.
5.Column D put in address,city,state (abbreviation),zip code and Phone Number. Put commas in per this example.770 Schillinger Rd,Mobile,AL 36695,251-634099 .This will allow the information to go into correct fields for Extra Poi Editor.
6.After all data is completed for each row you will need to save as a csv file.
7.Go to file at top left of Excel sheet and click on it and select save as.
8.Under File name put the name of the file. Under Save as type click on down arrow and find CSV (Comma delimited). Now click save.
9.You now have a CSV file.
A. Tips to get Longitude and Latitude. Go to http://www.gpsvisualizer.com/geocoding.html. Under number 1. Geocode a single address .Put address in box and click Go. Make sure to get an address not a city or zip code when search completes. Select 2 for multiple addresses.
B. Be sure to put the Longitude and Latitude in the correct order on Excel.
C.Use Extra Poi Editor to check you file for information being in correct field or to save as a GPX File. http://turboccc.wikispaces.com/Extra_POI_Editor
Other pages
