QuickMeld

Data Inspector

Find problems in your data, see the affected rows, and understand every column.

Your data stays in your browser

Advertisement

Data to inspect

Waiting for data

Inspection

No result

Enter supported data to inspect it.

Advertisement

Example

Inspection

Input

id,email
1,a@x.io
1,a@x.io
2,b@x.io

Output

Warning · Table · 1 duplicate row in 1 group
Rows: 1, 2
Sensitive-looking columns: email

How it works

  • Issues come first, errors before warnings and observations: invalid emails, dates, and other formats, mixed types, missing and whitespace-only values, duplicate rows, repeated keys, stray spaces, and casing variants.
  • Every count opens the rows behind it, with hard-to-see spaces, tabs, and invisible characters made visible. Copy them in your input's format.
  • Each column has a profile: its detected type, how complete and distinct it is, statistics and a distribution for numbers, the top 10 values, and patterns.
  • Likely and possible keys and sensitive-looking columns are named. Issues that Deduplicate & Normalize can fix link to it. Nothing changes your data.