List to CSV Converter
Turn any pasted list into a clean, downloadable CSV file.
List to CSV Converter turns a plain list — one item per line, comma-separated, or mixed — into a proper single-column CSV file, with cleaning (trim, remove duplicates, sort) and file splitting built in. Your data never leaves your browser: the conversion runs entirely on your device, with no upload and no server involved.
Converting CBP entry numbers for an IEEPA tariff refund? Use our CBP-ready tool →
Related tools: Remove Duplicate Lines · List Reconciler · JSON to CSV
How to use
- Paste your list into the box (or drop a .txt file onto it) and tick the delimiters that separate your items — new lines by default, plus commas, semicolons, tabs or spaces.
- Set your cleaning and output options: trim, dedupe, sort, a custom header, line endings, and splitting long lists into files of at most N items. The preview and counts update as you type.
- Download the CSV — or a ZIP when the list is split — or copy it straight into Excel, Google Sheets or any tool that imports CSV.
About this tool
It is built for the unglamorous lists behind real work: SKUs copied out of a PDF, email addresses from a sign-up sheet, product codes, names for a mail merge. Pick the delimiters that match your source, strip stray characters, fix the case, and export a file your spreadsheet or importer will accept the first time.
Two details save the usual headaches. Values containing commas, quotes or line breaks are quoted and escaped automatically, following standard CSV rules. And if your values start with 0 — account numbers, ZIP codes, product codes — the leading-zero option prefixes an apostrophe so Excel keeps the zero instead of silently eating it.
How it works
A single-column CSV is the simplest useful spreadsheet file: an optional header row naming the column, then one value per line. This converter builds exactly that from any list, whatever separates the items now — line breaks, commas, semicolons, tabs or spaces.
Values are escaped by the standard CSV rules (RFC 4180): a value containing a comma, a double quote, or a line break is wrapped in double quotes, and any double quote inside it is doubled. That is what stops a value like Smith, John from splitting into two phantom columns when the file is opened.
Order of operations matters when cleaning. Characters are stripped first, then trimming and case changes are applied, then empties are counted and dropped, then duplicates are removed — so 'Apple' and ' apple ' correctly collapse into one item when trim and lowercase are on. Sorting happens last, on the final list.
Worked examples
Cleaning a supplier SKU list: A PDF gives you 4,200 SKUs, one per line, with stray spaces and a few repeats. Paste, keep trim + dedupe on, and download a single-column CSV your inventory system imports without a single manual edit.
Splitting a mailing list for an importer: Your email tool accepts at most 10,000 contacts per file. Set the split to 10,000 and a header of 'email' — a 46,000-address list becomes five ready-to-upload files in one ZIP.
Keeping account numbers intact: A list of branch codes like 0042 and 0107 loses its zeros the moment Excel opens it. With the leading-zero option on, each value is prefixed with an apostrophe, Excel treats it as text, and 0042 stays 0042.
Quick reference
| Option | What it does |
|---|---|
| Delimiters | Which characters separate items — combinable, e.g. lines + commas for messy pasted data |
| Remove duplicates | Keeps the first occurrence of each item, drops later repeats (counted in the stats) |
| Split files | Caps items per file; every file repeats your header row |
| CRLF line endings | The Windows/Excel convention; LF is the Unix convention — most importers accept either |
| Leading-zero prefix | Adds an apostrophe so spreadsheets treat values as text and keep leading zeros |
Frequently asked questions
Is my data safe?
Yes. The converter runs 100% in your browser using JavaScript — your list is never uploaded, sent over the network, or stored anywhere. You can even disconnect from the internet after the page loads and it will keep working.
How do I open the CSV in Excel?
Double-click the downloaded file, or in Excel use File → Open. If your version asks, choose comma as the delimiter and UTF-8 as the encoding. The file uses CRLF line endings by default, which is the format Excel expects.
How do I keep leading zeros, like 007 or 02134?
Set "Leading zeros" to "Prefix with '". Excel then treats the value as text and displays the zero instead of dropping it. Without this, Excel converts 02134 to the number 2134 the moment the file opens.
How many rows can it handle?
It stays smooth up to about 100,000 items on a typical computer, since everything is processed locally in memory. Beyond that, split your source list into chunks and convert each one.
How do I split a big list into several files?
Tick "Split into files of at most" and set the maximum items per file — 1,000, say. You get list-1.csv, list-2.csv and so on, each with your header row, downloadable one by one or all together as a single ZIP.
More free tools
Word Counter
Count words, characters, sentences and reading time as you type.
Text Case Converter
Change text to UPPERCASE, lowercase, Title Case and more.
Lorem Ipsum Generator
Generate placeholder text for designs and mockups.
Remove Duplicate Lines
Delete repeated lines, keep the first occurrence.
Sort Lines Alphabetically
Sort any list A–Z or Z–A in one click.
URL Slug Generator
Turn titles into clean URL slugs.