Using Google maps to autocorrect a spreadsheet of badly formatted street addresses

Hi guys is it possible for google maps or any other program to autocorrect a spreadsheet of badly formatted street addresses into ones that are formatted and correct?

For example, one bad address might be:

80 riverside dr. ny, ny 20678

The actual address is:

80 Riverside Dr, New York, NY 10024, USA

I have about 5000 entries in my spreadsheet and it would take forever for me to check them manually.

Thanks in advance,

Not sure what the US Postal Service has available for free to the general public... http://www.usps.com/ncsc/

Hello

This certainly possible using any of the major mapping Apis. You can download an example of to use all of them .. It includes a finished app you can use as is.. Directly from excel.

See http://ramblings.mcpher.com/Home/excelquirks/getmaps

Originally Posted by adhbrown

Hi guys is it possible for google maps or any other program to autocorrect a spreadsheet of badly formatted street addresses into ones that are formatted and correct?

For example, one bad address might be:

80 riverside dr. ny, ny 20678

The actual address is:

80 Riverside Dr, New York, NY 10024, USA

I have about 5000 entries in my spreadsheet and it would take forever for me to check them manually.

Thanks in advance,