Almost every school-bus contractor starts with a route sheet: a spreadsheet with each route, its stops and students, the times, and who drives it. Printed and clipped to the visor, it's the driver's guide for the day. A good school bus route sheet template saves a lot of phone calls — and a sloppy one causes them. Here's what to put on it, a sample you can copy into your own spreadsheet, and the signs it's time to move your routes into software.
What goes on a school bus route sheet
Each route needs two kinds of information: the route itself, and the stops in order.
The route
- Route number — unique, and the same everywhere (the district's paperwork, your invoices, the bus window card).
- School (and its district), with the school's start and end bells.
- Runs — the morning run (pick-up) and the afternoon run (drop-off), with their times.
- Driver and bus for each run — sometimes a different driver in the afternoon.
- Aide, if one rides, with their phone and pick-up point.
- Special instructions — gate codes, where to wait, a parking rule at the school.
The stops
- Stop order and pick-up time.
- Student name and the pick-up address — which isn't always home.
- Guardian phone — and the student's own, for older students, if the district allows.
- Special needs — a wheelchair, a car seat, a medical need — in words the driver can act on.
- School, when the bus serves two schools.
A sample school bus route sheet template
Here's an example of how one route might look laid out in a spreadsheet. The names, addresses and times are made up — use your own columns in the same order.
| Route | Run | Stop | Time | Student | Pick-up address | Guardian phone | Special needs | School | Driver | Bus |
|---|---|---|---|---|---|---|---|---|---|---|
| 12 | Morning | 1 | 7:05 AM | Emma L. | 14 Oak St | 555-0101 | Lincoln Elementary | M. Chen | 101 | |
| 12 | Morning | 2 | 7:12 AM | Noah B. | 220 Pine Ave | 555-0102 | Car seat | Lincoln Elementary | M. Chen | 101 |
| 12 | Morning | 3 | 7:20 AM | Liam R. | 8 Elm Ct | 555-0103 | Riverside Middle | M. Chen | 101 | |
| 12 | Afternoon | 1 | 3:05 PM | Emma L. | 14 Oak St | 555-0101 | Lincoln Elementary | J. Okafor | 101 |
Whatever school bus route sheet template you use, keep one row per student per stop, and repeat the route number on every row — it makes sorting and filtering by route, driver or bus easy. Put the school's bells and any special instructions at the top of the printed sheet.
Tip: Add a ridership column for each day, or print a separate weekly sheet — the free school bus ridership sheet has a box for each student's morning and afternoon run, Monday to Friday.
School bus routes in Excel vs software
A spreadsheet is fine for a handful of routes that rarely change. The question of school bus routes in Excel vs software usually answers itself when one of these starts happening:
| The problem | Why a spreadsheet struggles |
|---|---|
| Changes don't reach the driver | Someone edits the file; the driver still has last week's printout. |
| Several versions | Dispatch, the office and the owner each have "the" route sheet — and they don't match. |
| Double-booked drivers or buses | Nothing stops you putting the same driver on two routes at 7:15. |
| Substitutes | When a driver is off, finding who's free and handing them the right sheet is all by phone. |
| Two schools on one bus | Bells, drop-off order and which student goes where get hard to read in one grid. |
| Billing and attendance | Invoices and ridership counts live in other files, typed again from the route sheet. |
Software doesn't change what's on your school bus route sheet template. It keeps one copy, puts it on each driver's phone, checks for clashes, and tells the driver every time it changes. Our post on the sending route changes to bus drivers covers that side.
How to import school bus routes from a spreadsheet
If your routes are already in a spreadsheet, you shouldn't have to type them in again. To import school bus routes from a spreadsheet, most systems follow the same steps:
- Download the system's CSV template, so the columns match.
- Copy your routes into it — one route per row, with each student's details in their own columns.
- Upload it and check the result before anything is saved.
- Import, then fill in whatever was missing.
Clean up first: one spelling per school, one format for times (7:05 AM or 07:05), and full addresses with the town. It saves most of the fixing afterwards.
Doing it in FleetCommander
In FleetCommander, open Routes, then Manage › Import CSV (or Settings › Import data and choose Routes). Press Download CSV template, fill in one route per row, upload it and press Validate file, then Import N rows. Each row needs a new Route Number. School 1 (the school that's billed) and, when the bus also drops at another, School 2 each have a name, district, address and bells; a school that isn't on the Schools tab yet is added with its district. Each student has First Name, Last Name, Address, Pick Up, Guardian Phone, Special Needs and School — the template has three, and you add Student 4, Student 5 … columns for more. Vehicle, Driver, Starts On (any day — past, today or later), Aide, Price, Status and Special Instructions are optional.
A routes file is always accepted: anything missing or not found is left out of that route and flagged, and only a row without a Route Number (or with one already used) is skipped. On Routes a flagged route shows a Missing info badge, the Missing info button shows only those, and the route's page has a Missing info box with Fill it in. A vehicle or driver already on another route at overlapping times isn't put on, and each driver who is put on a route is told about it. On a route that serves two schools, the morning run drops at the school that starts first, then the other, and only the first school is billed. The Routes guide has every column, and the routes and My Day page shows what drivers see.
Once your routes are in, Ava (Beta), the assistant built into FleetCommander, can check them for you: Which routes are missing info?, Is route 7 missing anything?, Who rides route 12? or Which routes have no driver today? Say Add a route and she asks for what she needs, one question at a time, then shows a card — nothing is saved until you press it. See her page.
Pricing a new route before you bid? Try the free school bus route price calculator, and see how to bill a school district for bus routes.
Good to know: Districts often have their own route sheet or ridership forms and rules on what student information a driver may carry. Check each district's contract and your state's student privacy rules.
Questions people ask
- What should be on a school bus route sheet?
- The route number, school and bell times, the morning and afternoon runs with their driver and bus, the aide, special instructions, and each stop in order with the time, student, pick-up address, guardian phone and any special needs.
- Is Excel good enough for school bus routes?
- For a few routes that rarely change, yes. Once changes have to reach drivers quickly, drivers or buses get double-booked, or you run two-school routes and substitutes, route software saves time and mistakes.
- Can I import my school bus routes from a spreadsheet?
- Yes. In FleetCommander you download the routes CSV template, copy your routes into it and import them; anything missing is flagged on the route for you to fill in later.