Creating CSV files

 

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.

--
Nuvi 680 GPSMap60CSx

sponsored links

.

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.

http://www.poi-factory.com/garmin-csv-file-format

Here's the faq page for making POI files.

http://www.poi-factory.com/node/6664

Here's the faq page for obtaining the coordinates of an address.

http://www.poi-factory.com/node/821

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.

http://www.poi-factory.com/node/6678

for me the best website to

for me the best website to do a batch process for you is batchgeocode.com.

Check their website to know the format.

JCMilan wrote:

JCMilan wrote:

PS...ms POI...you have a terrific website.

Thanks sweetie, it is nice to have you pop your head back in every once in a while smile

Miss POI

Excel Geocoding Tool

JCMilan wrote:

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.

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.

http://www.juiceanalytics.com/writing/excel-geocoding-tool-v...

--
DriveAssist 50, Nüvi 2595LMT, nüvi 760, TomTom START 45M

Google maps

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.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. Android Garmin Viago and Here Maps.