Data & CSV
Text list to CSV
Turn one item per line into a safely quoted single-column CSV.
A clear answer. Here’s how.
Exports one CSV column with the supplied non-empty heading. Quotes separators, newlines and double quotes as required. Potential spreadsheet formula prefixes are protected. Supports up to 50,000 input lines.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- One value per line
Apple Pear, conference Plum
- Column heading
- Item
- Blank lines
- Skip blank lines
Example result
| Item |
|---|
| Apple |
| Pear, conference |
| Plum |