CSV to Multi Line Data Converter
CV-58Paste a CSV and get one block of lines per row, written as label, a separator and the value. It reads much better than a wide row when a record has many columns.
Runs in your browser. Nothing is uploaded.
CSV
Multi-line text
How to use it
- Paste your CSV into the input box, or open a .csv file and drop it on the box.
- Leave the delimiter on Auto, or pick comma, semicolon, tab or pipe.
- Choose the separator between label and value and how records are divided.
- Copy the text or download it as a .txt file.
What the output looks like
The first row supplies the labels. Each later row becomes a block with one line per column, such as name: Ada, then city: London. Blocks are separated by a blank line, a line of dashes or a Record 1, Record 2 heading. If a value has line breaks inside it, the extra lines continue below and are indented by two spaces, so a block still reads as one record. This is handy for pasting rows into a ticket, an email or a code comment.
Empty values, short rows and no header
By default every column appears in every record, even when the value is empty. Turn on Skip empty values to leave those lines out, and expect blocks of different lengths. Short rows are padded with empty values. If your CSV has no header row, switch the header option off and the labels become column_1, column_2 and so on. Repeated header names get _2 and _3 so no label is lost.
What it does not change
Values are written exactly as read: nothing is trimmed, re-quoted or turned into numbers or dates. Quoted CSV fields, commas inside quotes and doubled quotes are all read correctly before the text is written. The output is plain text for people. If you need to load it into a program, use a structured format such as JSON or YAML instead, because this layout cannot be turned back into CSV without a script.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
No rows found in the CSV. | The input is empty or holds only blank lines. | Paste at least a header row and one data row. |
The CSV has a header row but no data rows, so there are no records to write. | Only one row was found and it was treated as the header. | Add data rows, or turn off First row is header to treat it as data. |
A quoted field is never closed (missing closing ") | A field starts with a double quote that has no matching end quote. | Add the closing quote, or double any quote that is part of the text. |
Questions people ask
How do I convert CSV to multi line text?
Paste the CSV and the multi-line text appears at once. Each row turns into a block of label: value lines using the header as labels. Choose the separator and the record break, then copy the result or download it.
Can I use something other than a colon between label and value?
Yes. Choose colon, equals, tab or dash. The choice applies to every line, so label = value or label - value are easy to get without a find and replace.
What happens to cells that contain line breaks?
The first line stays after the label and later lines are indented by two spaces on their own lines. That way the block still reads as one record and you can see where the value ends.
Can I drop empty columns from each record?
Turn on Skip empty values. Any column with an empty value is left out of that record only, so different records can have different numbers of lines.
Does it work with semicolon or tab separated files?
Yes. The delimiter is detected from the first line, or you can set it yourself to comma, semicolon, tab or pipe. Quoted fields with delimiters inside them are read correctly.
About this tool
The first row supplies the labels and every later row becomes one block with a line per column, written as label, your separator, then the value. A value that spans several lines continues on the next lines, indented by two spaces. Records are split by a blank line, a line of dashes, or a "Record n" heading, as you choose; the heading option puts the heading before the first record too. Skip empty values leaves out columns with no value, so records can end up with different numbers of lines. Without a header row the labels are column_1, column_2 and so on; blank header names get the same treatment and repeated names get _2, _3. Short rows are padded with empty values. Values are written exactly as read: no trimming, quoting or type changes. The result is meant for reading, and it cannot be loaded back as CSV without a script.