Employee Onboarding Tracker from a Spreadsheet — Free

Three new hires start a week from Monday, and each one needs the same forty things to happen in the right order. IT has to image a laptop and provision accounts. Payroll needs banking details before the first cutoff. Benefits enrollment runs on a federal clock. And the hiring manager owes a 30-day check-in that — historically — happens around day 55.

Onboarding is a project that repeats, with a deadline structure that doesn't forgive. A missed training date is awkward; a missed I-9 verification window is a compliance problem with a fine attached. Yet the work is split across three groups that don't share a queue: HR owns the checklist, IT owns the equipment, the manager owns the human — and the handoffs between them are where new hires fall through. Dedicated onboarding platforms exist, but at roughly $10 per user per month across HR, IT, and every hiring manager, you're buying seats for people who'd open the tool twice a quarter.

Most HR teams already run this from a spreadsheet checklist, duplicated per hire, decaying per quarter. The sheet isn't the failure point. The missing piece is visibility — who's blocked, what's overdue, and whether Priya's laptop will exist by Monday. That's an interface problem, and AI can build the interface on the sheet you already maintain.

Step 1: Start With Your Onboarding Checklist

One row per task per hire. Keep a master "template" tab holding the canonical checklist; each new hire gets rows stamped from it:

The Checkpoint column — Day 1 / 30 / 60 / 90 — is what turns a pile of tasks back into a timeline.

Step 2: Set Up a Free Account

Sign up at lovespreadsheets.com; the free account covers the build and daily use. Paid options add logins for IT and hiring managers under your company's domain, useful once the rollout sticks.

Step 3: Describe Your Onboarding Process

Open the Project Tracker template and lay out the process the way you'd explain it to a new HR coordinator:

• "Every task belongs to one new hire and one owner — IT, HR, or the hiring manager — and nothing counts as done until its owner marks it."
• "Anything with Checkpoint set to Day 1 must be finished before the start date, no exceptions."
• "I-9, background check, and benefits enrollment are compliance tasks; their due dates are hard deadlines."

Then request:

• Per-hire checklist boards cloned from the template tab, so opening a board for a new hire takes one click instead of twenty minutes of copy-paste
• A day-1 readiness view — for each upcoming start date, the Day 1 tasks still open, grouped by owner
• Overdue-compliance flags — any compliance task past due turns red and emails both HR and the task's owner

Run AI Optimize if your description feels underspecified, answer the follow-up question or two the AI asks, and give the build 15 to 20 minutes.

Step 4: Every Hire, One Glance

You're left with a web app where each new hire is a board, each board came from your template, and the top of the screen answers the question that matters: is anyone starting soon who isn't ready? IT sees only IT tasks, managers see their own hires, HR sees the whole pipeline — and every checkbox anyone ticks lands in the sheet instantly, because the app and the sheet are two views of the same rows.

Why HR Teams Keep the Sheet

Audits want documentation, not screenshots. When someone asks for proof that every 2026 hire completed harassment training, the sheet is the record — filterable, exportable, dated row by row.

The checklist stays yours to evolve. Add "security awareness training" to the template tab once and every future hire inherits it. No vendor ticket, no admin-console safari.

Three departments, no three licenses. Pulling IT and every hiring manager into a dedicated HR platform means paying for logins they barely use. A sheet-backed tracker doesn't put a price on collaboration.

Common Questions from HR Teams

Can hiring managers update their part without seeing sensitive data? Yes — ask for manager views scoped to their own new hires and only non-sensitive columns.

What about offboarding? Same structure, different template tab. Many teams run onboarding and offboarding from one sheet with a Process column and separate boards.

We hire in bursts — ten people in one month. Does this hold up? That's when it earns its keep: ten boards from one template, a single readiness view across all ten start dates, and compliance flags that don't care how busy you are.

Build Yours

Open your onboarding checklist — or draft the eight columns above from your last hire's paper trail — take it to lovespreadsheets.com, and walk it through how a new hire gets from offer letter to day 90. The next start date arrives either way. This way, the laptop does too.