Can you convert an address to a zip code in a spreadsheet?
Posted
by moe37x3
on Super User
See other posts from Super User
or by moe37x3
Published on 2010-01-06T15:36:55Z
Indexed on
2010/05/10
21:25 UTC
Read the original article
Hit count: 199
Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this?
I'm dealing with US addresses, but answers pertaining to other countries are interesting, too.
UPDATE: I guess I'm mostly hoping that there's a way to do this in Google Spreadsheets. I realize that you need to access a vast ZIP code database to do this, but it seems to me that such a database is already inside Google Maps. If I put an address in there without ZIP code, I get back an address with ZIP code. If Maps can do that lookup, maybe there's a way to make it happen in Spreadsheets, too.
© Super User or respective owner