Please help me create a mapping macro?
May 13, 2010 6:56 AM   Subscribe

Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro?

I have a spreadsheet of 1,629 addresses. They are in an excel file. I am interested in plotting them all on a map to visualize patterns of distribution within a geographic area. I have Google earth. I would like to use a macro and save myself some life, but I'm not sure whether this is possible.

Can anyone help me?

Thanks in advance!
posted by jefficator to Computers & Internet (4 answers total) 6 users marked this as a favorite
 
Best answer: Have you looked at BatchGeo?
posted by pjaust at 7:06 AM on May 13, 2010


also this

gps babel
posted by freq at 7:08 AM on May 13, 2010


I made a similar request here. Maybe that will help.
posted by sanka at 8:48 AM on May 13, 2010


from Top 10 Things You Didn't Know Google Maps Could Do, Lifehacker also recommends BatchGeo for mapping multiple addresses (#1 on their list) - here's a video from the article.
posted by exhilaration at 9:02 AM on May 13, 2010


« Older Through-hiking alone: reasonable or reprehensible?   |   adventuring out of tokyo Newer »
This thread is closed to new comments.