CSV Cleaner

Clean messy CSV files online: trim whitespace from every cell, drop rows that are entirely empty, and tidy header names — in one pass, in your browser.

Free for files up to 5 MB and 10,000 rows. Files are processed in your browser — nothing is uploaded to a server. No account required.

About CSV Cleaner

CSV Cleaner does the two repairs almost every export needs: it trims leading and trailing whitespace from every cell and header, and drops rows where every field is blank. That is the whole operation — one button, no options to get wrong.

Those two problems are what break an import most often. A trailing space turns "Berlin " and "Berlin" into two different groups, and a file that ends with blank rows makes a loader read empty records. For mojibake and broken characters use the Encoding Fixer, and for changing case or padding a column use Text Transform — both are linked below.

Related tools