Phonebook to excel.... I need assistance.

NYSpeed Automotive NYSpeed Off Topic
1

I want to be able to transfer an online phone book to an excel file.

Lets say I want to use 411.com and look up Main st in buffalo. I use the reverse lookup to get all the residents on the street. But i dont feel like typing them into an excel file one by one, is there an easy way to put them into excel?

btw I need them broken up by name, address, city, zip, and phone number.

It cant be one Column with all the info, it needs to be broken up.

Any help?

2

hire an asain dude to do it, they are good with numbers.

3

buy a list from d&b

4

D and B? Zong… wanna make a couple extra bucks?

5

your work should have a database to work out of…

6

Post a link to your results from your search.

7

copy the search URL, open excel, select tools, data, import from html… etc

8

http://www.411.com/search/Replay?search_id=71121370719107208719&form_mode=&show_truncated=1

lets use that as an example… I dont want all the other shit I just want…

Kibler, James D
341 Meadow Dr
Buffalo,
NY
14224-1569
(716) 674-3888
in that format…

9

Bump for day crew?

10

copy/paste

11

you could have had it done by now …if you did it the old school way

12

yea… lol… THERE HAS TO BE AN EASIER WAY THOUGH!

13

im sure there is but not to a stock excel… just get it into a word doc and make life easer

14

They need to be divided up into rows and columns though. ugh.

15

The specifically code it to make it difficult because they don’t want people using their database without visiting their site and seeing their ads. If you view the page source (Click on view, Page Source in FF, or View, Source in IE) the data would be pretty easy to parse out programatically…

  	common_ad.swap_values(
  		"resultslink_1",
  		'FIRST',       "James",
  		'LAST',        "Kibler",
  		'ADDRESS',     "341 Meadow Dr",
  		'CITY',        "Buffalo",
  		'STATE',       "NY",
  		'ZIP',         "14224",
  		'FIRST_ESC',   "James%20D",
  		'LAST_ESC',    "Kibler",
  		'ADDRESS_ESC', "341%20Meadow%20Dr",
  		'CITY_ESC',    "Buffalo",
  		'STATE_ESC',   "NY",
  		'ZIP_ESC',     "14224",
  		'STREET_ESC',  "Meadow%20Dr",
  		'HOUSE_ESC',   "341"
  	);

The big problem I see there is that they show limited results per page, so you’d need to pull the source for each page.

16

http://www.freedownloadscenter.com/Information_Management/Contact_Management_Tools/My_PhoneBook.html

this looks like a excel file one

http://www.smithmicro.com/default.tpl?group=product_full&sku=QPMWA0EE

17

100 listings is not that bad to go through.

and a lot of those address’ have multiple residents listed

but…have fun with that shit

18

Parsing html from that site would be tricky. It would take a while to write a program to do it. If you are just looking for a list of valid addresses, try http://zip4.usps.com/zip4/welcome.jsp. Enter a street name, city, and state and it will give you the range of addresses on that street. You can address the mailing “Current Resident”.

19

Pay someone on the forum, seems there are a lot of people who will do anything for a few extra bucks on here.