Spreadsheets are the best way to gather and organize information in standard form. If you’ve got a whole host of options to keep track of in different locations, the clever Maps/spreadsheet mashup BatchGeo will take your spreadsheet and plot it out across a Google Map. Simply paste your spreadsheet data, and BatchGeo standardizes the addresses and creates a custom My Map, filled with your locations and each one retaining the other data you plugged in about it. It’s a fast way to make it look like you did a whole bunch of work, and that’s never a bad thing. And while it’s not technically a Google Maps feature, we think it should be.
I tried it with a standard address list in Excel. I just copied the data and pasted it into BatchGeo and presto.
Map pushpins are clickable and show pertinent info. Very easy to use.