HTML Table to Excel Converter
Convert HTML tables to Excel spreadsheets (.xls format) with preserved formatting. Extract web tables, email tables, and report data into downloadable Excel files.
Excel Export Options
Excel Features:
• Headers styled with bold + gray background
• Auto-detects numbers vs text for proper formatting
• Compatible with Excel, LibreOffice, Google Sheets
• Handles colspan, HTML entities, nested tags
Format: Excel 2003 XML (.xls)
Table preview will appear here
Convert your HTML table to see a preview
Recommended Settings
Pro Tips
- •Excel file uses SpreadsheetML format (.xls) - opens in Excel, Google Sheets, LibreOffice
- •Headers automatically get bold formatting and gray background for easy identification
- •Numbers are auto-detected and formatted as numeric cells for calculations
- •Right-click any webpage table → Inspect Element → Copy outerHTML to get the HTML code
Most Popular
Most users enable headers, auto-fit columns, and trim whitespace for clean Excel files
When to Use This Tool
Extract data tables from websites for analysis in Excel. Perfect for price comparisons, product catalogs, financial data, statistics, and research data published on web pages. Right-click the table, inspect the HTML, copy it, and convert to Excel format. Saves hours of manual copy-pasting while preserving table structure.
Convert HTML email tables from automated reports, newsletters, and notifications into Excel spreadsheets. Many business systems send data as HTML tables in emails (sales reports, analytics, shipping updates). Extract these tables to Excel for further analysis, charting, or consolidation with other data sources.
Export data from old web applications, admin panels, and database interfaces that only display results as HTML tables. Many legacy systems lack proper export features. Copy the HTML table output and convert to Excel for migration, backup, or integration with modern tools and databases.
Transform web-based reports, dashboards, and documentation tables into Excel format for offline access, archival, or presentation. Useful for creating Excel-based reports from web analytics tools, monitoring dashboards, and SaaS applications that don't offer native Excel export functionality.
How It Works
Parse HTML input using DOMParser to create a DOM tree structure
Locate <table> element and select first or last table based on settings
Extract headers from <thead> or <th> elements with bold styling if enabled
Process <tbody> rows, extracting cell content from <td> and <th> tags
Remove HTML tags, decode entities, preserve line breaks if requested
Handle colspan attributes by adding empty cells to maintain alignment
Generate Excel XML (SpreadsheetML) format with proper cell types
Auto-detect numeric values and format as Number type for calculations
Apply header styling (bold font, gray background) to first row
Create downloadable .xls file compatible with Excel and spreadsheet apps
100% Private
Files never leave your device. All processing happens locally in your browser.
Lightning Fast
Powered by SpreadsheetML (Excel 2003 XML) for optimal performance on modern browsers.
Secure
No data collection, no tracking, no sign-up required.
Frequently Asked Questions
What Excel format does this create?
The tool generates Excel 2003 XML format (.xls files) using SpreadsheetML. This format opens natively in Microsoft Excel (all versions), Google Sheets, LibreOffice Calc, and Apple Numbers. It's not the newer .xlsx format, but it's more universally compatible and doesn't require external libraries. The files include proper cell types, formatting, and styling.
How do I copy HTML from a webpage table?
Right-click anywhere on the table and select 'Inspect' or 'Inspect Element' to open browser DevTools. The HTML view will highlight the table element. Right-click on the <table> tag and choose 'Copy → Copy outerHTML'. Paste this HTML into the converter. Alternatively, view page source (Ctrl+U or Cmd+U) and manually copy the table HTML.
Will Excel formulas work in the exported file?
No, this tool exports static data only. HTML tables contain text and numbers, not Excel formulas. The exported cells will contain the visible values from the HTML table. If you need calculations, you'll need to add formulas manually in Excel after opening the file. However, numeric values are properly typed so you can immediately use them in Excel calculations.
What happens to cell formatting like colors and borders?
Basic formatting is preserved: headers get bold font and gray background. However, detailed HTML styling (colors, borders, fonts from CSS) is not converted to Excel formatting. Only the text content and basic structure are preserved. The focus is on data extraction rather than visual formatting reproduction.
Can I merge cells or handle rowspan/colspan?
Colspan is handled by adding empty cells to fill the span width. For example, a cell with colspan='3' becomes three cells: one with content and two empty cells. This maintains column alignment. Rowspan is not currently supported - cells with rowspan are treated as single cells. Merged cells in the Excel output would need to be created manually.
Why use this instead of Excel's built-in import?
Excel's web query and import features can be complex, may not work with all websites (especially those requiring login), and often include unwanted page elements. This tool gives you precise control: paste exactly the table you want, configure options, and get a clean Excel file instantly. It's also faster for one-time extractions and works in any browser without opening Excel first.