Announcement

Collapse
No announcement yet.

Extract data from website in an Excel Spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!!!

  • #2
    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
    I am not an expert. better solutions may be available. [email protected]$$$gmail.com

    Comment


    • #3
      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

      Comment

      Working...
      X