EZRoutePlanner

Spreadsheets & addresses

Why addresses land in the wrong place on a map (and how to fix them)

A pin in the wrong town, at the wrong end of the road or in the middle of a field: what causes it, how to spot it before you drive, and how to put the pin back where the door is.

EZRoutePlanner teamUpdated 7 min read

The short answer

Addresses land in the wrong place when the geocoder, the service that turns an address into map coordinates, can't find an exact match and settles for the closest thing it knows: the same street in another town, the middle of a ZIP code, or an estimated spot along the road. Adding the city, state and ZIP fixes most of them. For the rest, place the pin by hand.

Most common cause
A missing or wrong city, state or ZIP
Hardest addresses
Rural roads, new builds, PO boxes
Quickest check
Zoom out and look for pins far from the rest
Surest fix
Type the coordinates or drag the pin
On this page

01

What is geocoding, and why does it go wrong?

Geocoding is turning an address into a latitude and longitude, the point where a map puts the pin. A geocoder compares your text with its database of streets and address points and returns the best match it can find, along with how sure it is.

It goes wrong because the best match isn't always the right one. When the geocoder can't find the exact house, it falls back quietly, and each fallback puts the pin farther from the door:

What a geocoder falls back to
What it matchedWhere the pin goesHow far off it can be
The exact address pointOn or next to the buildingA few yards
The street and a house-number rangeAn estimate along the blockPart of a block; more on long rural roads
Only the street nameSomewhere on that streetUp to the length of the street
Only the ZIP code or townThe middle of the ZIP or townSeveral miles
The same street in another townThe wrong town entirelyTens or hundreds of miles
Typical behavior, not exact figures: every geocoder and every area is different.

The second row, called interpolation, is how many suburban and rural addresses are placed. The map knows a stretch of road holds numbers 100 to 198 and guesses that 150 sits halfway along. Houses aren't spaced evenly, so the guess can be off by a long driveway or more.

02

What are the most common reasons an address won't geocode?

Almost every misplaced pin traces back to one of these. Most are fixed by editing the text; a few need the pin placed by hand.

Common geocoding problems and fixes
CauseExampleFix
Missing city, state or ZIP412 Main StAdd them: 412 Main St, Ames, IA 50010
The same street name in many towns20 Maple Ave, NYAdd the town and the ZIP
ZIP code lost its leading zeroBrookline, MA 2446Store ZIPs as text: 02446
A PO boxPO Box 118, Dover, VTAsk for the physical address
A rural route boxRR 2 Box 40Ask for the 911 address on the mailbox
County road written differentlyCR 12, Co Rd 12, County Road 12Add the town and ZIP; try the other spellings
Highway with several names4410 Hwy 9, 4410 State Route 9Try the name the post office uses
New constructionA house finished this yearUse coordinates or drag the pin
Unit in the wrong place#4B 88 Pleasant StUnit after the street: 88 Pleasant St Apt 4B
Typos and swapped digits1081 Elm St for 1801Check against the invoice or customer record
Common geocoding problems and fixes

Postal towns that aren't the real town

A ZIP code's mailing city is often a bigger neighbor. Plenty of homes have a mailing address in one town while sitting in another township or an unincorporated area. Geocoders usually know both names, but if a pin lands in an odd spot, try the other one.

PO boxes and rural routes

A PO box is a box at the post office, so it geocodes to the post office or to the middle of the ZIP code, and you can't drive a service call to it. Rural route boxes have mostly given way to street-style 911 addresses; if a customer still gives you one, ask for the address on their mailbox.

New builds and business parks

Map data lags behind construction. A house finished last spring may sit on a street the geocoder doesn't know yet, so it matches the nearest known road or the ZIP center. Business parks, hospitals and campuses share one address across many buildings, and the pin lands on one of them, often not the loading dock or the door you need.

03

How do you spot wrong pins before you drive?

Look at the map, not the list. A wrong pin is usually obvious once you can see all of them together, and invisible in a column of text.

The five-minute pin check

  • Zoom out to the whole list. Any pin far from the others needs a look.
  • Look for stacks. Several pins on exactly the same spot, in the middle of a town or ZIP code, are partial matches.
  • Open the flagged ones first: anything marked uncertain, low-confidence or unmatched.
  • Check every new customer. Old addresses have usually been driven before; new ones haven't.
  • Zoom in on rural and commercial stops to make sure the pin is at the right driveway or building, not just the right road.
  • Compare the address it found with yours. A different street name or ZIP in the match gives the problem away.

04

How do you fix a wrong pin in EZRoutePlanner?

EZRoutePlanner looks up every address when you paste a list or import a spreadsheet, and shows them all on a review map before anything is saved. Rows it isn't sure about are flagged at the top, so you fix the doubtful ones while you're looking at them, not on the road.

  1. 1

    Search again

    Edit the address, usually by adding the missing town or ZIP, and pick the right match from the suggestions as you type.

  2. 2

    Type the coordinates

    When a place has no reliable address, such as a new build, a farm gate or a job site, enter its latitude and longitude instead.

  3. 3

    Drag the pin

    Move the pin onto the right building or driveway. The nearest address is found for you, so the stop still has a readable address on the route.

05

How do you find the coordinates of a location?

Coordinates are the surest fix because they skip the address lookup entirely. In Google Maps on a computer, right-click the exact spot and the latitude and longitude appear at the top of the menu; click them to copy. On a phone, touch and hold the spot to drop a pin, and the coordinates appear with it.

Coordinates as most tools expect them: latitude, longitude
42.33241, -71.12118
  • Latitude first, then longitude. Swapped, the pin lands somewhere else entirely.
  • Keep the minus sign. Longitudes across the mainland US and Canada are negative; drop the minus and the point is on the other side of the world.
  • Five decimal places is plenty. That's about a yard, more precise than any driveway needs.

06

How do you keep bad addresses out of your list?

Collect complete addresses at the source and keep them in one consistent shape. Every fix you make at intake is a wrong turn you don't make later.

  • Separate fields on your booking form for street, unit, city, state and ZIP, so nothing gets left out.
  • Store ZIP codes as text in your spreadsheet. How to combine address columns in Excel covers fixing the ones that already lost their zeros.
  • Ask rural customers for the 911 address and a landmark, and note which driveway is theirs.
  • Fix the spreadsheet too. When you correct an address on the map, update the source sheet so the next import starts right.
  • Clean the list before importing. The address list cleaner catches duplicates and stray spaces in seconds.

For the whole process from spreadsheet to pins, see how to map addresses from Excel.

Questions people ask

Why does Google Maps show the wrong location for an address?

For the same reasons as any geocoder: a missing town or ZIP, a street name shared by several towns, or an address too new for the map. If the address itself is wrong on Google Maps, you can report it with Suggest an edit, though changes can take a while to appear.

What does an uncertain or low-confidence match mean?

The geocoder found something, but not exactly what you typed: maybe the street without the house number, or a similar street name. The pin may be right or may be off, so check it on the map before you rely on it.

Can I put a PO box on a route?

Only as a trip to the post office. A PO box has no delivery location of its own, so it geocodes to the post office or the middle of the ZIP code. Ask the customer for the physical address of the site.

Why do several different addresses get the same pin?

Usually because only the town or ZIP code matched, so they all land on its center. Add the missing pieces and look them up again. Units in one building can legitimately share a pin.

Does an apartment or suite number change where the pin goes?

Usually not. Most geocoders place the building, not the unit. Keep the unit after the street so it shows up on the route, but don't expect it to move the pin.

How accurate is geocoding?

For a typical city or suburban address, close enough to find the front door. Rural roads, new subdivisions and large sites vary more, which is why a quick look at the map before a first visit pays off.

Plan your next route in minutes.

Paste your addresses or drop in a spreadsheet, optimize the order with one click, and send it to your phone. Free to start, no credit card.

Free plan. No credit card. Works in any browser.

Why Addresses Land in the Wrong Place on a Map (Fixes)