About the CSV to Multiline Converter
A spreadsheet export is dense: dozens of values sit on one row behind commas, and what you actually need is a vertical list you can paste into an IN (...) clause, a YAML block or a spreadsheet column. This splitter reads the delimited text with a quote aware parser, so "Cork, Ireland" survives as a single value instead of becoming two, then writes each value on its own line.
Three scopes cover most jobs. Every cell flattens the grid left to right, row by row. One column keeps a single field, which is how you pull 400 order ids out of an export. Whole rows keeps each record together and only changes the separator between the fields.
The toolbar adds the finishing touches other people usually do by hand: wrap each value in single or double quotes, append a trailing comma so the list drops straight into an array literal, discard blank cells, and collapse repeats down to a unique set. A tab or pipe file works too, since the delimiter is detected automatically or can be forced.
When the values are already one per line and you only want to tidy them, Remove Duplicate Lines or Sort Text Lines are the faster stop. To go the other way and inspect the grid, open CSV Viewer.
How to use
- Paste the CSV or upload a .csv file.
- Choose whether to take every cell, a single column or whole rows.
- Set the quote style and line ending your target syntax needs.
- Copy the list or download it as a text file.
Common questions
- How do I get only the third column as a list?
- Set Take to "One column" and Column number to 3. Tick "Skip first row" if that row holds the field names.
- Will a value containing a comma be split in two?
- No. Quoted fields are parsed by RFC 4180 rules, so a quoted value stays intact even when it contains the delimiter.
- Can I produce a ready made SQL IN list?
- Yes. Pick single quotes and a trailing comma, then paste the block between the brackets of your IN clause.
- What happens to blank cells?
- They are dropped by default so the list has no gaps. Untick "Drop empty values" if the positions matter to you.