Is there anyway to take a bunch of addresses in, say, an Excel spreadsheet and have Google put them all on a single map to print out?
Also, is there a program that can plan the shortest route between a bunch of addresses- kind of a “traveling salesman” type problem (and also take the addresses from said Excel spreadsheet)?
I’ve used this site before for mapping multiple locations:
Not sure about a site or program that will satisfy your second requirement.
Not much help but I have a Garmin 2720 which will sort out the best route around any number of via-points and conclude the trip at home or your office.
See, not much help.
Actually, Google now has My Maps that allows you to custom make your maps. You have to be a registered user of Google, but it is actually pretty cool. I made this map of the Temecula Wineries that we wanted to visit on our Easter trip there.
Another non-recommendation:
I’ve seen DeLorme StreetAtlas provide some really silly routing* just for A->B, so you could eliminate that from consideration.
*I have seen it advise to get on an interstate the wrong direction, go 2 miles the wrong way, turn around, and then finally backtrack toward the goal. It seems to use the first turn that can possibly be used to reach the goal, no matter how much more direct a route is available.
Yeah, but is there a way to import addresses from Excel, or do you have to put them in manually?
I’m wondering this too. I can’t figure out how to input more than one address at a time. Ditto for Google Earth. I had to map like 50 addresses at the same time, which I could do once the addresses were all saved, but I could only figure out how to input them one at a time.
Google Earth/Maps will easily do this given a set of coordinates in a kml file, or manually placed placemarks, but I don’t know about batch geocoding addresses, especially from a random excel file.
The main problem is that the way addresses are stored in different databases freqently requires user input/validation on search/queries. If your excel spreadsheet input matches the database record for that address, great, but what if it does not? Is the third record “25 North Second Street” or “25 N 2nd”. Databases and their ability to parse user queries have come a long way , but addresses are notoriously difficult to get right.
Microsoft Streets and Trips will do both of these things in the twinkle of an eye, although in its own map, not in Google.
One Day Fish Sale’s link does just that for Yahoo Maps. Does it HAVE to be Google?
ODFS’s link worked great. And it automatically saves the data to a .kml file for use in Google Earth.