# Phonebook to excel.... I need assistance. **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [October 12, 2008, 6:35pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318 "2008-10-12T18:35:27Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 12, 2008, 6:35pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/1 "2008-10-12T18:35:27Z")
I want to be able to transfer an online phone book to an excel file. Lets say I want to use [411.com](http://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? ---
**Author:** ![66impalass](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/66impalass/32/7429_2.png) [@66impalass](https://forums.speedlife.net/u/66impalass)\ **Post date:** [October 12, 2008, 6:48pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/2 "2008-10-12T18:48:18Z")
hire an asain dude to do it, they are good with numbers. ---
**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\ **Post date:** [October 12, 2008, 6:50pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/3 "2008-10-12T18:50:55Z")
buy a list from d&b ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 12, 2008, 6:53pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/4 "2008-10-12T18:53:18Z")
D and B? Zong… wanna make a couple extra bucks? ---
**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\ **Post date:** [October 12, 2008, 6:54pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/5 "2008-10-12T18:54:17Z")
your work should have a database to work out of… ---
**Author:** ![JUICEDSS](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/juicedss/32/7185_2.png) [@JUICEDSS](https://forums.speedlife.net/u/JUICEDSS)\ **Post date:** [October 12, 2008, 6:55pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/6 "2008-10-12T18:55:12Z")
Post a link to your results from your search. ---
**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\ **Post date:** [October 12, 2008, 6:56pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/7 "2008-10-12T18:56:50Z")
copy the search URL, open excel, select tools, data, import from html… etc ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 12, 2008, 7:02pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/8 "2008-10-12T19:02:02Z")
[http://www.411.com/search/Replay?search\_id=71121370719107208719&form\_mode=&show\_truncated=1](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… ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 13, 2008, 8:00am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/9 "2008-10-13T08:00:14Z")
Bump for day crew? ---
**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\ **Post date:** [October 13, 2008, 8:07am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/10 "2008-10-13T08:07:38Z")
copy/paste ---
**Author:** ![justa4door](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/justa4door/32/7259_2.png) [@justa4door](https://forums.speedlife.net/u/justa4door)\ **Post date:** [October 13, 2008, 8:11am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/11 "2008-10-13T08:11:20Z")
you could have had it done by now …if you did it the old school way ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 13, 2008, 8:20am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/12 "2008-10-13T08:20:51Z")
yea… lol… THERE HAS TO BE AN EASIER WAY THOUGH! ---
**Author:** ![justa4door](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/justa4door/32/7259_2.png) [@justa4door](https://forums.speedlife.net/u/justa4door)\ **Post date:** [October 13, 2008, 8:22am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/13 "2008-10-13T08:22:23Z")
im sure there is but not to a stock excel… just get it into a word doc and make life easer ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [October 13, 2008, 8:26am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/14 "2008-10-13T08:26:54Z")
They need to be divided up into rows and columns though. ugh. ---
**Author:** ![JayS](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jays/32/15375_2.png) [@JayS](https://forums.speedlife.net/u/JayS)\ **Post date:** [October 13, 2008, 8:29am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/15 "2008-10-13T08:29:41Z")
> [@Willybeen](#): > > yea… lol… THERE HAS TO BE AN EASIER WAY THOUGH! 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. ---
**Author:** ![justa4door](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/justa4door/32/7259_2.png) [@justa4door](https://forums.speedlife.net/u/justa4door)\ **Post date:** [October 13, 2008, 8:30am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/16 "2008-10-13T08:30:27Z")
[http://www.freedownloadscenter.com/Information\_Management/Contact\_Management\_Tools/My\_PhoneBook.html](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](http://www.smithmicro.com/default.tpl?group=product_full&sku=QPMWA0EE) ---
**Author:** ![greenbull](https://avatars.discourse-cdn.com/v4/letter/g/bc8723/32.png) [@greenbull](https://forums.speedlife.net/u/greenbull)\ **Post date:** [October 13, 2008, 8:31am UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/17 "2008-10-13T08:31:51Z")
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 ---
**Author:** ![frofan](https://avatars.discourse-cdn.com/v4/letter/f/9de053/32.png) [@frofan](https://forums.speedlife.net/u/frofan)\ **Post date:** [October 13, 2008, 4:16pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/18 "2008-10-13T16:16:33Z")
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](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”. ---
**Author:** ![ryanmcell](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ryanmcell/32/7510_2.png) [@ryanmcell](https://forums.speedlife.net/u/ryanmcell)\ **Post date:** [October 13, 2008, 5:54pm UTC](https://forums.speedlife.net/t/phonebook-to-excel-i-need-assistance/56318/19 "2008-10-13T17:54:26Z")
Pay someone on the forum, seems there are a lot of people who will do anything for a few extra bucks on here.