New Saw the Excel template in one of my videos? The Distance Calculator is an add-in now. What changed?

Calculate Distances for Hundreds of Addresses in Seconds

The Distance Calculator add-in writes real driving distances and travel times from Google Maps right next to your addresses, in any Excel workbook. Select your data, click once, done.

Get the add-in

One-time price. Windows, Mac and the web.

Reviewed by Microsoft Listed on Microsoft Marketplace

Start Address	End Address	Distance	Time
1600 Amphitheatre Pkwy	Apple Park, Cupertino	11.38 mi	18.2 min
10 Downing St, London	Edinburgh Castle	417.24 mi	461.4 min
Eiffel Tower, Paris	Louvre Museum, Paris	2.96 mi	13.7 min
Brandenburg Gate	Berlin Central Station	1.21 mi	7.9 min
40.7128,-74.0060	42.3601,-71.0589	215.08 mi	219.0 min

How are you getting distances into Excel today?

If the answer involves a second browser window and a lot of typing, this page will save you a few afternoons.

Doing it by hand

Copy an address into Google Maps, read the distance, type it back. Repeat 200 times.
One skipped row or one typo, and the whole column is suspect.
Latitude formulas measure straight through lakes and mountains, not along roads.
And the list changes next week, so you get to do it all again.

With the add-in

Select your data, say which column is the start and which is the end, click Calculate.
Real road distances and travel times from Google Maps, for every row at once.
Results land in tidy columns next to your data, ready for the report you actually came for.
New rows next week? Run it again. It can skip the rows that are already done.

See how it works

Three steps, and none of them is "learn something new".

Excel with the Distance Calculator task pane open and distance and travel time columns filled in next to a list of addresses

Walkthrough video is on its way

Select your addresses

Any two columns: full addresses, city names, postcodes, airports, even coordinates. Extra columns in between are fine. Clicking one cell inside your data is enough.

Pick start and end

Two dropdowns in the pane. The add-in reads your headers and usually suggests the right ones before you touch anything.

Click Calculate

Distance and travel time appear in new columns to the right, row by row as it runs. Interrupted halfway? Everything already calculated stays in the sheet.

Your addresses can look like anything

If Google Maps can find it, the add-in can use it. Anywhere in the world, and you can mix all of these in one list.

	A	B
1	Address	What it is
2	Addresses and places
3	1600 Amphitheatre Parkway, Mountain View, CA 94043	A full address
4	Hauptstraße 12, Heidelberg	Just street and city
5	90210, USA	A ZIP code with its country
6	SW1A 1AA	A postcode works too
7	Tokyo	Just a city
8	Sydney Opera House	A landmark or place name
9	JFK Airport	An airport
10	GPS coordinates
11	40.7128, -74.0060	Latitude, longitude
12	40.7128 N, 74.0060 W	With compass letters
13	40°42'46"N 74°00'22"W	Degrees, minutes, seconds
14	40° 42.767' N 74° 0.367' W	Straight off a GPS device

Start and end do not have to match, either: from a postcode to a landmark works just fine.

1 click

For a whole column of routes

10,000

Free Google lookups a month

25,000

Rows in a single run

14 days

No-questions refund

Made for the sheet you already have

Your columns, your units, your way of getting there. Every picture comes from real runs of the add-in, with real Google Maps results.

A delivery list with Customer, Delivery address and Depot columns. The pane maps Depot as the start column and Delivery address as the end column, and the distances are written into the next two columns.

Flexible

Works with your existing data

No template to copy your list into. Pick the start and end columns from the sheet you already have, in any order, even with other columns in between. The results land in new columns right next to your data.

Units

Miles or kilometers, minutes or hours

Pick the units your report needs once, and every run writes them. Distance and time can each get their own unit column, so nobody has to guess what 7.66 means.

Travel mode

Drive, walk, cycle or take public transit

The same trip can take 12 minutes or 46, depending on how you travel. Choose driving, walking, bicycling, public transit or two-wheeler, and switch on traffic-aware driving when today's roads matter.

Six routes with mixed inputs: a UK postcode, JFK Airport, a US ZIP code with its country, decimal coordinates, degrees minutes and seconds, and a German street address, each with its distance and travel time filled in.

Any format

Works with all kinds of data

Street addresses, postcodes, landmarks, airports and GPS coordinates, even mixed in one column. If Google Maps can find the place, the add-in can measure the route to it.

Prefer formulas? They are in there too.

Type it like any Excel function. =GMAPS.DISTANCE(A2, B2) for the distance, =GMAPS.TRAVELTIME(A2, B2) for the time.
Fill down like any formula. Drag the little green handle down the column and every row gets its distance.
Recalculating costs nothing. Results are cached, so a pair the add-in already knows is never sent to Google again.

	A	B	C	D
1	Start Address	End Address	Distance	Time
2	10 Downing St, London	Edinburgh Castle	417.24	461.38
3	Eiffel Tower, Paris	Louvre Museum, Paris	2.96	13.67
4	Brandenburg Gate	Berlin Central Station	1.21	7.93

Click any cell: the formula bar shows what is inside it. Travel mode and units are optional: driving, miles and minutes are the defaults.

Installed in about a minute

Straight from Microsoft's add-in store, inside Excel. No installer file, no macros to enable, and from then on it is there in every workbook.

1In Excel, go to Home → Add-ins → More Add-ins.
2On the Store tab, search for Distance Calculator by Bosau Digital.
3Click Add, open it from the Home tab and paste your license key and Google Maps key.

Reviewed by Microsoft Distance Calculator passed Microsoft's review before it went on Microsoft Marketplace: Microsoft's own validation team tested it in Excel on Windows, Mac and the web. See Distance Calculator on Microsoft Marketplace

Depending on your Excel version, look under Insert → Get Add-ins instead.

Windows, Mac and the web
No macro warnings
Updates arrive by themselves
Follows your light or dark theme

What you need

Three things, and two of them you have already.

Excel Microsoft 365, or Office 2021 and later.

Windows, Mac or a browser Excel on the desktop, or Excel on the web. Your pick.

A Google Maps API key Free to create. Comes with 10,000 lookups a month at no cost.

Never made an API key before? You are covered. After purchase you get a video that walks you through the setup, click by click. It is a one-time job of about 5 to 10 minutes, and every step is explained. And because the key is your own, there is no markup from the add-in on your lookups: Google bills you at Google's prices, which under 10,000 a month means paying nothing at all.

Your addresses go to Google, and nowhere else

The add-in uses your own Google Maps key, and your Excel talks to Google directly. There is no server of mine in the middle, and I never see your data.

No middleman Each lookup goes straight from your computer to Google Maps. Nothing is uploaded to me, ever.

Your key, your budget Google gives your key 10,000 free lookups a month, and the add-in takes no markup on top.

Keys stay on your side License and Google key are stored in your own Office profile, not inside the workbook. Share a file and they stay behind.

Pay once. Keep it forever.

No subscription, free updates, and no markup on lookups: your Google key pays Google directly, which under 10,000 a month means paying nothing.

Lifetime license

Single user

$69

one-time payment

One license key for 1 user on up to 3 computers
Batch runs and the GMAPS formulas
All travel modes, units and options
Excel on Windows, Mac and the web
Free updates, forever
Email support, usually within 24 hours

Get the single user license

Lifetime license

Team

$199

one-time payment

One license key for up to 15 users
Batch runs and the GMAPS formulas
All travel modes, units and options
Excel on Windows, Mac and the web
Free updates, forever
Email support, usually within 24 hours

Get the team license

14-day refund, no questions asked. If it is not for you, email me and you get your money back.

Excel on Windows
Excel on Mac
Excel on the web
Microsoft 365 or Office 2021 and later

Frequently asked questions

Do I need my own Google Maps key?

Yes, and that is a feature, not a catch. Your key means your addresses go straight to Google, there is no markup on your lookups, and Google includes 10,000 of them a month for free. Setting it up is a one-time job of about 5 to 10 minutes: after purchase you get a video that walks you through every step, and the add-in tests the key for you.

What does Google charge?

Google includes 10,000 lookups a month for free and charges beyond that. The add-in is careful with them: duplicate address pairs are only looked up once per run, formula results are cached so recalculating a workbook costs nothing, and there is a mode that skips rows which already have a result. You can also set a hard spending cap in your Google account.

Does it work on a Mac?

Yes. It runs in Excel on Windows, on Mac and in the browser at excel.office.com, with Microsoft 365 or Office 2021 and later. It is not available on iPad or in Excel 2019 and older, because those versions do not support the runtime the add-in needs.

What can the addresses look like?

Almost anything Google Maps understands: full street addresses, place names ("Eiffel Tower"), city names, postcodes, airports ("JFK Airport"), and coordinates in decimal or degree notation. You can mix formats freely in the same column. A short code on its own can be ambiguous, so give a bare ZIP code its country ("90210, USA").

How many rows can it handle?

Up to 25,000 rows in a single run, and you can run it as often as you like. Results are written into the sheet as the run goes, so if you cancel or something interrupts it, everything calculated so far is already saved. Run it again with "skip rows that already have results" on and it finishes only what is missing, without paying Google twice.

Which travel modes are there?

Driving, walking, bicycling, public transit and two-wheeler. For driving you can switch on traffic-aware estimates, which use current road conditions instead of typical ones. Distances come back in miles or kilometers, times in minutes or hours.

Does Google bill me separately?

Your license covers the add-in and its updates. Google bills API usage separately if you exceed its free allowance. See the pricing table for add-in license options.

How do I install it?

From Microsoft's add-in store, right inside Excel: go to Home, Add-ins, More Add-ins, search the Store for Distance Calculator and click Add. The listing itself is free to install; your license key unlocks it. No installer file, no admin rights on most setups, and updates arrive through the store by themselves.

Can our IT department install it for everyone?

Yes. An admin can deploy it to people or groups from the Microsoft 365 admin center (Settings, then Integrated apps), and it appears in Excel on Windows, Mac and the web by itself, so nobody installs it by hand. That needs a Microsoft 365 plan with Exchange Online mailboxes, and a fresh rollout can take up to a day to reach everyone. Each person still enters the license key and their own Google Maps key once.

I have the old Excel template version. What about it?

The add-in is the successor to the Distance Calculator macro workbook. Same job, but it works in every workbook instead of one fixed file, runs on Mac and in the browser too, adds the GMAPS formulas, and updates itself. And here is the good part: your existing license key works in the add-in as it is. Install the add-in, paste the key you already have, done. No new purchase, and the template keeps working too, so you can switch whenever it suits you.

Is there a free version?

For small, one-off jobs there is the free bulk distance calculator on this site: up to 25 routes at a time, three runs a day, right in your browser, with no sign-up and no Google key. The add-in is for everything beyond that: your own workbooks, thousands of rows in one run, and the GMAPS formulas.

What if I get stuck?

Email me at sven@pythonandvba.com. You are writing to the person who built it, not a ticket queue, and I usually reply within a day. There is also a step-by-step guide and a help page right inside the add-in.

Do you offer a refund?

Yes, 14 days, no questions asked. Email me at sven@pythonandvba.com.

Still have a question?

I’m Sven, the developer, and I usually reply within a day.

Ready to stop looking them up one by one?

Calculate distances and travel times directly in your workbook.

Get the Distance Calculator add-in

Google and Google Maps are trademarks of Google LLC. Microsoft, Excel and Microsoft 365 are trademarks of Microsoft Corporation. This product is made by Bosau Digital LLC and is not affiliated with or endorsed by Google or Microsoft.