List to CSV Converter

A list and a CSV are almost the same thing — until an item contains a comma, a quote, or a line break, and almost becomes a broken import. Hand-joining list items with commas works right up to the first value like bananas, ripe, which silently splits into two columns. This free converter does the join correctly: it turns a one-item-per-line list into either a single CSV row or a single CSV column, using your choice of delimiter, and applies standard CSV quoting so values containing delimiters, quotes, or line breaks survive intact. The output opens cleanly in Excel, Google Sheets, and any CSV parser. Everything runs in your browser.

The layout option decides the shape of the result. One row places every list item side by side in a single line, separated by the delimiter — the form used for header rows, tag fields, function arguments, and anywhere a horizontal series is expected. One column keeps each item on its own line as a one-field record, producing a file that imports into a spreadsheet as a vertical column — the natural shape for ID lists, email columns, and seed data. The same list converts both ways; pick the shape the destination expects.

The comma is CSV's namesake and the safe default for most tools. The semicolon is the de facto standard in locales where the comma is a decimal separator — much of Europe — and what regional Excel versions expect. Tab-separated output pastes directly into spreadsheet cells and suits data whose values frequently contain commas. The pipe is a common choice in data pipelines precisely because it rarely appears in natural text. Whichever you choose, the quoting logic adapts: values containing the active delimiter are the ones that get wrapped.

Standard CSV quoting wraps a value in double quotes when it contains the delimiter, a quote, or a line break, and doubles any quote characters inside it — so"dates" becomes"""dates""". The When needed mode applies exactly this rule, producing minimal, clean output. Always wraps every value, which some strict importers and legacy systems prefer. Never disables quoting entirely for cases where you control the data and want raw joining — accepting that delimiter characters inside values will split them. When in doubt, leave it on When needed.

Column output saved through the download button is a ready-to-import CSV file: Excel and Google Sheets open it with one item per row, contact tools and mailing systems ingest it as an address column, and databases load it with their CSV import commands. Row output drops into header definitions, configuration lists, and quick data-entry tasks. The pairing with this site's CSV to Table converter lets you preview the structure of generated CSV before committing it to an import.

The converter treats every non-empty line as one value; blank lines are dropped so stray spacing does not create empty fields. Items are used exactly as written — leading bullets or numbering would become part of the data. If your list carries markers, run it through the List to Text converter with marker stripping first, or remove numbering with the Remove Line Numbers tool, then convert the clean lines here. Output statistics report how many values the result contains, an instant check against your expected count.

The conversion runs locally in your browser with JavaScript; lists of customers, emails, or internal IDs are never uploaded, stored, or logged. The download button writes the CSV file directly on your device, and the content is cleared from memory when you close the page.