+ Reply to Thread
Results 1 to 6 of 6

Web Site Data Parsing/Extraction

  1. #1
    Registered User
    Join Date
    02-28-2024
    Location
    Michigan, USA
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Web Site Data Parsing/Extraction

    Hello,
    Has anyone here used Excel to parse or otherwise extract data from a web site? For example, collecting local weather information from the National Weather Service.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,541

    Re: Web Site Data Parsing/Extraction

    Hi and welcome. have you tried using Power Query?

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Web Site Data Parsing/Extraction

    You posted in the Water Cooler - I have move the thread so that it gets answered.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    02-28-2024
    Location
    Michigan, USA
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Web Site Data Parsing/Extraction

    Thank you for the tip. I will have to take a look at that.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Web Site Data Parsing/Extraction

    The Water Cooler is for off-topic chat. We have several sub-forums in the Excel section, each one being pretty much self-explanatory.

  6. #6
    Registered User
    Join Date
    05-12-2024
    Location
    Worcester MA
    MS-Off Ver
    MS 365
    Posts
    1

    Re: Web Site Data Parsing/Extraction

    I'm interested in the topic raised. Can you let me/us know where you moved this question to? thx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP Formula to Update Map and Code based on Site name and site ID
    By gcolegcole42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2022, 05:21 AM
  2. V Lookup formula to capture site code against a site name
    By gcolegcole42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2022, 12:50 PM
  3. Replies: 2
    Last Post: 01-28-2022, 08:41 AM
  4. Outlook Extraction Tool - Ignore Signature Images Extraction
    By RXcel in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2020, 10:34 AM
  5. OCR Data extraction with VBA from Web site
    By Galactico in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2017, 04:38 PM
  6. OCR Data extraction with VBA from Web site
    By Galactico in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2017, 12:42 AM
  7. i made site! Good Site. Look now mysite!!!
    By joks3xxx in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 03:47 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1