List to CSV Converter

What this tool does

This converter turns a plain list into proper CSV. Paste a list with one item per line, choose how those lines should become rows, and the tool builds a clean CSV file you can copy or download. It handles the fiddly parts of the format for you — separating cells correctly, quoting any value that needs it, and adding an optional header row — so you do not have to think about CSV rules at all. It loads with a sample list so you can see the result straight away.

CSV, short for comma-separated values, is the format spreadsheets and most business software use to import data. A bare list — names typed one per line, a column copied out of a document, items pasted from a chat — is not yet CSV. This tool is the bridge between that loose list and a structured file a spreadsheet will accept.

Why and when you would use it

The everyday case is preparing data for import. A tool you want to upload to — an email platform, a CRM, an ad manager — asks for a CSV file, but all you have is a list of names or addresses. Paste the list here, add a header row, and download a file the platform will accept.

It is also useful for reshaping data you already have. If you copied a column out of a report and each value landed on its own line, “One per row” turns it straight into a one-column CSV. If a colleague sent you records as a flat list — a name, then an email, then a phone number, repeating — “Group N per row” folds every three lines back into a single row with three columns. And when each line already holds several values run together, “Split into columns” breaks them apart on whatever character separates them.

Marketers use it to build contact upload files, operations teams use it to turn rough notes into importable tables, and anyone preparing data for a pivot table can use it to get a loose list into spreadsheet-ready shape.

How to use it

1. Paste your list into the box, one item per line. The sample loads automatically so the tool is never empty.
2. Choose a Conversion mode: one item per row, split each line into columns, or group a set number of lines per row.
3. If you picked split mode, choose the delimiter that separates the values on each line — comma, tab, semicolon, space or a custom character. If you picked group mode, set how many lines make up each row.
4. Optionally type a Header row as comma-separated names to label the columns.
5. Adjust the options: trim each item, skip blank lines, and quote every field if your destination requires it.
6. Use Copy CSV or Download .csv to save the result as a file called list.csv.

Common pitfalls and tips

The most common surprise is a spreadsheet altering your data after import. Excel strips leading zeros from ZIP codes and product SKUs — 00742 becomes 742 — and rewrites long numbers in scientific notation. The CSV itself is correct; the change happens when the spreadsheet opens it. If those values matter, format the destination column as text before importing.

When splitting into columns, make sure every line uses the same delimiter — a single line with an extra comma will gain an extra column and knock the rest out of alignment. Watch for trailing spaces around values; leaving “Trim each item” on removes them. Smart or curly quotes pasted from a word processor are not standard CSV quotes and can confuse some importers, so prefer straight quotes. For the reverse journey — viewing or editing an existing CSV as a table — use the CSV Viewer & Editor, and for turning CSV into web-page markup see the CSV to Table converter. Developers who need structured output can use the CSV to JSON converter and the JSON to CSV converter.

Privacy

This converter works entirely inside your browser. The list you paste is turned into CSV by JavaScript running on your own device — nothing is uploaded, nothing is stored between visits and nothing is logged or tracked. Close the tab and the data is gone. Because the whole conversion is local, you can safely build CSV files from private lists such as customer names, email addresses or internal records without any of it leaving your computer.