Using Google maps to autocorrect a spreadsheet of badly formatted addresses

adhbrown

New Member
Joined
May 18, 2010
Messages
10
Hi guys,

Is it possible to upload a spreadsheet of badly formatted addresses and use google maps to autocorrect them to their proper addresses and address form?

Thanks in advance,
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,654
Office Version
365
Platform
Windows
If the addresses you have are badly formed how are you going to find the correct addresses using something like Google Maps?

Is there something in all the addresses, eg postcode, zipcode, that you can rely on as being correct?
 

baitmaster

Well-known Member
Joined
Mar 12, 2009
Messages
2,038
ah yes, crap addresses, the scourge of the data collector...

this might theoretically be possible, if you were really good at programming, and knew much about the inner workings of google maps. I personally don't, and suspect this will be a non-starter for you

best bet is to try and enforce decent data collection techniques, or maybe employ someone else on minumum wage to do it for you :(
 

adhbrown

New Member
Joined
May 18, 2010
Messages
10
Thanks for the help. If I could somehow get some address matching program to verify and autocorrect addresses. Google maps does a good job of doing this.

For example:

Bad address - 141 Piedmont Avenue, Savana, GA 30303

Correct address - 141 Piedmont Ave NE, Atlnata, GA 30303

Of course it would have to be in bulk.

Any ideas would be greatly appreciated.
 

West Man

Well-known Member
Joined
Mar 27, 2006
Messages
1,175
Google "address standardization software" - software which will convert addresses to US Postal standards
 

adhbrown

New Member
Joined
May 18, 2010
Messages
10
I've seen the software available for address standardization and validation. However, those solutions are very expensive especially if your running 100,000 addresses a month. Does anyone have any other ideas that might work or a less expensive solution?
 

Watch MrExcel Video

Forum statistics

Threads
1,102,551
Messages
5,487,522
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top