CSV to Text
Turn CSV data back into readable text, handling quoted fields and detecting the delimiter automatically so you can read a spreadsheet as lines.
How to use
- Paste your CSV into the box.
- Choose the delimiter or let it be detected.
- Copy the text.
CSV to text flattens spreadsheet data into lines you can read in a document. Quoted fields are parsed properly, including values that contain a delimiter or a line break.
Output
Paste or type something above.
Questions about csv to text
- How is the delimiter detected?
- The candidate that appears most often outside quoted fields wins, which is correct for ordinary CSV.
- What happens to a field with a line break in it?
- It is joined into the record rather than split, because the quote says it is one value.
- Should I drop the header?
- Turn the option on to skip the first row, which is usually the column names.
Related tools
- Text to CSV Turn lines of text into a proper CSV file with quoting and CRLF line endings, choosing you...
- Comma Separator Join a list of lines into one line separated by commas, semicolons, pipes, or spaces, with...
- Text Cleaner Strip hidden and invisible characters, normalise line endings and tabs, collapse blank lin...