• Excel to HTML Table

    Do you want to copy the Excel Table to a webpage?

    Most of the time, It is easy to represent data in table format. Excel spreadsheet is the one that can create table format data in seconds. But, to make it as HTML page, we need too many tags to be added for each cell. It is not tough, not anymore.

    Here is the easy solution.

    1. Download the Excel at end of this page.
    2. Copy the content to this Excel.
    3. Click the Convert ‘Excel to HTML Table’ button.
    4. Get the HTML code written to file.
    5. Use it in your webpage.

    If you are already a VBA gig, then just use the free code available in this page, that just does the same.

    Also Read: Check If Outlook is Running - then Launch Outlook app - vba code

    VBA Macro Code – Convert Excel Table to HTML

    This VBA code just loops thru all the rows & columns in the Excel table in the first sheet.

    First Row Header: Instead of checking for font style, code in the Excel file attached below, converts the first row as header.

    Table Width: Each column width in Excel is set to width of each column in HTML Table.


    If the data also has any data to be bold then consider changing the code accordingly.

    Download Excel to HTML Table Converter

    This converter app has all the functionalities explained above as same. Except for this one.

    Bold Data: If the row is Bold, then it is considered as Table header. If it is not bold, then it is considered as table cell data.

    Download Excel to HTML Table Converter App downloaded 32 Time

    Just download this Excel app, Enable security options for macro & content when asked for, then copy paste your data to the first sheet & Click on convert button.

    This app only converts spreadsheet into a plain HTML table. The formatting within the table are ignored.


    Previous Post:
    Next Post: