MISTOOLS

CSV Viewer & Cleaner

Preview a CSV and clean it up before you import it somewhere else.

How it works

  1. Paste CSV data or open a file.
  2. Choose the cleaning options and the delimiter.
  3. Check the preview, then copy or download the cleaned CSV.

About this tool

CSV files from exports often contain blank rows, repeated rows, extra spaces and empty columns. This tool shows a preview table and cleans them in one go. It detects the delimiter (comma, semicolon, tab or pipe) and can change it for the output.

Quoted fields, commas inside quotes and line breaks inside cells are handled correctly. Files up to 5 MB can be processed in your browser, and the data is never uploaded. The preview shows the first 100 rows.

Questions

Can it open Excel files?

Save the sheet as CSV first, then open or paste it here.

How do I change a semicolon CSV to a comma CSV?

Choose the output delimiter. Detect automatically reads the input.

Is my file uploaded?

No. It is read and cleaned in your browser.

More tools

More free Developer tools