ToolJovia
Data

CSV Foreign Key Checker

Check child records against unique parent composite keys with explicit blank-key handling.

✓ Browser-local processing

Loading tool…

How to use CSV Foreign Key Checker

Find referential gaps before importing related tables. Parent uniqueness is checked first, then each child tuple is compared as exact text without dropping unmatched records.

  1. Enter parent csv, child csv, parent key columns, child key columns.
  2. Choose the settings for csv foreign key checker, then run the tool.
  3. Review the result and any limitations before copying or downloading it.

Good to know

  • Up to100,000 input characters,5000 records and100 columns per table. Downloads quote cells, protect formula-like values and disambiguate colliding exported headers.
  • Up to1000 detailed violations. Whitespace-only strings are literal key data, not empty cells. No database is contacted.
  • Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.

Common questions

Does a skipped blank key count as valid?

It is excluded by the selected policy and counted separately, so the report does not hide which records were unchecked.

Is this input sent to a server?

No. The application processes this input inside your browser tab and does not save it to persistent storage.

Keep going with related tools

All data →
Data

CSV Join Workbench

Join two CSV tables by explicit composite keys with inner, left or full record-preserving joins.

Data

Supported CSV Data Schema Validator

Check a small declared CSV schema for column types, required cells and composite primary-key uniqueness.

Data

CSV Record Comparator

Compare two CSV tables by declared key columns, ignoring record order and reporting cell changes.

Data

CSV Functional Dependency Review

Find concrete original-record counterexamples to declared determinant-to-dependent field rules in supplied CSV data.

Data

Categorical Observation Grid Auditor

Compare observed CSV factor combinations with an explicit expected grid and retain missing and replicated-cell witnesses.

Data

CSV Conditional Record Rule Auditor

Check explicit per-record IF/THEN field rules with exact string or decimal comparisons and bounded witnesses.