Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Extract data from website in an Excel Spreadsheet

  1. #1
    Join Date
    18th December 2011
    Posts
    1

    Extract data from website in an Excel Spreadsheet

    My Excel Spreadsheet has columns named "Hospital Name | Overview | Address | Phone | Fax | Contact Person 1 | Contact Person 1 Title | Contact Person 2 | Contact Person 2 Title | Contact Person 3 | Contact Person 3 Title"

    I have a website i.e.
    http://biz.yahoo.com/ic/524_cl_all.html

    Whenever I click on any hospital name, it gives me my required information and I would like to extract so that it adds each record after record in the following manner:

    This text should go in column named "Overview": Abbott Northwestern Hospital helps bring twins into the Twin Cities -- along with triplets, quadruplets............

    This text should go in column named "Address": 800 E. 28th St.Minneapolis, MN 55407

    This text should go in column named "Phone": 612-863-4000

    This text should go in column named "Fax": 612-863-5667

    This text should go in column named "Contact Person 1": Jeffrey D. (Jeff) Peterson

    This text should go in column named "Contact Person 1 Title": President

    This text should go in column named "Contact Person 2": Daryl Schroeder

    This text should go in column named "Contact Person 2 Title": VP Operations

    This text should go in column named "Contact Person 3": Sandy Schmitt

    This text should go in column named "Contact Person 3 Title": VP Strategic Development, Allina Hospitals and Clinics


    Please help!!!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    13th May 2006
    Location
    India
    Posts
    978

    Re: Extract data from website in an Excel Spreadsheet

    it is possible to download the data from the web page using data-import external data-new web query in excel sheet and then manipulate to put them in slots. for more than one institution you can loop trouth the institutions.

    in the web address there is a common part and particular part fo particular hospitals
    for e.g.
    for abhington hospital the web page
    http://biz.yahoo.com/ic/109/109872.html
    http://biz.yaho.com/ic/ common part 1
    .html ---- common part2
    particular part 109/109872

    for abbot hospital
    http://biz.yahoo.com/ic/123/123489.html
    the common part is same

    particular pat is
    123/123489

    unfortunately the webpage is not designed in tables for easy translation into excel sheet. some manipulation is requaired. anoher poimnt is each hospital has numbers(like symbols in scrips). Perhaps your can download the numbers

    It is possible but may be elaborate

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Extract data from website in an Excel Spreadsheet

    Hello sh_obaid,

    Welcome to Ozgid. While we're glad to have you as part of the community, take some time to read the Forum Rules.

    Cross posting without providing a link to the other thread is a violation of the Forum Rules. We prefer you do not cross post, but when doing so you are obligated to provide the link per your agreement to abide the rules of this forum. (All Excel forum have a similar rule about cross posting.)

    You cross posted here: VBA Express - Extract data from website in an Excel Spreadsheet

    Please update your post to include links to all forums where you have asked for help on this topic.

    To understand why this practice is not acceptable, click on "Message to Cross Posters" in my signature and read that page in full.

    Future violation of the rule may result in automatic deleting or locking of your thread and will result in infractions given.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 82
    Last Post: September 17th, 2010, 22:36
  2. Replies: 1
    Last Post: November 14th, 2009, 07:14
  3. Replies: 3
    Last Post: July 18th, 2006, 13:50
  4. Pulling data off a website into a spreadsheet
    By londoner in forum EXCEL HELP
    Replies: 1
    Last Post: March 28th, 2006, 22:18
  5. Extract Japanese from an Excel spreadsheet
    By themanjd in forum EXCEL HELP
    Replies: 4
    Last Post: May 24th, 2003, 05:25

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno