CSV Formatter
Make a messy CSV consistent: choose the separator and quoting, trim stray spaces, pad short rows and pick LF or CRLF line endings. All in your browser, so your data stays private.
- Nothing to install
- Stays in your tab
- Fix quotes and separators
- LF or CRLF endings
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
CSV formatter in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV
Accepted files include .csv, .tsv, .tab and .txt.
- STEP 02
Set the format
Choose the separator to write, quoting style, line endings, and whether to trim spaces and equalize column counts.
- STEP 03
Copy or download
The result keeps your data and normalizes the layout. The note reports rows and columns.
What CSV formatter does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Separator conversionRead comma, semicolon, tab or pipe files (detected automatically) and write any of them.
- Quoting controlQuote only where needed, or put quotes around every field.
- Trim stray spacesRemove spaces around values left by manual editing or exports.
- Consistent column countShort rows are padded with empty cells so every row has the same number of fields.
- Line endingsChoose LF for Mac and Linux, or CRLF for Windows and RFC 4180.
Good to know
- Values are not interpretedEverything stays text. Dates, numbers and encodings are not changed.
- Blank lines are droppedEmpty lines are removed. A genuinely empty record would need an empty field.
- Find the actual error firstIf rows break because of a stray quote, run the CSV validator to locate it.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use CSV formatter
Prepare a file for import
Make sure a tool that is picky about quotes or line endings accepts your file.
Clean up a hand-edited file
Remove stray spaces and uneven rows.
Switch regional formats
Convert a semicolon file from a European Excel to comma-separated.
Normalize fixtures
Keep test CSVs consistent in a repo.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
What counts as a well-formed CSV
RFC 4180 describes the common format: one record per line, fields separated by commas, and quotes around fields that contain commas, quotes or line breaks, with an inner quote written as two quotes. Real files bend these rules in many ways, and tools disagree.
This formatter reads files leniently and writes them consistently, so downstream tools see a predictable layout.
Which options to choose
Think about who reads the file next:
- Importing into a database or script: comma, quote only where needed, LF.
- Opening in Excel on Windows: CRLF, and a semicolon in regions that use a decimal comma.
- Sensitive to quotes: quote every field.
- Keep fields exactly as they are: switch off trimming.
- Use CSV delimiter changer if you only need to change the separator.
A cleanup routine that works
Start by detecting the separator, then trim spaces, pad rows and choose quoting. Run the CSV validator on the result: if it reports no problems, the file is consistent. Keep a copy of the original. Formatting never alters the cell values themselves, apart from trimming spaces when you leave that option on.
Questions, answered
How do I clean up a CSV file?
Paste it, choose the separator, quoting and line endings, and copy the formatted result.
Does cleaning my CSV upload the file?
No. The CSV is read and rewritten by script in this tab, so exports with personal data stay on your device.
Can it change semicolons to commas?
Yes. Choose 'Write with separator: Comma'.
What does 'give every row the same number of columns' do?
It pads shorter rows with empty cells so the table is rectangular.
Which line endings should I choose?
LF suits Mac, Linux and most tools. CRLF suits Windows and strict RFC 4180 readers.
Does it work on Android and iOS?
Yes. Recent mobile browsers run it. Open the file from your device or paste it.