How to use the text to table converter
- Paste your delimited text into the input area, or paste an existing table if you want to convert table to text.
- Select the direction: Text to table or Table to text.
- Choose the input delimiter (comma, tab, pipe, semicolon or auto-detect).
- Pick the output format: ASCII box, Markdown or HTML.
- Copy the result from the output area.
How the conversion works
To convert text to table, the tool splits your input into rows at each line break, then splits each row by the chosen delimiter. Quoted fields work like CSV: a cell in double quotes can contain the delimiter, line breaks or doubled quotes. Cells are trimmed, empty lines are skipped, and short rows are padded so every row has the same number of columns. The tool measures the widest cell in every column, counting wide characters such as Chinese or Japanese as two columns, so the output aligns properly.
For example, given the CSV data Name,Age and Alice,30, the parser produces two rows of two cells. The first column width is 5 (for "Alice") and the second is 3 (for "Age"). An ASCII output pads each cell with spaces to match those widths, yielding a neatly aligned grid.
When you convert table to text, the process reverses. The parser detects whether the input is an ASCII box (plain or drawn with box characters), a Markdown table or an HTML table, extracts the cell contents, and joins the values with your chosen delimiter, adding quotes around any cell that contains the delimiter, a quote or a line break.
Supported formats
The converter handles three output styles, each suited to different workflows:
| Format | Best for | Example header row |
|---|---|---|
| ASCII box | Terminal output, plain-text docs, comments | +------+-----+ |
| Markdown | README files, wikis, static sites | | Name | Age | |
| HTML | Web pages, emails, rich-text editors | <tr><th>Name</th></tr> |
You can generate a Markdown table from CSV data, paste it back in, switch the direction to extract the raw text, and get the original values. Markdown cells escape pipes and show line breaks as <br>. In the ASCII format a line break inside a cell becomes a space and a literal pipe cannot be told apart from a column border, so use Markdown or HTML for cells that contain them.
Delimiter auto-detection
When you leave the delimiter set to auto-detect, the tool examines the first non-empty line of your input. It counts tabs, commas, pipes and semicolons outside of quoted text. The character with the highest count becomes the active delimiter, and a tie goes to tab, then comma, pipe and semicolon.
This heuristic works well for typical datasets. If the first line has no delimiter at all, or your header row contains a different number of commas than the data, choose the delimiter explicitly.
Practical use cases
Developers frequently need to turn database query results or log output into readable documentation. Pasting tab-separated values from a spreadsheet and choosing Markdown output gives you a ready-made table for a README file.
Technical writers often receive data as plain text and need to present it as an HTML table for a CMS. This tool handles that without requiring a spreadsheet application.
If you maintain configuration files or notes in plain text, you might occasionally need to convert table to text so the data can be processed by command-line tools like awk or cut. Paste the formatted table, select the extraction direction, pick a tab or comma delimiter, and copy the result.
For other text transformations, you might also find the case converter or whitespace remover useful alongside this converter.
Round-trip accuracy
A round trip means converting delimited text into a formatted table and then back into delimited text. Cell content is kept, with these exceptions: cells are trimmed of leading and trailing spaces, empty lines are dropped, and in the ASCII format line breaks inside cells become spaces.
If your original text uses a mix of delimiters on different lines, the parser applies the same delimiter to every row, so normalise your input first. Because everything runs locally in your browser, you can test round trips freely without uploading sensitive data to a server.
Worked examples
| Example | Input | Result |
|---|---|---|
| CSV to ASCII table | Input text: Name,Age,City / Alice,30,London / Bob,25,Paris; Direction: text-to-table; Input delimiter: comma; Output format: ascii | Rows: 3; Columns: 3 |
| TSV to Markdown | Input text: Product Price / Widget 9.99 / Gadget 24.50; Direction: text-to-table; Input delimiter: tab; Output format: markdown | Rows: 3; Columns: 2 |
| Convert table to text | Input text: | Name | Age | / |---|---| / | Alice | 30 |; Direction: table-to-text; Input delimiter: tab; Output format: ascii | Rows: 2; Columns: 2 |
FAQ
How do I convert text to table format?
Paste your delimited text into the input area, choose the correct delimiter (or let auto-detect find it), select your preferred output format such as ASCII, Markdown or HTML, and the result appears immediately.
Can I convert table to text as well?
Yes. Switch the direction to "Table to text", paste an ASCII, Markdown or HTML table, pick the delimiter you want for the output, and the tool extracts the raw cell values.
Does this work with tab-separated values?
It does. Select Tab (TSV) as the delimiter, or use auto-detect which will identify tabs automatically if they are the most frequent separator on the first line.
Is my data uploaded anywhere?
No. The entire conversion happens in your browser. Nothing is sent to any server, making it safe for confidential or proprietary data.
What happens if rows have different numbers of columns?
The tool finds the maximum column count across all rows. Shorter rows are padded with empty cells so the resulting table stays rectangular and aligned.
Can I use this to format data for a README file?
Yes. Choose Markdown as the output format. The generated table follows standard Markdown syntax with a header separator row, ready to paste directly into any Markdown document.