Can I combine candidate sheets from multiple open roles into one master pipeline view?

Yes. Upload each role's candidate tracking file and enable 'Include source file name.' Each candidate row is tagged with its role file, letting you filter and pivot by role in the unified pipeline report.

What if different role sheets have different stages in the pipeline column?

Deliteful combines data as-is. If one role uses 'Phone Screen' and another uses 'Initial Interview' for the same stage, both values appear in the output — they are not normalized. Standardize stage names in your tracking sheets for cleaner cross-role analysis.

Can I merge LinkedIn export files with my internal ATS export?

Yes. Upload both files together. LinkedIn and ATS exports will have very different column sets — Deliteful preserves all columns from both, with empty cells where one source doesn't have a field. You'll get a combined sheet with all candidate data from both sources.

Is this useful for diversity reporting across multiple roles?

Yes, if you track EEO or diversity data in your candidate sheets. Combining all role sheets into one file before running diversity metrics gives you a complete cross-role dataset in one place for reporting.

Merge Candidate Pipeline Excel Sheets From Multiple Sources Into One Recruiting Master File

Recruiters managing multiple roles or sourcing from multiple channels — job boards, LinkedIn exports, referrals, agency submissions — end up with candidate data spread across separate Excel files. Building a unified pipeline view, preparing hiring manager reports, or tracking offer status across all roles requires consolidating those files first. Deliteful's Excel Combine Sheets tool does that merge in one step.

Create free account

An in-house recruiter managing 8 open roles might have a separate candidate tracking sheet for each role, plus LinkedIn export files and agency-submitted candidate lists. Each file uses slightly different column names — 'Candidate Name' in one, 'Full Name' in another. Before any cross-role reporting or pipeline health analysis, all of that needs to be in one place. Without automation, consolidation happens manually at the worst time: right before the weekly hiring committee meeting.

Deliteful reads first-row headers from every sheet across all uploaded files and outputs the column union in one combined worksheet. Role-specific or source-specific columns appear for all rows; missing columns get empty cells. Enable 'Include source file name' and each candidate row is tagged with its role or source file — making it straightforward to filter the master sheet by role or channel for pipeline reporting.

How it works

1
Collect candidate tracking files
Gather .xlsx exports from your ATS, LinkedIn Recruiter, agency submissions, and internal tracking sheets for each role.
2
Upload all files to Deliteful
Drop all role and source files in one job — multiple workbooks and sheets are all processed together.
3
Tag candidates by role or source
Enable 'Include source file name' so each candidate row is labeled with its originating role or source file.
4
Download your unified pipeline file
Use the combined sheet for hiring committee reports, pipeline health analysis, or cross-role offer tracking.

Frequently asked questions

Can I combine candidate sheets from multiple open roles into one master pipeline view?: Yes. Upload each role's candidate tracking file and enable 'Include source file name.' Each candidate row is tagged with its role file, letting you filter and pivot by role in the unified pipeline report.
What if different role sheets have different stages in the pipeline column?: Deliteful combines data as-is. If one role uses 'Phone Screen' and another uses 'Initial Interview' for the same stage, both values appear in the output — they are not normalized. Standardize stage names in your tracking sheets for cleaner cross-role analysis.
Can I merge LinkedIn export files with my internal ATS export?: Yes. Upload both files together. LinkedIn and ATS exports will have very different column sets — Deliteful preserves all columns from both, with empty cells where one source doesn't have a field. You'll get a combined sheet with all candidate data from both sources.
Is this useful for diversity reporting across multiple roles?: Yes, if you track EEO or diversity data in your candidate sheets. Combining all role sheets into one file before running diversity metrics gives you a complete cross-role dataset in one place for reporting.

Create your free Deliteful account with Google and merge your candidate pipeline files into one master recruiting sheet before your next hiring review.