Posted in

5 Free School Bus Seating Chart Templates in Excel

5 Free School Bus Seating Chart Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A school bus seating chart shows where each student sits on the bus. Assigned seats help drivers keep order, make it faster to check who is on board, help with behaviour issues and give the school a clear record in an emergency. On this page you can download five free school bus seating chart templates in Excel: a daily school bus seating chart, a field trip bus seating chart with permission slip tracking and a bus route stop list, plus a weekly bus attendance register and a bus evacuation drill log.

Each file is a real, editable .xlsx spreadsheet. You type each student’s seat code on a rider list and the chart fills in automatically, so you never have to retype names on the seating plan. The sheets also count seats assigned and warn you if a seat has been given to two students.

Field Trip Bus & Cost Calculator

Buses needed:
Chaperones:   People travelling:   Empty seats:
Total cost:   Cost per student:

Runs in your browser; nothing is sent or saved. Chaperones are rounded up and counted as passengers. Check the seating rules for your buses (three small children per seat vs two older students).

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a School Bus Seating Chart?

A school bus seating chart is a diagram of the bus seats from front to back with the name of the student in each seat. Most charts follow the layout of a typical school bus:

  • Rows numbered from the front, usually 10 to 14 rows depending on the bus.
  • Seats on each side of the aisle, often labelled A and B on the left, C and D on the right.
  • Front and back marked, with the driver, door and emergency exit.

Schools usually pair the chart with a rider list that has each student’s stop, grade and parent contact.

Download Free School Bus Seating Chart Templates

The templates open in Microsoft Excel, Google Sheets and LibreOffice Calc.

1. School Bus Seating Chart

School bus seating chart template in Excel that fills seats from a rider list

A daily route seating chart for a bus with 13 rows and four seats per row (52 seats). The chart sheet has the bus number and route and the driver’s name, with FRONT (driver and door) at the top and BACK (emergency exit) at the bottom. Each row shows seat A (window), B (aisle), C (aisle) and D (window). The Riders sheet has 60 rows for the student name, grade, seat code, stop, parent phone and AM or PM (AM, PM or AM+PM from a dropdown). Type a seat code such as 3B and the student’s name appears in that seat on the chart, using INDEX and MATCH. The chart shows the number of seats, the number assigned and a “seat used twice” check that flags duplicate seat codes.

2. Field Trip Bus Seating Chart

Field trip bus seating chart template in Excel with chaperone groups and permission slips

A chart for trips and excursions, with 12 rows (48 seats). The header has the trip name, such as “Field trip: Science Museum”, and the driver. The Riders sheet has the student, grade, seat, group and chaperone (for example “Group 1 • Ms Lee”), parent phone and a permission column (Yes or No). As well as the seats assigned and duplicate check, the chart counts permission slips still missing and has a line to list the chaperones on the bus. Print the chart for the driver and lead teacher and use the rider list for roll calls on the way out and back.

3. Bus Route Stop List

School bus route stop list template in Excel with AM and PM times and capacity check

A list of stops for one route, with 15 rows. Each stop has the location, the AM and PM times, the number of students and the number picked up in the morning, plus notes. The sheet counts the stops, totals the students on the route, works out the AM route time in minutes from the first to the last stop and compares the total students with the bus capacity (52 in the sample), showing OK or Over capacity. The sample route has four stops over 23 minutes.

4. Bus Attendance Register

School bus attendance register template in Excel with morning and afternoon present and absent marks

A weekly register for one bus with a morning and afternoon column for each school day. Enter the route, the week starting date and the driver, then list each student and their stop. Mark P (present), A (absent) or E (excused) from a dropdown: absences turn red and present marks turn green. The sheet counts the rides for each student and their attendance percentage, and the bottom row counts how many riders were on board for each run, so you can check the head count before moving off. It holds up to 30 students and prints on one landscape page for the driver’s clipboard. Keep each week’s sheet as a record if a parent asks whether their child was on the bus.

5. Bus Evacuation Drill Log

School bus evacuation drill log template in Excel with exit used, time in seconds and pass or repeat result

A record of every bus evacuation drill for the school year. For each drill, enter the date, bus number, driver, number of students, the exit used (front, rear, front and rear, or a roof hatch walk-through) and how many seconds it took to get everyone off. Set your target time at the top, and the log marks each drill Pass or Repeat, in green or red. The summary counts the drills done this year and the average time. Many school districts require at least two bus evacuation drills a year, so the log gives transport managers and inspectors a clear record. The notes column is for anything to fix, such as a slow rear step or students who left bags behind.

How to Make a School Bus Seating Chart

  1. Check the bus layout. Count the rows and seats on your bus. If it has fewer rows, leave the extra rows empty.
  2. Get the rider list. Add each student with their grade, stop and parent phone on the Riders sheet.
  3. Decide your seating rules. Many schools seat younger students at the front, siblings together and students who need extra support near the driver.
  4. Assign seats. Type a seat code (row number plus letter, such as 4C) for each student.
  5. Check the chart. Make sure “Seat used twice” shows 0 and the assigned count matches the riders.
  6. Print and share. Give a copy to the driver, the school office and the transport coordinator.
  7. Update when riders change. Change the seat code on the Riders sheet and the chart updates.

Tips for Assigning Bus Seats

  • Youngest at the front. Kindergarten and early grades near the driver are easier to supervise.
  • Group by stop where possible. Students getting off at the same stop near each other speeds up drop-offs.
  • Keep siblings together if parents request it.
  • Separate students who have had behaviour issues.
  • Keep the emergency exit clear and follow rules about who may sit next to it.
  • Plan for accessibility. Students with mobility needs or medical conditions may need specific seats near the door.
  • Review after the first two weeks and adjust seats if needed.

Bus Safety and Emergencies

A seating chart is part of a school’s transport safety plan. In an emergency, the driver or staff can check quickly who was on board. Keep a printed copy on the bus and one in the school office, with parent contact numbers on the rider list. Many schools hold bus evacuation drills each year; follow your school district’s and local transport authority’s rules, which vary from place to place.

Planning a Field Trip

For trips, the bus seating chart is one part of a bigger plan:

  • Collect permission slips and track them on the field trip chart.
  • Group students with a chaperone for each group.
  • Count students before leaving school, at the destination and before returning.
  • Bring contact numbers and medical information.
  • Plan timings with the venue and the bus company.

Use the attendance list templates for roll calls and the daily planner templates for the trip timetable.

Who Can Use These Templates?

  • Bus drivers keeping order on daily routes.
  • School transport coordinators managing several buses and routes.
  • Teachers planning field trips.
  • Private schools and camps running their own buses.
  • Sports teams and clubs travelling to events.

How the Automatic Chart Works

The seating chart does not need you to type names into the seat boxes. Each seat cell looks up its own code, such as 5C, in the seat column of the Riders sheet and shows the student’s name if it finds a match. This has a few benefits:

  • One place to edit. Change a student’s seat on the rider list and the chart updates at once.
  • No copy errors. Names are spelled the same on the list and the chart.
  • Easy swaps. To swap two students, swap their seat codes.
  • Empty seats are obvious. Any seat without a matching code stays blank, so you can see free seats at a glance.

Type seat codes without spaces and with a capital letter (3B, not “3 b”) so they match the chart. If a name does not appear, check the code and make sure the row number is within the rows on that bus.

Managing Behaviour on the Bus

Assigned seats are one of the simplest tools for behaviour on the bus. Explain the seating plan and the bus rules to students at the start of the year, and share them with parents. Ask drivers to report problems to the school with the date, the seat and what happened, and keep a note on the rider list. When a seat change is needed, update the rider list so the driver’s printed chart and the office copy stay the same. Reviewing the chart every term, or after any incident, keeps it accurate as students join, leave or move stops.

Keeping Rider Information Private

The rider list holds students’ names, stops and parent phone numbers, so treat it as confidential. Print only what the driver needs, keep the full list in the school office and follow your school’s data protection rules when sharing it by email or in the cloud.

Related Templates

You can also check these useful templates like the school survey templates for transport feedback, and the contact list templates for parent contacts.

You may also like the lesson plan templates.

Frequently Asked Questions

How do I make a school bus seating chart in Excel?

Enter each student and their seat code (row number plus letter, such as 3B) on the Riders sheet. The chart fills in the names automatically.

How many seats does a school bus have?

It depends on the bus. The daily template has 13 rows of four seats (52 seats) and the field trip chart has 12 rows (48 seats); leave extra rows empty if your bus is smaller.

What if two students are given the same seat?

The chart shows a “seat used twice” count. Fix any seat code it flags.

Can I track permission slips for a field trip?

Yes. The field trip chart has a permission column and counts the slips still missing.

Can I use the chart in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.