New hire onboarding spreadsheet template
One item is one person starting, and everything payroll and IT need on day one. Recruiters, hiring managers, and staffing agencies, each with their own column names and their own idea of what a date looks like.
| Field | Type | Rules | Note |
|---|---|---|---|
| Full name | text | Required | |
| Work email | RequiredUnique | ||
| Job title | text | Required | |
| Department | enumEngineering · Design · Product · Sales · Marketing · Support · Operations · Finance · People | Required | |
| Start date | date | Required | |
| Employment type | enumFull-time · Part-time · Contract · Intern | Required | |
| Manager email | Optional | ||
| Location | text | Optional |
What this collection refuses to accept
“8/4/26” is read consistently across the whole column rather than a month here and a day there, and an impossible date like 31/02 is refused.
A work email that is missing an @, or that duplicates someone already in the collection, stops before it reaches your identity provider.
A department typed as “Eng” instead of “Engineering” is rejected once, and after you correct it the collection applies that fix to every later file.
Other collections people start from
Sales pipelineOne item is one company you are selling to.CompanytextContact emailemailStageone ofSeatsnumberand 4 morePrice watchOne item is one product page you are watching.Product URLurlProducttextRetailertextPricenumberand 3 moreVendor price listOne item is one product a supplier sells us, at a price.SKUtextProduct nametextUnit pricenumberCurrencyone ofand 4 more