Does this show changed values for IDs in both files?

No. It only reports whether a key is in one file, the other, or both. Use Compare Excel Files to see changed field values on matching keys.

What does “only in first file” mean?

The key exists in the first spreadsheet you uploaded but not in the second, using the key columns you selected.

Can I use multiple columns as a composite key?

Yes. Select more than one key column in the first file and the same number of matching key columns in the second file.

Excel & Data

Find rows that exist in only one Excel or CSV file

Upload two spreadsheets, choose the ID or key columns, and download a workbook listing keys only in the first file, only in the second file, in both, or ambiguous when duplicates appear.

Drop spreadsheet files here, or add them from your device.

Excel (.xlsx) or CSV. Add two files. The first is the original list, the second is the other list. Up to 15 MB each.

Add spreadsheets

What this tool does

It compares presence of keys between two Excel (.xlsx) or CSV files. For each key you select, it reports whether that key appears in both files, only in the first file (missing from the second), only in the second file (extra), or is ambiguous because the key is duplicated on either side.

How to use it

Upload two Excel or CSV files (first file is the original list, second is the other list).
Select the sheet to use in each file.
Choose the ID or key column(s) that identify each record.
Run the job and download the result workbook.

Example uses

List account numbers on a master file that are absent from a partner’s export.
Find SKU codes added in a warehouse file that are not on the catalog list.
See which employee IDs from payroll do not appear on the benefits enrollment file.

Supported files & limits

Excel (.xlsx) or CSV for each file.
Up to 15 MB per file.
Two files required.

What you get

An Excel workbook with a summary and sheets for rows in both files, rows only in the first file, rows only in the second file, and ambiguous keys. “Only in first file” means the key appears in the first list but not the second; “only in second file” means the key appears in the second list but not the first.

Important limitations

Classification depends on the key columns you select. If both files share the same column headers, one key selection applies to both; otherwise pick matching key columns with the same count in each file.
Keys that appear more than once on either side are listed on the Ambiguous sheet instead of being treated as only-in-first or only-in-second.
This tool finds presence on one side or the other. It does not report changed values on matching keys. Use Compare Excel Files for added, deleted, changed, and unchanged rows.

Frequently asked questions

Does this show changed values for IDs in both files?: No. It only reports whether a key is in one file, the other, or both. Use Compare Excel Files to see changed field values on matching keys.
What does “only in first file” mean?: The key exists in the first spreadsheet you uploaded but not in the second, using the key columns you selected.
Can I use multiple columns as a composite key?: Yes. Select more than one key column in the first file and the same number of matching key columns in the second file.