A carpool sounds simple until the first Tuesday somebody's kid has the dentist. Four families, five days, two directions, a car with three seats and one with a booster stuck in it. Here's how to set one up so it survives October, and a free spreadsheet to start from.
Download the template: Excel (.xlsx) or CSV. To use it in Google Sheets, open Sheets, choose File, then Import, then Upload, and pick the file.
1. Write down who's in, and what each car can take
Before anyone agrees to a day, collect the same five things from every family:
- the parent who'll actually drive
- a phone number that gets answered at 3 p.m.
- which kids are riding
- how many free seats their car has, and whether a booster or car seat is already in it
- the days they can never drive
The template's Families sheet has a column for each. The seats column is the one people skip, and it's the one that breaks the plan the first time the family with the small car is on duty.
2. Pick how you'll split it
There are three common ways, and each suits a different group:
| Split | How it works | Good for |
|---|---|---|
| By day | Each family takes the same day every week | Groups with steady work schedules |
| By week | One family drives all week, then the next | Groups where one parent works from home some weeks |
| Morning and afternoon | One family does drop-off, another pick-up | Parents who can do mornings or afternoons but not both |
With four families and five school days, "by day" leaves Friday over. Rotate it: the template's example gives Friday to a different family each week.
3. Put the whole rotation in one place everyone can see
One row per drive: the week, the day, drop-off or pick-up, the time, where, who's driving, which kids and how many seats. The template's Rotation sheet is laid out that way, with the driver as a drop-down of the families you listed.
Share it with every family, not just the one who set it up. A schedule only one parent can see is a schedule only one parent remembers.
4. Agree how swaps work before you need one
Most carpools fall apart over swaps, not the schedule. Agree on three things on day one:
- Swaps are arranged between the two families, not announced to the group as "can someone take Thursday?"
- The sheet is changed the moment a swap is agreed: change the driver, and write who it was swapped with. The template has a column for that.
- One person is told when a day has no driver. If nobody can take it, that family's parent is the backstop.
5. Check the school's rules
Many schools only release children to adults on their pickup list, and some ask for a note when someone new is picking up. Make sure every driver is on each child's list before the first day. Our guide to who can pick up your child from school covers how pickup lists work.
Check your state's or province's car seat and booster rules too, and agree that nobody drives a child they don't have the right seat for.
When a spreadsheet stops working
A shared sheet is a good start, and for a steady group it may be all you need. It has three weak spots:
- It doesn't tell anyone anything. A change on Tuesday night sits there until somebody opens the sheet.
- An empty cell looks like any other cell. Nobody notices that Thursday has no driver until 3:05 on Thursday.
- Swaps drift into the group chat. "I'll take Wednesday!" in a thread of forty messages never makes it back to the sheet.
That's when a carpool app earns its place. Carpool Kids and GoKid are built for rotations between families. Kid Pickup is built for your own circle: you, your partner, the grandparents, a sitter, and the other carpool parent if you invite them as a helper. Each pickup gets one person who said "I'll do it", and if a pickup still has nobody, the app sends parents a nudge the day before, three hours out and again at two.
Frequently asked questions
How do you set up a carpool schedule?
List the families, kids, days, times and free seats; choose a split (by day, by week, or morning and afternoon); put the rotation in one sheet every family can see; and agree how swaps work before the first one.
How do you split a carpool fairly?
Count drives, not days. A family that does the long Friday run to soccer is doing more than one that does a five-minute school pick-up. Rotate the odd day out so it doesn't always land on the same family.
Is there a free carpool schedule template?
Yes. Ours is free, with no sign-up: Excel or CSV, which you can import into Google Sheets.
What's the best carpool app for parents?
It depends on who's driving. For a rotation between several families, see our comparison of carpool apps. If most of your rides are covered by your own people, Kid Pickup is built for that.