Compare two Excel lists by email and keep the full rows
Paste two tables or open Excel files, select the email column in each, then copy the full registration rows missing from check-ins.
| Name | Department | |
|---|---|---|
| Ava Morgan | ava.morgan@example.com | Marketing |
| Mason Hughes | mason.hughes@example.com | Finance |
| Checked in | |
|---|---|
| ava.morgan@example.com | 9:02 AM |
Matching by email leaves Mason Hughes on the registration list only. Load the full example to copy the missing attendees with their names, emails and departments.
Try a sample workflow
Choose a task to see results with sample dataWhich part do you need?
Add two lists to see how they compare.
Save this workflow for next time
Only settings and column names are saved. List contents stay out of storage.
Select an underlined result to inspect its source rows and matching rules.
This view shows items only. Copy buttons still copy whole rows.
Find who missed check-in
- Add registrations to list A and check-ins to list B.
- Choose the email column in each table.
- Select only the A group to see who registered but didn’t check in.
Common questions
Why don’t identical-looking emails match?
Case is currently ignored: Lin@example.com and lin@example.com match. Check the matching rules for case, extra spaces and hidden characters.
Which row is kept when an email appears twice?
Within each list, the first row with that matching email is kept. If other columns differ, you can inspect the conflicting records.
How do I copy names and departments too?
Add the full tables, match by email, then choose full rows as the output. Check the column headers above the results before copying.
Can I compare 100,000 or a million lines?
Try two generated lists on this device. The demo replaces both current lists.
Speed demo: ·