HomeGarmin


How can I import 100+ addresses to Garmin Mobile PC?
Ken in Regina
Quote:
Originally Posted by gogetter
speaking of agreeing. Do you know how I can get the
latitude and longitude after I save a file to .CSV to be able to use Garmin POI Loader. When we don't have a lot of addresses, I can put those in my Garmin nuvi 350.
I hope you understand what I mean.

Charlie
Yep. It's the Batch Geocode site I mentioned a couple of times earlier.

The first thing to do is download the Excel template linked in Step #1. Take a look at the template and then make a list of the addresses you want to test on the Nuvi in the same format as the sample template. Before you go to the next step, make sure you save the spreadsheet in Tab Delimited (*.txt) format.

Use simple headings, like the first four columns in the sample file. The first row will be used as the names of the data fields for all following operations.

Once you have a few addresses in your file for testing, follow the steps on the site.

After you cut/paste the finished data with locations back into the Excel file you will need to shift the columns around to make POI Loader happy.

POI Loader will accept a .CSV file with the columns in the following order:

LONGITUDE
LATITUDE
ADDRESS
{optional fourth description column}

So just move the columns around in the spreadsheet and now save it as a .CSV file. Remember that POI Loader only wants a maximum of these four columns and in this exact order. Note that the order of the coordinates is the opposite of what gets cut/pasted from the Geocoding site.

This is critical .. save the file in a folder with NO OTHER FILES in it. Name it by the name you want for the custom POI group. For this test, you could call it TEST ADDRESSES.CSV, for instance.

Now you can run POI Loader, point it at your Nuvi (turn it on and connect it first, of course, so POI Loader will find it), point it at the folder that has the CSV file in it and let 'er rip.

If the Batch Geocoder doesn't find the coordinates for all your addresses, just delete those rows from your test file and go ahead with the test using just the addresses with coordinates. Let me know and I'll tell you how to deal with getting coordinates for the missing ones in most cases.

Have fun.

Oooops, I meant really fun

...ken...
gogetter
Thanks Ken, I'll try that and let you know how I come out.


Charlie
oldtimeguitarguy
I made a web app that can automatically pull all of your Gmail contacts and export them to your Garmin. You can do up to 2,500 in batch.

http://www.contacts2garmin.com
gogetter
Oldtimeguitarguy, thanks!
jwarner191
Sorry, it doesn't seem to work.
GpsinsuranceDoorknocker
Step 1 : import addresses to excel spreadsheet.
Step 2 : use a site like gpsvisualizer to convert excel to grid cords.
Step 3 : use poi loader to import to gps.

Successful people are willing to do what unsuccessful aren't willing to do
Boyd
Quote:
Originally Posted by GpsinsuranceDoorknocker
Successful people are willing to do what unsuccessful aren't willing to do
Like responding to a three year old thread!
Ken in Regina
Quote:
Originally Posted by Boyd
Like responding to a three year old thread!
Hi Boyd,

This forum is a giant archive of useful info. Nobody should be belittled if they have something useful to add.

...ken...
Boyd
Sorry, it was just a poor attempt at humor....
Ken in Regina
Yeah, that tagline just begs for someone to take a swing at it. I was tempted.

...ken...
laptopgpsworld.com About