Pulling web data not in table form

I am looking to pull info from a website. This info is not in table form. This info comes from https://soilseries.sc.egov.usda.gov/OSD_Docs/G/Glencoe.html 

I was wondering if I could pull this whole webpage into excel and then do a VLookup to pull a certain row/column/cell. 

I have tried the Data From Web function but I get errors when the navigator box pops up. 


Any help would be appreciated



By: Kolin

22 thoughts on “Pulling web data not in table form

  1. Kimberley Price

    Hi Kolin,

    So, I would highlight the text to copy.
    When you right click to copy – Click the “Match destination formatting”

    From here, click on data, text to column, then depending on how you want to separate your data;
    For example I would recommend using “–” as the seperator.
    -Click on Data
    -Click on Text to Columns
    -Click on Delimited
    -Click on Other
    -Insert “-” in the box next to other
    -Click Finish

    Then amend manually as required.

    (I’m sure someone may come up with a better idea!)

    Kind Regards,

  2. plenty of fish dating site

    Nice post. I was checking constantly this blog and I am impressed!

    Extremely useful information specially the last part 🙂 I
    care for such info much. I was seeking this particular info for
    a long time. Thank you and best of luck.

  3. ps4 games

    Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage?
    My blog site is in the very same area of interest as yours and my users would truly
    benefit from a lot of the information you present here.

    Please let me know if this ok with you. Thanks!

  4. quest bars cheap

    You really make it seem so easy with your presentation but I find this topic to be really something
    that I think I would never understand. It
    seems too complicated and very broad for me. I’m looking forward
    for your next post, I’ll try to get the hang of it!

  5. ps4 games

    I was very pleased to find this site. I need to to thank you for ones time just for
    this wonderful read!! I definitely liked every bit of it and I have
    you book-marked to check out new things in your web site.

  6. ps4 games

    It’s actually a nice and useful piece of information. I am happy that you shared this useful information with
    us. Please stay us informed like this. Thanks for sharing.

  7. match.com free trial

    I think that is one of the most important info for me.
    And i am glad reading your article. But want to remark on few normal issues, The site taste is ideal, the articles is actually nice :
    D. Just right activity, cheers

  8. sling tv

    Hi there to every one, the contents existing at this website
    are in fact awesome for people experience, well,
    keep up the good work fellows.

  9. sling tv

    Having read this I thought it was really enlightening.
    I appreciate you spending some time and energy to put
    this content together. I once again find myself
    spending way too much time both reading and leaving
    comments. But so what, it was still worthwhile!

Leave a Reply

Your email address will not be published. Required fields are marked *