Schema comparison tool

What does the schema comparison tool produce?

Compare two declared schemas and identify added, removed and changed field definitions.

Use the exact local files and task-specific inputs listed below. Preparation and review stay in this browser. Inspect all findings before preparing the finalized pack.

What do you need before you start?

• Define the authorized source population and your review rules.
• Keep the unchanged original files and record the snapshot and exclusions.
• Review missing and invalid inputs before preparing the finalized pack.

What information do you enter?

Select the actual local sources and freeze the task-specific inputs below. Keep source files and complete findings private.

• Separate primary and comparison exact-text CSV, one-sheet XLSX or dataset JSON sources.

What you can download

Every result must identify its supplied facts, assumptions and unresolved items.

Fictional review report (PDF). Editable review (DOCX). Complete fictional pack (ZIP). Requires tailoring and responsible review. Samples use the finalized renderer.

How does the schema comparison tool work?

1. 1
   Select the actual sources

   Separate primary and comparison exact-text CSV, one-sheet XLSX or dataset JSON sources.

2. 2
   Freeze the review rules

   Each schema file needs field, type, required and allowed columns. Required is true or false. Allowed is a JSON string array. Compare exact field names, type, required flag and allowed-value sets. Duplicate definitions remain unresolved.

3. 3
   Inspect complete findings

   Review all source-linked results and unresolved items. Free JSON and CSV preserve complete results.

4. 4
   Keep recoverable work

   Browser-local inputs and exact source files survive reload. Restore a validated exact-byte backup ZIP or explicitly approved private cloud revision. Earlier generic workspace keys, original files and historical purchases remain separate and preserved. Download preserved earlier strings and bytes before changing devices.

5. 5
   Prepare the finalized pack

   Prepare seven files, then download them free. Review the fictional sample below.

Method and sources

Apply the steps above to the supported inputs. Use the listed source sections to review the rule basis, assumptions and limits.

• Common Format and MIME Type for Comma-Separated Values (CSV) FilesCSV record, field and quoting conventions. This source does not specify customer schemas, matching rules, checksum arithmetic, sampling quality or import acceptance. Section 2. Definition of the CSV Format.RFC Editor. Reviewed 2026-10-08.
• Secure Hash StandardSHA-256 digest specification for exact source-byte and delivered-file checks. It does not establish authenticity or validate the named review rules. Section 6.2. SHA-256.National Institute of Standards and Technology. Reviewed 2026-10-08.

Common questions

What still needs review?

Each schema file needs field, type, required and allowed columns. Required is true or false. Allowed is a JSON string array. Compare exact field names, type, required flag and allowed-value sets. Duplicate definitions remain unresolved.

Checks do not authenticate source records, population completeness, identifier issuance, external checks, a completed import or compliance.

Use at most 5000 data rows, 50 fields, 100000 cells and 5000000 parsed characters. Up to 10 MB per source. Typed spreadsheet cells, stored formulas and multiple worksheets require an explicit text export.

Formal reports show at most 100 rows and 300 characters per displayed field. Excel and JSON preserve complete results.

Related working records

The related workspace contains working administrative records. Open it for the related administrative task.

Related tools

Browse all data quality and evidence tools.

• CSV and XLSX validatorCheck structure, types, mandatory fields and allowed values. Try a free example. Review your inputs and result. No account or payment required.
• Exact duplicate detectorIdentify records matching selected keys. Try the free example, then enter your own inputs and review the result before exporting.
• Missing-record reportCompare expected and observed populations. Try a free example, then review your inputs and the result. No account or payment required.
• Cross-file reconciliationMatch selected keys and report unmatched records. Try a free example, then review your inputs and the result. No account or payment required.
• Total and balance reconciliationShow arithmetic differences and their source rows. Try a free example, then review your inputs and the result. No account or payment required.