Can anyone help me create .CSV files.
I am very knowledgeable with excel and know how to create .csv and .gpx files but how does one take a list of Business names, phone numbers and addresses and quickly find the coordinates into an Excel file.
I heard that googlemaps is the best resource...but if I have a list of 200 addresses...do I have to find the coordinates separately for each and every address...or is there a conversion-type utility that takes mass addresses and converts them all to co-ordinates without having to do them all individually.
Thanks in advance to all that respond...
PS...ms POI...you have a terrific website.
Welcome to the site.
Be sure to click on the getting started and faqs sections linked at the top of each page.
Check out this page to see the proper format for the POI files.
Here's the faq page for making POI files.
Here's the faq page for obtaining the coordinates of an address.
The best thing to do is to download a file and take a look at what one looks like.
You can open the CSV files in either Notepad or Microsoft Excel.
Here's a link to helpful software.
for me the best website to do a batch process for you is batchgeocode.com.
Check their website to know the format.
Thanks sweetie, it is nice to have you pop your head back in every once in a while
Christopher Gemignani at Juice Analytics wrote a tool that takes a list of addresses and looks up their corresponding latitude and longitude.
The geocoded data can then be exported as a .csv file to add to your POI collection.
I used Google maps a lot and find a lot of time can be saved using it for CSV or GPX files. See this post http://www.poi-factory.com/node/9542 go down to comments by Guttermouth.I have the steps I used for using Google maps,Takeitwithme and Gps Visualizer.If interested I will email you through the site with them.
terms | privacy | contactCopyright © 2006-2018