Excel Geography Data Type Driving Distance — It Cannot Calculate Road Miles
Updated September 2026 | By Excel Distance Calculators
You converted a city list with Data > Geography, extracted a number that looked like miles, and almost paid crews on it. Stop. Excel's Geography data type does not calculate driving distance. Geography is a linked data type, not a routing engine. Microsoft does not give you road miles from that button.
This post is the mismatch: what Geography actually returns, why straight-line math is not payroll, and how to get Google driving distance in the sheet you already have. For the click-by-click road-miles workflow, use How to Calculate Driving Distance Between Two Addresses in Excel.
What Geography actually returns
Select city, state, country, or zip cells. Data tab. Data Types. Geography. Excel matches the text to an online source and stamps a map icon. That match is a linked data type — Microsoft's words — not a drive from A to B.
Microsoft's examples are place names: country, province, territory, city. The list also includes zip code and county. Powered by Bing. The card shows attributes. Microsoft's docs call out population, time zone, area, capital, and leader. Pull latitude and longitude with Insert Data or =A2.Latitude.
Scroll the card. There is a "Powered by" note. There is not a driving-distance field, travel time, or a To/From pair. Microsoft Q&A staff put it plainly: Excel has no native function like =MILEAGE() because Excel does not know the road map or traffic between two points.
- What you get — a matched place plus attributes (population, time zone, area, lat/long)
- Microsoft's own distance example — lat/long from the data type, then a formula. Excel Program Manager Chris Gross named that lambda ASTHECROWFLIES (law of cosines)
- What you do not get — road miles, drive time, street-level routing
- Street addresses — Microsoft's walkthroughs start with city/state/country, not a jobsite street file. Street strings often fail to convert
Real-World Example: An operations analyst converted a city column with Data > Geography, pulled coordinates, and ran a spherical-distance formula so every crew row had "miles." Payroll used that column. Drivers were paid on crow-flies numbers. Roads go around mountains, lakes, and one-way grids. On a published Salt Lake City, UT → Denver, CO city pair, Travelmath lists about 371 straight-line miles versus 521 driving miles — a 150-mile gap on one trip. Multiply that across a weekly crew file and you are not off by rounding.
How an Analyst Uses This: Data > Geography felt like the built-in answer for a city list. It is the right button for population, time zone, or a lat/long you want to chart. It is the wrong button the moment the number hits a pay file. Paste the same To and From addresses into the Excel Driving Distance Calculator, click Calculate, and Google Maps writes road miles and drive time back into the sheet. One-time $97 single user / $187 multi-user. Keep Geography for attributes. Payroll uses the road column.
Straight-line vs road
Straight-line (great-circle) is the shortest arc over the globe. Road miles follow the network. Geography can feed the first. It cannot produce the second. A one-off browser check is a different job — see Excel Distance Calculator vs Google Maps. This article is only about why the Geography button is not that check.
| Straight-line / Geography math | Road / Google driving | |
|---|---|---|
| What it measures | Great-circle ("as the crow flies") between two points | The drive on the road network |
| Where the points come from | Geography lat/long on a matched city, state, or zip — not a street route | Google geocodes the To and From text, then routes |
| Built into Excel? | Linked Geography type + a formula you write | No native function (Microsoft Q&A) |
| Drive time | No | Yes, with the miles |
| Pay crews on it? | No. You underpay the road. | Yes. That is the number they drove. |
| SLC → Denver (published city pair) | ~371 miles (Travelmath flight / straight-line figure) | ~521 miles driving on the same listing |
Those Salt Lake–Denver figures are published city-to-city numbers, not your payroll pins. Street addresses will move a few miles. The gap does not disappear. Matching "Denver" and "Salt Lake City" still pays on a city centroid, not the jobsite gate.
Bulk To/From in the flagship file
You do not need a new formula. You need the sheet to call Google Maps for every row. Open the Excel Driving Distance Calculator .xlsm. Enable macros. Paste real To and From addresses — crew home to jobsite, warehouse to delivery. Click Calculate.
Google Maps fills driving distance and travel time back into the columns, to the 1/100th of a mile. Your list stays in your file. Your API key stays in your Google account. Google's $200 monthly credit covers about 40,000 lookups. A weekly crew file is nowhere near that. Zoom setup for the key is included. Call (801) 243-8350 if you would rather not click Cloud Console alone. 30-day refund if it is the wrong tool.
Need coordinates for a map, not miles for a paycheck? Geography can emit lat/long for places it recognizes. For a street-address list, that is the side-line job of the Excel Latitude/Longitude Generator (GeoCoder). Do not use GeoCoder — or Geography — as a substitute for road miles.
Frequently Asked Questions
Can the Excel Geography data type calculate driving distance?
No. Microsoft documents Geography as a linked data type (powered by Bing) that returns place attributes such as population, time zone, area, and coordinates. Microsoft's own city-distance example from those coordinates is as-the-crow-flies math. Road miles require a mapping API — what the Driving Distance Calculator calls from your To/From columns.
Why doesn't Data > Geography match my street addresses?
Microsoft's walkthrough starts with country, province, territory, or city. Zip codes can convert too. Street-level payroll addresses are a different problem. If the icon never appears, Excel did not match a place. Even when it matches a city, you still do not have the drive to the jobsite.
What should I use instead for a crew To/From list?
Paste the pairs into the Excel Driving Distance Calculator and click Calculate. $97 / $187, one-time. Google driving distance in the sheet you already have. Keep Geography for attributes. Keep payroll on the road column.
Ready to Stop Doing It the Hard Way?
Get the Excel Driving Distance Calculator — $97 single user / $187 multi-user, one-time. You already tried the built-in Geography button. It is not road miles. Paste To and From, click Calculate, get Google Maps miles and time in the sheet. Free Zoom to set the API key. Questions? Call (801) 243-8350.
Excel Distance Calculators builds Excel-based tools that connect directly to Google Maps for driving distances, geocoding, route optimization, and more. Used by logistics companies, trucking fleets, healthcare providers, field service teams, and thousands of businesses worldwide. No coding required — just paste your data and click.
