How to use the list to csv converter
- Paste your list into the text area, ensuring each item is on its own line.
- Select your preferred delimiter: comma, semicolon, or tab.
- Set the number of columns per row. Use 1 for a single-column CSV, or a higher number to wrap items across multiple fields.
- Optionally type a header row using your chosen delimiter to separate column names.
- Copy the generated CSV from the output box.
How list to CSV conversion works
A list to CSV conversion takes individual lines of text and formats them according to RFC 4180, the standard for comma-separated values. Each item becomes a field. If you specify more than one column, consecutive items are grouped into rows of that length.
The critical step is escaping. If an item contains the delimiter character, a double quote, or a newline, it must be enclosed in double quotes. Any double quote inside the item is escaped by doubling it. For example, the input He said "hi, there" becomes "He said ""hi, there""" in the CSV output.
Quoting rules reference
Understanding when fields are quoted prevents broken imports in spreadsheet software. Here is how different inputs are handled when the delimiter is a comma:
| Original list item | CSV field output | Reason |
|---|---|---|
Apple | Apple | No special characters |
Banana, ripe | "Banana, ripe" | Contains delimiter |
Say "Hello" | "Say ""Hello""" | Contains double quotes |
These rules apply regardless of whether you use commas, semicolons, or tabs as your delimiter.
Arranging items into multiple columns
By default, setting columns to 1 places every list item on its own row in a single column. If you have a flat list of 12 items and set columns to 3, the converter groups them into 4 rows of 3 fields each. This is useful when your source data alternates between related values, such as name, email, and phone number repeating for each contact.
If the total number of items does not divide evenly by the column count, the final row will contain fewer fields. Most CSV parsers handle this gracefully, leaving the remaining columns empty for that row.
Common mistakes to avoid
When converting a list to CSV, trailing blank lines in your source text can produce empty rows. This converter automatically strips completely empty lines before processing to prevent that issue.
Another frequent error is mismatching the header delimiter with the output delimiter. If you choose a semicolon as your delimiter but type your header with commas, the header will be treated as a single field. Always use the same character in the header input as your selected delimiter.
If you need to go the other direction, use a csv to list tool to extract items back into plain lines.
Working with other data formats
CSV is often a stepping stone between formats. If your source data is structured as JSON rather than a simple list, a dedicated json to csv converter handles nested objects correctly. Similarly, if you are working with newline-delimited JSON, a jsonl to csv tool is more appropriate.
Once you have your CSV, you might want to inspect it visually. A csv viewer renders the data as a table so you can verify alignment before importing it into a database or spreadsheet. For documentation purposes, converting the result with a csv to markdown tool produces tables suitable for README files.
Worked examples
| Example | Input | Result |
|---|---|---|
| Simple single column | List items (one per line): Apple / Banana / Cherry; Delimiter: ,; Columns per row: 1 | Apple / Banana / Cherry |
| Three columns with header | List items (one per line): Alice / 30 / NYC / Bob / 25 / LA; Delimiter: ,; Columns per row: 3; Header row (separated by the delimiter): Name,Age,City | Name,Age,City / Alice,30,NYC / Bob,25,LA |
| Items containing commas and quotes | List items (one per line): Smith, John / He said "hello" / Plain text; Delimiter: ,; Columns per row: 1 | "Smith, John" / "He said ""hello""" / Plain text |
| Semicolon delimited | List items (one per line): A / B / C / D; Delimiter: ;; Columns per row: 2; Header row (separated by the delimiter): Col1;Col2 | Col1;Col2 / A;B / C;D |
FAQ
Does this tool upload my data to a server?
No. The list to CSV conversion happens entirely in your browser using JavaScript. Your data never leaves your device.
What happens if my list items contain commas?
Any item containing the chosen delimiter, double quotes, or newlines is automatically wrapped in double quotes, and internal quotes are escaped by doubling them, following RFC 4180.
Can I use a tab or semicolon instead of a comma?
Yes. Select Semicolon or Tab from the delimiter dropdown. The quoting logic adjusts automatically based on whichever character you choose.
How do I add a header row to the CSV?
Type your column names in the Header row field, separated by the same delimiter you selected. It will be prepended as the first line of the output.
What if my list has fewer items than the column count?
The output will contain a single row with only the available items. No padding or empty fields are added beyond what naturally results from the grouping.
Are empty lines in my input preserved?
No. Completely empty lines are stripped before conversion to prevent generating unintended blank rows in the CSV output.