Rapikan file CSV atau Excel: hapus duplikat dan baris kosong, pangkas spasi, perbaiki huruf kapital, cari dan ganti, pecah kolom, dan urutkan.
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.
