Data cleanup and QA tools
Compare exports, clean lists, find missing rows, generate SQL filters and prepare test data locally in your browser. Use these tools for QA checks, migration validation, production-vs-test comparisons and data cleanup tasks — no file ever leaves your machine.
Which data cleanup tool should I use?
CSV Join / Merge / Compare
Compare two CSV files by ID, email, SKU or another key and see missing, changed and duplicate rows.
Compare two CSV files by key →List Comparator
Compare two plain-text lists and find common, missing or extra values in seconds.
Compare two lists →CSV Viewer
Inspect, format and preview CSV data in a sortable table before comparing or exporting it.
View and inspect CSV →SQL IN Clause Builder
Convert a column of values into a quoted SQL IN (...) list ready to drop into a WHERE clause.
Line Tools
Trim, deduplicate, sort and clean lines of text — ideal for tidying copied data before a comparison.
Clean and dedupe lines →Common data cleanup and QA problems
- Compare two CSV exports by ID
- Find rows missing from one file
- Find changed rows between QA and production exports
- Remove duplicate lines from copied data
- Generate SQL IN clauses from Excel columns
- Prepare sample data for tests
- Reconcile migration outputs
Practical guides
FAQ
How do I compare two CSV files by key?
Use CSV Join / Merge / Compare. Pick a key column such as ID, email or SKU and the tool matches rows across both files, showing missing, changed and duplicate keys.
Can I find rows missing from one CSV file?
Yes. Comparing two CSV files by key reports rows that exist in one file but not the other, which is exactly how you find records dropped during a migration or export.
Can I compare QA and production exports?
Yes. Load the QA export and the production export, match on a stable key, and review the rows that differ to reconcile the two environments.
How do I generate a SQL IN clause from a list?
Paste a column of values into the SQL IN Clause Builder and it produces a quoted, comma-separated IN (...) list you can drop straight into a WHERE clause.
Can I remove duplicate lines locally?
Yes. Line Tools can trim, sort, deduplicate and clean lines of text in your browser, which is handy for cleaning copied data before a comparison.
Is CSV data uploaded to a server?
No. Every tool in this cluster parses and compares data locally in your browser. Files are not uploaded and are not logged.
Keep exploring
- JSON and API contract tools — validate schemas, diff responses, build JSON Patch.
- Security and debugging tools — sanitize HAR files, verify webhooks, decode JWTs.
- All tools — the full utility catalog.