Data cleaning
Data Quality Audit for CSV & Excel
Scan a spreadsheet for missing data, duplicates, inconsistent values and other common quality problems before they cause trouble downstream.
Data Quality Audit
Scan a CSV or Excel file for missing data, duplicates, inconsistent values and other common quality problems.
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.
Find missing data
See which columns contain blanks, completely empty fields and how complete each column is.
Spot inconsistent values
Flag mixed data types, extra whitespace, capitalization differences and inconsistent date formats.
Check duplicates
Find exact duplicate rows and optionally test whether one or more key columns are genuinely unique.
What is a data quality audit?
A data quality audit checks a dataset for patterns that can make analysis, reporting, matching or importing less reliable.
Common problems include missing values, duplicate records, inconsistent formats, accidental whitespace and columns that contain several different types of data.
Love Data Tools profiles each column and highlights potential issues so you can decide what needs cleaning. If a field such as Customer ID should uniquely identify each row, you can also select it as a key and check for missing or duplicate keys.
The audit runs entirely in your browser, so the spreadsheet itself never needs to be sent to our servers.