CleanCSV

Delete, Rename and Reorder Columns

Keep only the columns you need, give them the names your import expects and put them in the right order.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above.

  2. 2

    In Columns, untick columns to remove them, type new names and use the arrows to move columns up or down.

  3. 3

    Optionally tidy every header at once with Trim spaces, Title Case or snake_case.

  4. 4

    Download the result.

Match an import template

CRMs, email tools, accounting software and online stores usually expect specific column names in a specific order. Rename and reorder your columns here to match the template, remove what it does not accept, and the import goes through without manual mapping.

snake_case for databases and code

The snake_case header style turns “Customer ID (Primary)” into customer_id_primary: lowercase, no spaces or symbols and no accents. That is ideal for SQL tables, data frames and APIs. Title Case suits reports that people read.

Missing and repeated header names

Columns without a header are shown as “Column 3” and so on; give them a name before exporting. JSON downloads make empty or repeated names unique automatically, for example column_3 or email_2.

Frequently asked questions

Can I remove several columns at once?

Yes. Untick every column you do not need, or use Remove empty columns to drop all blank ones automatically.

Can I add a new column?

Not directly. When you combine several files you can add a Source column showing which file each row came from.

Will reordering change my data?

No. Only the column order in the downloaded file changes. Every value stays in its row.