How do I create custom poi files using excel?
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 street number, street, city, state (abbreviation), zip code and Phone Number. No commas
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 not to put the Longitude and Latitude in the wrong column on the Excel sheet.
C. Eliminate all the periods, dashes (except phone number) and commas in Column D. Using find and replace with all listed under edit at top of excel sheet. Make sure to add space in replace with. Then click replace all.
D. To get a nice format for column D. Put in the street address and push down on alt and hold it down then hit enter. Now put in the city, state and zip then alt and enter and then put the phone number in.
Other pages
