Clean Candidate Email Data Exported from Greenhouse
✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-12
Greenhouse is an applicant tracking system that stores candidate email addresses from job applications, recruiter sourcing, referrals, and career page submissions. Over hiring cycles, the candidate database grows with outdated contact information from people who have changed jobs, switched email providers, or let their university email expire. dataclean.to validates candidate emails from your Greenhouse export so your recruiting outreach reaches active inboxes rather than bouncing off dead addresses.
The Problem
Greenhouse candidate exports contain email addresses collected over multiple hiring cycles, often spanning years. Candidates who applied as students may have used university email addresses (.edu) that are deactivated after graduation. Sourced candidates have addresses pulled from LinkedIn or other platforms that may have been outdated at the time of entry. Recruiters sometimes enter email addresses from phone screens with transcription errors. When candidates apply to multiple positions, Greenhouse merges their profiles, but if they used different email addresses for each application, the export may contain only the primary (possibly older) email. Referral submissions include addresses entered by the referring employee, not the candidate, increasing the chance of errors. Agency submissions may include the recruiter's email rather than the candidate's own address. Greenhouse candidate data export guide
How to Fix It
1
Export candidate data from Greenhouse
In Greenhouse, go to the Reports section and generate a candidate export. Include email, name, current stage, source, and application date. Export as CSV for processing.
2
Upload the candidate CSV to dataclean.to
Import the Greenhouse export. The platform validates every candidate email address, checks domain viability, and flags addresses with common recruiter data entry errors.
3
Identify expired and institutional addresses
Flag .edu email addresses from candidates who likely graduated, company emails from previous employers they have since left, and any domain that no longer has active mail servers.
4
Correct transcription and formatting errors
Fix domain typos introduced during phone screen data entry. Clean up addresses with extra spaces, missing dots in domains, or other formatting issues that prevent delivery.
5
Export validated candidate contacts
Download the cleaned candidate list. Use it for nurture campaigns, re-engagement of past applicants for new roles, or migration to a new ATS with only verified contact data.
Frequently Asked Questions
How long do candidate emails stay valid after they apply?
It varies. Personal email addresses (Gmail, Outlook) typically stay valid for years. Company email addresses become invalid when the candidate changes jobs. University emails are often deactivated 6-12 months after graduation. The older your Greenhouse data, the higher the percentage of stale addresses.
Should I clean all candidates or just active pipeline?
Clean your entire candidate database if you plan to use it for sourcing past applicants for new roles. If you only need to contact candidates currently in your pipeline, filter the export to active stages before uploading to dataclean.to.
Does cleaning affect candidate records in Greenhouse?
No. dataclean.to processes your exported CSV file. No changes are made to your Greenhouse database. You can update individual candidate records manually in Greenhouse after reviewing the cleaned data.
Example: Input → Output
name
email
phone
city
status
Alice Johnson
alice@example.com
+1-555-0101
New York
active
alice johnson
ALICE@EXAMPLE.COM
5550101
new york
Active
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.