← All tools

Clean up your CSV file

Drop your CSV, set the cleanup options and download the fixed file. Your file never leaves this computer.

Drop your CSV file here or click to choose. To paste text instead, use the link below.

Why CSV files get "dirty"

CSV is a simple format that stores data as plain text separated by commas or semicolons. Accounting software, online shop dashboards, CRMs and bank statements usually export data as CSV. But these files often arrive with problems: spaces at the start and end of cells, empty rows, empty columns nobody uses and the same record repeated several times.

These problems cause errors when you import the file into another system: "Ann " and "Ann" count as different customers, empty rows stop an import halfway and duplicate orders inflate reports.

What this tool can do

Cleanup: trim spaces at the start and end of cells, collapse extra spaces inside cells, drop empty rows and completely empty columns, and remove duplicate rows by the whole row or by the columns you choose.

Columns: remove the columns you do not need and change their order. Find and replace: change a value across the whole file at once. Output: set the delimiter, line endings and quoting for the target system, and add a UTF-8 BOM for Excel.

The preview table updates after every step, so you see the result before you download.

Typical jobs

Fixing a product list from one online shop before uploading it to another marketplace, removing duplicates from an event sign-up list, dropping empty columns from an accounting export so only the needed fields remain, or trimming spaces before importing customers into a CRM.

Your file stays on your computer

CSV files often hold customer names, phone numbers, emails and sales data. This tool opens and processes the file in your browser and never uploads it to a server. It handles files up to 30 MB, and a 50,000-row file is processed in under a second.

How to use it

  1. Drop your CSV file into the box or paste the text.
  2. The delimiter and character encoding are detected automatically.
  3. On the left, set the cleanup of empty rows, duplicate rows and extra spaces.
  4. Check the preview and download the CSV.

Frequently asked questions

Accented letters look broken in Excel, what can I do?

Turn on Add UTF-8 BOM for Excel in the Output section. Excel then opens the file with the right encoding.

Do large files work?

Files up to 30 MB work as long as the browser has enough memory. A file with 50,000 rows is processed in under a second.

Can I remove duplicates by a single column?

Yes. Pick a column such as email in the Compare by list under Clean up, and the first row for each value is kept.

Related guide

Related tools