Addresses from phone numbers.

April 9, 2008 3:12 AM

I've got a list of phone numbers (xxx-xxx-xxxx) that I need addresses for. I know I can Google them, one at a time, and get the addresses, but is there a way I can do them in batches?
posted by Framer to computers & internet (8 comments total)

What country are the numbers from? It might matter.
posted by flibbertigibbet at 3:58 AM on April 9

you could set up an excel worksheet with them and have a field that queries google, then copy paste it all the way down?
posted by thilmony at 5:02 AM on April 9

They're U.S. phone numbers.

thilmony -- can you explain how to create a field that queries Google?
posted by Framer at 5:22 AM on April 9

I'm not thilmony, but here's a primer.
posted by jtfowl0 at 6:47 AM on April 9 [1 favorite]

If you're willing to pay, Melissa Data should be able to help.
posted by qvtqht at 9:50 AM on April 9

sorry I just checked back. jtfowl0 linked to a good resource. I'll build a tiny spreadsheet and email it to you and get it to work and post the cell formula if i get a chance.
posted by thilmony at 10:29 AM on April 9

That would be fantastic, thilmony. In case you do get to it, I just mefi-mailed you my email address, since I don't think attachments go through mefi-mail.
posted by Framer at 11:22 AM on April 9

411.com has good info -- if you want to pay. All you do is download a spreadsheet and give them a credit card.
posted by Mr. Justice at 3:58 PM on April 9