How do I deduplicate a candidate list in Excel before importing into my ATS?

Upload your Excel export to Deliteful, enter 'email' as the key column, and download a clean file with one row per unique email per sheet. Then import the clean file into your ATS.

Can I deduplicate across a workbook that has one sheet per job requisition?

Each sheet is deduplicated independently — duplicates within the same sheet are removed, but the tool does not compare candidates across different sheets.

What if candidates appear with slightly different email formats (e.g., caps vs. lowercase)?

Matching is case-sensitive, so 'Jane@example.com' and 'jane@example.com' would be treated as different values. Normalize email case before uploading for best results.

Does this work for deduplicated outreach lists to avoid double-emailing?

Yes — uploading your outreach list and deduplicating by email column will give you a unique-email list to feed into your email tool or sequence.

Deduplicate Candidate Lists and Applicant Exports in Excel

Candidate pipelines pulled from LinkedIn Recruiter, your ATS, and manual outreach trackers frequently produce Excel exports with the same candidate appearing multiple times. Deliteful removes duplicate rows from your applicant workbooks using an email or candidate ID column, so your sourcing counts and outreach lists reflect unique individuals.

Create free account

Recruiters managing high-volume pipelines across multiple sources — job boards, LinkedIn, referrals, agency submittals — regularly combine candidate data into Excel workbooks for review or import. The same person can appear as both an inbound applicant and a sourced candidate, or across two ATS exports that overlap on date range. Deduplication before outreach prevents embarrassing double-contact; deduplication before import prevents inflated pipeline metrics.

Deliteful deduplicates each worksheet independently. Specify 'email' or your candidate ID column and the tool keeps the first occurrence of each unique value per sheet, dropping all subsequent duplicates. If a sheet doesn't have the specified column, full-row matching is used. Output is a clean Excel file with values only — ready to import into your ATS or CRM, or hand off to a sourcing coordinator.

How it works

1
Export your candidate list to Excel
Pull your applicant or sourcing list from your ATS or LinkedIn as an .xlsx file.
2
Upload to Deliteful
Upload the workbook — all sheets are processed in a single step.
3
Enter your identifier column
Type 'email' or your candidate ID column name to deduplicate by that field.
4
Download the clean list
Receive a deduplicated Excel file ready for import, outreach, or review distribution.

Frequently asked questions

How do I deduplicate a candidate list in Excel before importing into my ATS?: Upload your Excel export to Deliteful, enter 'email' as the key column, and download a clean file with one row per unique email per sheet. Then import the clean file into your ATS.
Can I deduplicate across a workbook that has one sheet per job requisition?: Each sheet is deduplicated independently — duplicates within the same sheet are removed, but the tool does not compare candidates across different sheets.
What if candidates appear with slightly different email formats (e.g., caps vs. lowercase)?: Matching is case-sensitive, so 'Jane@example.com' and 'jane@example.com' would be treated as different values. Normalize email case before uploading for best results.
Does this work for deduplicated outreach lists to avoid double-emailing?: Yes — uploading your outreach list and deduplicating by email column will give you a unique-email list to feed into your email tool or sequence.

Create your free Deliteful account with Google and deduplicate your candidate Excel exports before your next ATS import — no card required.