Text to Table Converter

What "delimited text" really is

Spreadsheets, database exports, and log files share a simple structure: rows separated by line breaks, and columns separated by a single repeated character — the delimiter. A comma gives you CSV, a tab gives you TSV, and pipes (|) or semicolons are common in European exports where the comma is already used as a decimal point. This converter reads that flat text and rebuilds the grid behind it, then re-emits the same grid as an HTML <table>, a Markdown table, or a JSON array of objects.

How auto-detection works

When you leave the delimiter on "Auto-detect," the tool looks only at the first line of your input and counts how many times each candidate appears — comma, tab, pipe, and semicolon. Whichever character occurs most often wins; if none appear, it falls back to splitting on spaces. This is fast and right most of the time, but it can be fooled. A header row like Name,Role,Notes over data rows full of semicolons will still pick the comma, because detection never looks past line one. If your first row is unusual, set the delimiter manually.

A worked example

Paste this three-line block with "First row as header" enabled:

• name,city,visits
• Ada,London,3
• Linus,Helsinki,7

The tool detects a comma, splits into three rows of three cells, and reports "Detected delimiter: comma — 3 rows, 3 columns." Choosing JSON Array produces objects keyed by the header row:

[{ "name": "Ada", "city": "London", "visits": "3" }, { "name": "Linus", "city": "Helsinki", "visits": "7" }]

Note that visits stays a quoted string, not a number — the converter preserves every cell as text and never guesses types, which keeps IDs with leading zeros and phone numbers intact. If you turn the header option off, keys become col0, col1, col2 instead, and the first data row is treated as data rather than column names.

Choosing the right output

What "Escape HTML" and "Trim whitespace" do

Escape HTML matters only for the HTML Table output. With it on, characters that would otherwise break a page — <, >, &, and " — are rewritten as safe HTML entities. So a cell containing <b>bold</b> renders as literal text rather than turning the rest of your table bold. Leave it on unless you specifically want cells to contain live markup and you trust the source. Trim whitespace strips leading and trailing spaces from every cell, which cleans up exports that pad values for alignment; turn it off if those spaces are meaningful.

The live HTML preview

When you pick HTML Table as the output, the tool does two things at once. It puts the raw markup in the output box for you to copy, and it also renders that exact markup in a live preview panel below — so you see the finished, bordered table before you paste it anywhere. The generated table uses inline styles (a light gray header row, collapsed borders, padded cells) rather than CSS classes, which means the table looks the same wherever you drop it, even in environments that strip stylesheets such as email clients or content management systems. If you only want the structure and intend to style it yourself, delete the inline style attributes after copying.

Practical tips and limits

• This is a simple splitter, not a full CSV parser. It divides each line on the delimiter character directly, so a quoted field that itself contains a comma — like "Smith, John" — will be split into two cells. If your data has quoted commas, switch to a tab or pipe delimiter before converting.
• Blank lines are ignored. Empty rows are dropped automatically, so a stray newline at the end of a paste will not create a phantom row.
• Column count follows the first row in Markdown. If later rows have more cells than the header, the extra cells still appear but may not align; keep rows consistent for clean Markdown.
• Re-converting is cheap. Change the output format or any checkbox and the result updates immediately — experiment freely.

Is my data private?

Yes. Parsing and conversion happen entirely in your browser with no upload step. Whatever you paste — including sensitive exports — never leaves your device, so the tool works the same with your network disconnected.