Clean up a CSV or Excel file: remove duplicates and empty rows, trim spaces, fix capitals, find and replace, split columns and sort.
Combining several spreadsheets? Use Merge Excel files. Turning a CSV into Excel? Use CSV to Excel.
It trims extra spaces, removes empty rows and columns, removes duplicate rows (all columns, or only some), fixes capital letters, finds and replaces text, splits one column into several and sorts the rows. Each step is optional.
Two rows are duplicates when the columns you pick have the same values (ignoring capital letters and spaces if you tick that). The first one is kept. Pick only an email column, for example, to remove repeated contacts.
Yes: CSV, TSV, TXT, XLSX and XLS. The first sheet is used. Download the cleaned data as CSV or Excel.
No. Your file is cleaned in your browser, so it's safe for customer lists and other private data.
