Referential integrity checker
Find child records whose foreign keys have no matching parent in another CSV.
Parent keys must be nonempty and unique. Composite keys compare exact ordered strings without trimming or numeric coercion. An option allows entirely empty child keys; partly empty keys remain violations. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters. Paste CSV data with unique column headers. Quoted multiline cells are supported. Results update as you type. Up to 1,000,000 characters.
Your result
How to use Referential integrity checker
- Paste the child CSV in the main input and the parent CSV in the comparison field.
- Define matching ordered child and parent key columns.
- Review missing or incomplete child keys and download the report.
Useful next steps
Prepare the source
Paste the child CSV in the main input and the parent CSV in the comparison field.
Choose the matching rules
Define matching ordered child and parent key columns.
Review and keep the result
Review missing or incomplete child keys and download the report. Parent keys must be nonempty and unique. Composite keys compare exact ordered strings without trimming or numeric coercion. An option allows entirely empty child keys; partly empty keys remain violations.