Here’s my first attempt at using Google maps in excel (download below). Currently I can input an address and have a Google map of the address displayed in Excel, with most of the cool google functionality.

A couple thumbnails of the Excel Google Map Spreadsheet, click to view the larger images.

Normal View

google maps and excel

Zoomed Hybrid View


The Google Map Spreadsheet uses two API’s to work, the Api and Google Maps Api. I thought about also throwing in the current weather report, but refrained for now.

So how does it work?


1. The address is sent to to be converted to Latitude and Longitude (required to map a location on google maps), and the result is returned to the spreadsheet.

2. Excel sends this geocoded information to the server, where I have a google map that receives latitude and longitude as variables and displays the respective map via the Google Map API.

3. Finally there’s a web browser control in Excel that navigates to this new address.

A bit more:

1. To experiment with sending an address and having return the Latitude and Longitude back to Excel, I created a Geocoding workbook to experiment with.

2. Click this link to see my webpage that receives latitude and longitude as variables and returns the respective map (look in the address bar). If you’d like to create a similar page you can view my page code here: googlemap.txt. (Yep, it’s hacked together. Remember to input your own Google API Key in the Head section.)

3.I set margin:0px to remove the whitespace around the map, trying to make it look less like a web browser control and more like a google control.


To use the spreadsheet you’ll need Excel 2003. That’s what I’ve tested it on, for Excel 2002 I believe the “import vba code” is slightly different and minor tweaking will be needed.

To create your own solution you’ll need a Google Developer Key, a Website to host the page, and Excel 2003.

download excel

Click this link to download the Google Map in Excel Spreadsheet


A Canadian Google Maps In Excel that works with pre-2003 Excel versions.


-You can do much more with google maps than just plotting points, I particularly like this example: gMap Workout Tracker

-Microsoft unveiled their new mapping service this week: Virtual Earth (Opens in new window since they have the back button disabled). The satellite imagery in my neighborhood is much nicer than google maps, and the interface has some additional cool tricks. I haven’t tried the virtual earth api yet.
canadian google maps in excel Gyula Gulyas took my original Google Maps in Excel and made two changes to it that some readers may be interested in:

1. It provides a US and Canada interface

2. It uses Microsoft XML, V3.0, so it works with a couple versions of Excel prior to 2003

download excel

Canadian GoogleMap Excel 2000

Very cool! Gyula made use of for the goecoding of Canadian addresses.

You can send any “comments/code improvements/ suggestions” directly to: gygulyas -at-

I’ve been to a few spots in Ontario and always enjoy Canada.

A couple years ago leaving Toronto I ended up in upstate New York instead of Kentucky, just a bit off (no I wasn’t the only one in the car 🙂 so I’m sure I can use the Canadian version.