Map addresses in a Google spreadsheet

The free Map a List service converts addresses in a spreadsheet into a custom Google map.

If you store street addresses in a spreadsheet, you can now plot those addresses on Google Maps in just seconds, with no programming required. And doing so won't cost you a cent--unless you volunteer a contribution to the people behind the Map A List beta service that makes it all possible.

Start by pasting your addresses into a Google Docs spreadsheet. (If you don't already have a Google account, you'll have to create one, but doing so is also free.) Give the spreadsheet separate columns for the location name, street address, city, state, and ZIP code. Make sure you don't leave any blank columns at the top of the spreadsheet.

Next, browse to the Map A List site and create an account by entering an ID, password, e-mail address, security question, and ZIP code. Once your account is in place, choose Maps > Create on the site's home page.

The first step in the map-creation process is to choose a source. At present, the only option is Google Spreadsheet. After you grant the service access to your Google Docs account, you'll see your spreadsheets listed in a drop-down menu. Select the one that contains the addresses you want to map. If the spreadsheet has only one worksheet, it will be chosen automatically. Otherwise, you'll be prompted to select the worksheet with the addresses. Map A List will display the fields it will show on the map.

Map A List mapping service
The free Map A List service lists the spreadsheet fields it will include in your custom Google map. Map A List

If you're happy with the fields Map A List presents, click Next to view and confirm the fields containing the address information to be shown on the map. You can change the order of the fields and set the field that will be displayed in the balloon pop-up for each map pinpoint.

Map A List settings for map display
Change the order of the map fields and set the row that will be displayed in the map's pop-up balloons. Map A List

Once the field settings are in order, click Next. The service will generate the geocodes for the addresses. If the addresses are in order, you'll see the "Total Success!" message. Click Next to open the Configure Map settings. Make your selections in the two drop-down menus and go with the default pin or change the icon that will denote each address. You can get a peak at the resulting map by clicking Preview Map, or click Next to open a page with additional settings.

Here you can change the name of your map, choose the view (Satellite, Hybrid, Physical, or Normal), select the default zoom, and set the content to be shown in the footer. You can also make the map public or private and alter its appearance in other ways. When you're done, click Save & View Map.

Map A List map of addresses in a Google spreadsheet
View the map displaying your spreadsheet's addresses, complete with all the Google Maps trimmings. Map A List

Hover over a pinpoint to view whichever field you selected as your Title in Step 2 of the map-creation process. Click the pinpoint to view whichever fields you chose to display in Step 4, use the zoom controls to move the view in or out, and switch views between normal, satellite, hybrid, and terrain, just as you would with any Google map.

About the author

    Dennis O'Reilly began writing about workplace technology as an editor for Ziff-Davis' Computer Select, back when CDs were new-fangled, and IBM's PC XT was wowing the crowds at Comdex. He spent more than seven years running PC World's award-winning Here's How section, beginning in 2000. O'Reilly has written about everything from web search to PC security to Microsoft Excel customizations. Along with designing, building, and managing several different web sites, Dennis created the Travel Reference Library, a database of travel guidebook reviews that was converted to the web in 1996 and operated through 2000.

     

    ARTICLE DISCUSSION

    Conversation powered by Livefyre

    Don't Miss
    Hot Products
    Trending on CNET

    Hot on CNET

    Saving your life at speed and in style

    Volvo have been responsible for some of the greatest advancements in car safety. We list off the top ways they've kept you safe today, even if you don't drive one.