How to Convert an HTML Table to Excel (Step by Step)

Want to convert HTML table to Excel file?

Try Withdata Data File Converter, a desktop HTML to Excel converter for Windows, MacOS, and Linux, Convert HTML table to Excel, Easy and Fast.

Download Withdata DataFileConverter Download DataFileConverter

Convert HTML table to Excel

Choose HTML file -> Set Excel file -> Convert HTML table to Excel

“Start a New Convert” for “HTML to Excel”.

convert HTML file to Excel file - task window

Select From “File” “HTML” To “File” “Excel”.

create Excel file by HTML file - select type

1. Open source HTML file.

Support large HTML file ( > 4GB ).

transform HTML file to Excel file - open a HTML file

Source HTML file’s content is like this:

HTML to Excel converter - source HTML file

2. Config target Excel file.

generate Excel file by HTML file - config Excel file

3. Set rows options.

convert HTML file to Excel file - summary

4. Convert HTML table to Excel.

convert HTML table to Excel file - convert file

After converting, you can view the output Excel file.

convert HTML table to Excel file - view Excel file


More about HTML to Excel converter

See Video: Convert html table to Excel file in a few clicks

See also:

HTML → EXCEL reference

Type mapping

Value kindin HTMLin EXCEL
Int<td>1234</td>1234 (a real numeric cell)
Bigint<td>9007199254740993</td>9007199254740993 (exact only while the cell stays text)
Decimal<td>1234.56</td>1234.56 (numeric cell, format controls the displayed decimals)
Float<td>1.234e+10</td>1.234E+10 (numeric cell)
Text<td>text</td>text cell; leading zeros survive only if the column is text
Long text<td>multi-line text</td> (entities for &amp; &lt;)text cell; wraps inside the cell rather than the row
Date<td>2026-09-18</td>a serial number plus a date cell format
Datetime<td>2026-09-18 14:30:00</td>a serial number plus a date-time cell format
Binarynot representable in a cellnot representable as data
Boolean<td>true</td>TRUE / FALSE (a real boolean cell)
JSON<td>{&quot;a&quot;:1}</td> (quotes escaped)a text cell; the quotes are part of the value

Dialect differences

Both HTML and EXCEL are file formats, so what differs below is how each one chooses to represent a value.

Propertyin HTMLin EXCEL
identifiersAttribute values in quotes; entities for reserved charactersNot applicable; a cell holds exactly one value
datesWhatever text was renderedStored as a serial number; only the cell format makes it lo...
binarydata: URIs inside src attributesOnly as text or an embedded object, not as a data column
separatorTags, not delimitersCells, not delimiters
encodingDeclared in a meta charset tag or the HTTP headerUTF-8 internally, declared in the package
typingNoneReal cell types: text, number, date, boolean, error
shapeFree form; tables are row/column structures inside markupMultiple sheets, each a flat grid
ceilingNo formal limit1,048,576 rows x 16,384 columns per sheet; 255 sheets per w...

Convert HTML to Excel the easy way

Use the HTML to Excel converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).


Posted

in

by