Data Quality Report
Count blanks, duplicates, type distribution, and outliers using rules you set.
Comma, semicolon or tab separated, or upload a CSV or XLSX file. The first row holds the column names.
Your result
Paste or upload a table to check each column.
How to use it
- Paste or upload the table.
- Read each column's card and badges.
- Download the report as text if you need it.
Examples
- Text in a number column120 and "n/a" A "Mixed kinds of values" badge
- Repeated rowTwo identical rows Counted as repeated
- Empty cellsA missing email A fill share and a badge
Tool details and privacy
Check a table column by column: empty cells, repeated rows, the kind of values, mixed values, stray spaces and rows with missing cells.
You see a file's problems before you import or analyse it.
Options
- Detects numbers, dates, emails and text.
Limits
- It does not fix the problems; use the CSV Cleaner for that.
- A column's kind follows most of its values.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
Does it change the table?
No, it only reads it.
How is the column kind chosen?
By the most common kind among its values.
Does it read XLSX?
Yes.
Is the table uploaded?
No.