+ Reply to Thread
Results 1 to 4 of 4

Importing Multiple HTML Tables into Excel/CSV

  1. #1
    Registered User
    Join Date
    02-04-2020
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Importing Multiple HTML Tables into Excel/CSV

    Hello all,

    I have a local folder filled with around 4500 html files, each one contains a single table and are formatted in the exact same way just with different data in the rows. I'm looking for a way to import these tables into one excel worksheet so that we can filter and search the data. I found a similar query which is what drew me to the website (I can't post the link but the thread is called "VBA to import multiple HTML files into a single tab") but this simply takes the text value of each html into a single column, not keeping to the table format/rows.

    I know with something like this I would most likely have multiple table headers getting imported as rows, but I don't mind going through and removing those as duplicates after this has been done.

    With this I'd be looking for the import to work it's way through each html file in the folder and carry on adding the rows where the last one left off.

    The data will not be being updated and this is purely for reference and searching purposes. The data does contain phone numbers and dates which would need to remain in place.

    Any help anyone could give would be greatly appreciated.

    Many Thanks.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,741

    Arrow

    Hi,

    as Excel can read an html file, just open it ! Start your own code just activating the Macro Recorder and operating manually

  3. #3
    Registered User
    Join Date
    02-04-2020
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2
    There are over 4000 separate html files, is there something I can do when opening one that will record it and allow it to process against all the files at once?

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Importing Multiple HTML Tables into Excel/CSV

    Hello HammerNotFound,

    If you can post one of your HTML files as an attachment, I can pull together a macro for you. Also, if you can post a picture of how the files will look on the worksheet after being imported that would be great.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Question About Importing HTML Tables
    By mwhite18 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2016, 03:56 PM
  2. HTML table importing in Excel VBA problem
    By lulupatel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2015, 02:40 PM
  3. Replies: 3
    Last Post: 01-26-2007, 10:30 PM
  4. Extracting/Exporting HTML Tables or PDF Tables into Excel
    By master.investor.2005@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2006, 05:00 AM
  5. Importing HTML data into excel
    By Mike in forum Excel General
    Replies: 0
    Last Post: 01-31-2006, 10:55 PM
  6. [SOLVED] Importing multiple html tables into XL?
    By RedFox in forum Excel General
    Replies: 2
    Last Post: 04-26-2005, 02:06 AM
  7. Importing multiple html tables into XL?
    By RedFox in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-26-2005, 02:06 AM

Tags for this Thread

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