Compare two tables (Excel .xlsx or .csv)
Upload two spreadsheets of records. Choose one or more key columns to identify a unique record (for people, typically Email or a combination like First name + Last name + DOB). RIA shows which records exist only in A, only in B, in both, and optional content changes.
Upload file
Drag or drop your files here or click to upload
Upload file
Drag or drop your files here or click to upload
Key columns
Select one or more columns used to uniquely identify a record.
Upload files to see columns
Options
What is this?
RIA (Record Integrity Analyzer) helps you validate data consistency between two tables. It is general-purpose and works with any tabular data where rows can be uniquely identified by one or more key fields.
- Accepts .xlsx, .xls, and .csv
- Pick key columns to match rows
- Options for trimming, case-normalization, and whitespace collapsing
- See counts and preview differences
- Export results as CSV