Convert HTML File to Excel File

Posted on 2009-02-11
Last Modified: 2012-05-06

I have one HTML file whose size is more than 300 MB and the data which is there in HTML file is in table format.
If I open HTML file in internet explorer browser or in mozile browser then it crash the browser, I also tried some convertors but again it failed.
Can someone provide me any vbscript through I can convert more than 300 MB HTML file to Excel file.
Thanks and Regards,
Question by:nicepenfriend
    LVL 3

    Accepted Solution

    Could we got a sample of the HTML file ?
    The idea would be to parse the HTML file and recreate into excel cells.  (you will need to have excel installed on the machine which runs the script).
    IF you want to convert HTML to excel, you can simply select the information in HTML and drag and drop it into excel.  I assume 300 MB is quiet use for such and you probably already tried it.

    Author Comment

    Thanks for your reply, I have tried opening HTML file in browser and tried to copy but my browser crash everytime so it's very diff to copy contents from HTML file to excel file.

    I have attached sample HTML file  for your reference please check and help me in vbscript.

    Please extract file from attached zip file in some temp folder and rename that file with a extension .html.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
    This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now