Compare records across
CSV and Excel exports.
Choose what identifies a record, connect the fields that correspond, then inspect the differences in context.
Start with the files you have.
Open CSV files or select a worksheet from an XLS or XLSX workbook. Each side can use a different supported format, so a spreadsheet export can be compared with a CSV from another system.
The importer works locally. Your input data is not uploaded for comparison, and the original files remain your reference point.
Understand Excel import and its limitsMatch columns with different names.
“Customer ID” and “client_id” can describe the same field. Review suggestions based on header patterns and overlapping data, then keep, change or remove each mapping.
Supported JSON object cells expose individual values for mapping. Keep billing and shipping contexts separate when connecting nested address fields to flat columns.
Match records, wherever they moved.
Select an explicit mapped row key to compare the same records even when the files have different row orders. Use several key fields together when a single identifier is incomplete, such as an order ID plus a line ID.
Duplicate and blank-key warnings help expose ambiguous identity. Inspect those groups before treating a particular pairing as an exact history of a record.
Understand duplicate-key warningsReview the whole difference.
Search by key or value, filter changed records or records found in only one file, and inspect complete rows side by side. The original filenames remain visible so you can see where each value came from.
Results are paged for review. Export the filtered comparison report when the current view answers your question; changing a result filter does not run a new comparison.
Follow a complete comparison workflowCheck the fit before you begin.
macOS 14 or later. The trial supports up to 5,000 data rows per file and ten successful comparisons. Excel import limits remain after purchase.