Clean
Clean up the values in a table in bulk. Pick the fixes, check before and after, then download the cleaned table. The same fixes can run on many files at once.
- Remove spaces
Free tool that removes leading, trailing and extra spaces, non-breaking spaces and zero-width characters from Excel and CSV files in bulk.
- Remove line breaks
Free tool that removes line breaks inside Excel and CSV cells, or replaces them with a space or other text, across many files at once.
- Remove blank rows
Free online tool that deletes empty rows and empty columns from Excel and CSV files in one go. No sign-up and no upload.
- Unmerge and fill
Free tool that unmerges merged cells in Excel and fills every cell with the same value, without VBA.
- Fill blanks from above
Free tool that fills empty cells in Excel or CSV with the value just above them, until the next value.
- Change case
Free tool that changes text in Excel and CSV to UPPER CASE, lower case or Proper Case for a whole column or sheet, without formulas.
- Fix garbled text
Free online tool that repairs garbled text (mojibake) such as “Müller” in Excel and CSV cells, restoring the original characters.
- Split a column
Free tool that splits one Excel or CSV column into several by a comma, space or other delimiter, by character counts, or where digits meet letters.
- Split names
Free tool that splits full names in Excel into first, middle and last name columns, including “Last, First”.
- Standardize dates
Free tool that converts dates stored as text in Excel or CSV — 20240401, 4/1/2024, 2024-04-01 — into one format you choose.
- Text to numbers
Free tool that converts numbers stored as text in Excel or CSV — with currency signs, commas, brackets or full-width digits — into real numbers.
- Find and replace
Free tool that finds and replaces many values at once with a list of rules, across several Excel and CSV files.
- Mask data
Free tool that masks sensitive columns in Excel and CSV: hide part with *, replace with a hash or consistent alias, or remove the column.