HTML Table to CSV

Paste HTML table code and get a clean table: header cells become column names, entities are decoded, colspan cells stay aligned. Free, nothing uploaded.

Quick answer: Paste text from anywhere and get a clean table. The layout is detected for you.

How to use the HTML Table to CSV

Paste text from anywhere and get a clean table. The layout is detected for you.

Text to Table turns text you copied into a real table, with no settings to choose. Paste a table copied from Excel, Google Sheets, a web page, a PDF, an email or a chat, a Markdown table, a MySQL or psql result, a box-drawn terminal table, HTML table code, key: value lists or blocks, key=value log lines, or JSON and JSON Lines. The layout is detected, a title line above the table is skipped, and the first line is used as the header only when it really holds column names. Columns of numbers become numbers, including $1,234.50, 12.5%, (45.20) and decimal commas like 1,50, with the currency symbol or % moved into the column name. Codes with leading zeros, versions and long IDs stay as written. If the text mixes several layouts, the tool says so instead of guessing. Everything runs in your browser.

Paste your text
Check the detected table
Download CSV, Excel, JSON or Parquet

Tips

Nothing to set up: tabs, commas, semicolons, pipes, aligned columns, key: value lines, logs, HTML and JSON are all detected.
Columns look wrong? Use Adjust settings to choose the layout or the header yourself, then Back to automatic.
Columns lined up with spaces are read by position, so empty cells stay in their column.
If the text mixes several layouts, paste one part at a time.
Turn off Detect numbers under Adjust settings to keep every value as text.

Example

Input: <tr><td>Ada & Co</td><td>36</td></tr>

Output: Name,Age Ada & Co,36

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I convert an HTML table to CSV or Excel?

Copy the HTML from <table> to </table> (for example from View source or the browser developer tools), paste it, check the table and download CSV or Excel.

What happens to colspan and line breaks?

A cell that spans two columns is followed by an empty cell, so the next values stay in the right columns. <br> becomes a line break inside the cell, and other tags are removed.

Can I paste a copied web page table instead of the code?

Yes. A table copied from a web page usually pastes as tab separated text, which is read automatically too.

What text can Text to Table read?

Tab, comma, semicolon, pipe and space separated text, Markdown tables, and report-style text. Blocks of Key: value lines separated by blank lines become one row each, and sentences such as "Order #1001 was placed on 2026-10-20 by customer Rahul. Product: Laptop. Status: Delivered." become rows with columns for the repeated parts. The layout is found automatically, and you can pick it yourself if the columns look wrong. If the text mixes several layouts, the tool tells you instead of making a table that could be wrong.

Why does Text to Table say the text mixes layouts?

It only builds a table when the lines or blocks look alike. A paste that contains a log line, a JSON line, a sentence and a Key: value block together has no single set of columns, and any table made from it would be a guess. Paste one layout at a time, or choose the layout yourself in the list.

Text to Table: Paste Text, Get a Table: Paste text from a web page, PDF, email or chat and get a clean table. Columns are detected for you. Download CSV, Excel, JSON or Parquet. Free.
Paste Text into a Table for Excel: Turn text you copied from a web page, PDF or email into a table, then download it as Excel or CSV. Free, in your browser, nothing is uploaded.
Convert Text to CSV: Convert a TXT file or pasted text to CSV: tab, space or comma separated lists and key: value lines. Free, in your browser, and nothing is uploaded.
Markdown Table to CSV: Convert a Markdown table to CSV or Excel. Paste the table with its pipes and dashes and get a clean table. Free, in your browser, nothing uploaded.
Copy a PDF Table into Excel: Copied a table from a PDF? Paste the text and get a clean table you can download as Excel or CSV. Free, in your browser, and nothing is uploaded.
JSON Lines (JSONL) to CSV: Convert JSON Lines (one JSON object per line, also called NDJSON) to a CSV or Excel table. Nested fields become columns like user.name. Free, in your browser.
Log Lines to CSV: Turn key=value log lines (logfmt) into a table: each key becomes a column, quoted values stay whole, times and levels get columns. Free, nothing uploaded.
SQL Query Result to CSV: Paste a MySQL or psql query result, or a box-drawn DuckDB table, and get a clean CSV or Excel table. Borders and row-count footers are removed.

Topic guides

CSV Guides and Free CSV Tools

Guides

How to Copy a Table from a PDF or Web Page into Excel