Data and JSON tools Free · No sign-up · No upload

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
Your data
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: CSV → OUT: CSV
How was CSV formatter?
How it works

CSV formatter in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Add your CSV

    Accepted files include .csv, .tsv, .tab and .txt.

  2. STEP 02

    Set the format

    Choose the separator to write, quoting style, line endings, and whether to trim spaces and equalize column counts.

  3. STEP 03

    Copy or download

    The result keeps your data and normalizes the layout. The note reports rows and columns.

What you get

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.
Private by design

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 device→Their server→Your device

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

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

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.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends 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.

FAQ

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.