Love Data Tools
Simple tools for your data.

Data cleaning

Clean & Standardize CSV & Excel

Fix common spreadsheet inconsistencies, preview exactly what will change, then download a cleaned copy.

CSV and XLSXNo uploadPreview before download

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.

Help us improve Love Data Tools

We use Google Analytics to understand which pages and tools are useful. Your spreadsheet contents and filenames are not sent to analytics.

Privacy Policy