Data cleaning
Clean & Standardize CSV & Excel
Fix common spreadsheet inconsistencies, preview exactly what will change, then download a cleaned copy.
Clean & Standardize
Clean common spreadsheet inconsistencies, preview exactly what will change, then download a new CSV or Excel file.
Drop CSV or Excel here
Your file stays in your browser
Your file is processed locally in your browser. It is not uploaded to Love Data Tools.
Standardize messy values
Trim whitespace, normalize blanks and make text casing consistent across selected columns.
Fix dates and numbers
Convert selected date columns into one format and safely remove thousands separators from numeric values.
Preview every change
Review the source row, column, original value and cleaned value before downloading the result.
What does data standardization mean?
Data standardization makes values more consistent so they are easier to compare, import, match and analyse.
Common examples include removing accidental spaces, making capitalization consistent, converting placeholder values such as N/A into blanks, and putting dates into one predictable format.
Love Data Tools lets you choose exactly which transformations to apply. Potentially ambiguous operations such as date interpretation are explicit rather than guessed automatically.
The tool creates a new cleaned result and leaves your original file untouched.