CSV to Text Converter
Paste in CSV, TSV, or other delimited data and get back a clean, readable plain-text version — each row becomes a line, with columns separated by " | " instead of raw commas or tabs. The delimiter is auto-detected, so this works with data straight out of a spreadsheet export.
Output delimiter
Your pasted data's own delimiter is detected automatically — this only chooses how columns are separated in the result.
Why This Tool Matters
Pasting raw CSV data into a plain-text email, a chat message, or a document usually looks like a wall of commas — technically correct, but hard for anyone to actually read without opening it in a spreadsheet first. This tool skips that step entirely: paste the exported data straight in, convert it, and paste the readable result wherever it needs to go, without ever having to open Excel or Google Sheets. It's just as useful for quickly reformatting an export you already have open, when a clean list is more useful in the moment than a full spreadsheet view.
A common real-world case: exporting a customer list from a CRM to paste into a support ticket or an internal message, where one field — a company name like "Smith, Jones & Co." — has a comma baked right into it. A naive split-on-comma approach would slice that single field into two, throwing every column after it out of alignment for the rest of the row. Respecting the quotes around that field is what keeps "Smith, Jones & Co." intact as one value instead of quietly corrupting the row, which is exactly the kind of subtle data-loss bug that's easy to miss until someone downstream notices the columns don't line up.
How to Use
- 01
Paste your data
Paste CSV, TSV, or other delimited data copied from a spreadsheet or export.
- 02
Check the delimiter
The delimiter is auto-detected from your data — switch it manually if it guessed wrong.
- 03
Click "Convert to Text"
Each row becomes a line of plain, readable text with columns separated by " | ".
More Text Tools
Frequently Asked Questions
Does this work with tab-separated data too?
Yes. Select "Tab" from the delimiter options, or just paste your data in as-is — the tool checks the first line for the most common separator among comma, tab, semicolon, and pipe, and pre-selects it automatically.
What happens to commas inside quoted fields?
They're preserved correctly. A field wrapped in double quotes — like "Engineer, Lead" in a comma-delimited file — is treated as a single field even though it contains the delimiter character, exactly as the CSV format intends. A doubled quote ("") inside a quoted field is also unescaped back to a single literal quote.
Can I convert back from text to CSV?
Not with this tool — it's built specifically for the CSV-to-readable-text direction, since that's the direction that actually loses structure and needs converting for display. If you need to go the other way, most spreadsheet apps can re-import a consistently delimited plain-text file directly.
Is there a row limit?
No hard limit — the whole conversion runs in your browser, so it can handle anything from a few rows to a full spreadsheet export. Extremely large pastes (tens of thousands of rows) may just take a moment longer to process.
What happens to empty cells?
An empty cell converts to an empty field in the output rather than being skipped or collapsed, so a row like "Name,,Department" (a blank middle column) becomes "Name | | Department" — the gap stays visible in the same position instead of quietly shifting every later column one place to the left.
Does the output keep rows and columns in the same order as the original data?
Yes. Rows convert top to bottom in the order they appear in your pasted data, and each row's columns keep their original left-to-right order — nothing gets sorted, reordered, or rearranged, only reformatted.