HTML Table to CSV/Excel

100% Free · Client-Side

Convert HTML tables to CSV/Excel format. Parse tables with rowspan/colspan options and export for use in Excel or Google Sheets.

HTML Table Code

Click to upload an .html file
Conversion Options

Prepend UTF-8 BOM byte to CSV data for Excel.

Table Live Preview

Paste HTML containing a <table> tag to generate preview.

What is the HTML Table to CSV/Excel Converter?

The HTML Table to CSV/Excel converter parses tabular HTML components (`<table>`, `<tr>`, `<td>`, etc.) and extracts their text or code content into standardized Comma-Separated Values (CSV). It utilizes smart coordinate allocation to handle nested grid patterns, specifically supporting tables utilizing rowspan and colspan attributes to avoid cell displacement.

Key Features & Capabilities

  • Advanced Rowspan & Colspan Alignment: Automatically adjusts cell indexes so columns match their visual boundaries inside spanned fields.
  • Custom Value Extraction: Toggle between extracting plain text (default), keeping raw inner HTML, or extracting only hyperlink hrefs from anchor tags.
  • Multiple Delimiters: Swap between comma (`,`), semicolon (`;`), and tab (`\t`) formatting dynamically.
  • Excel BOM Header Injection: Prepend the UTF-8 Byte Order Mark automatically to fix column splits and character reading issues in Microsoft Excel.
  • Batch Tables Detection: Extracts and processes all HTML tables found inside a document with one-click toggles.

Frequently Asked Questions

1. How does the converter handle rowspan and colspan?

The tool uses a standard grid layout mapping algorithm. Spanned columns (colspan) and spanned rows (rowspan) are calculated correctly, and cells are padded so that alignment is perfectly preserved in the CSV file.

2. What happens if there are multiple tables in the pasted HTML?

The tool automatically parses all tables found in the document and lists them. You can click on the buttons below the input card to switch previews and download each table separately.

3. How does Excel Compatibility work?

Microsoft Excel often fails to recognize UTF-8 CSV characters automatically. The 'Excel Compatibility' toggle inserts a Byte Order Mark (BOM) at the beginning of the file, forcing Excel to read special characters and structure columns correctly.

Technical Data & Marketing Integration