Buses import template

Every column of the buses sheet, what goes in it, and what people get wrong.

Step 4 of 6 in the setup workbook. Before this: Drivers. Next: Students.

The columns

Column	Needed?	What goes in it	Example	Common mistake
Licence	Yes	The number plate. This is what a bus is matched on, so keep it written the same way everywhere.	`AB-1234`	The same plate written two ways (AB-1234 and AB 1234) becomes two buses.
Capacity	Yes	How many children it seats. A route will warn you when more are mapped than fit.	`32`	Leaving it blank or putting a word in. It has to be a number.
Driver email	No	The driver who drives it, who must already exist.	`driver@example.com`	An address with a typo - the bus is created without a driver and the row says so.

Keep the first row exactly as it is. The column names are how the file is read - the order does not matter, but the names do.
Type into the first sheet. The Example sheet is only there to be looked at; it is not imported.
One row per thing. Do not merge cells, do not add a title row above the headings, and do not leave blank rows in the middle.
Nothing is saved until you press the button. You upload the file, read what each row would do, untick anything you do not want, and only then commit.
Uploading the same file twice does not create everything twice - a row that already exists is matched and updated instead.
Import drivers first if you want to attach one here, or leave Driver email empty and pair them up on the buses screen afterwards.

The stops sheet: every column explained, with the mistakes to avoid.

The routes sheet: every column explained, with the mistakes to avoid.

The drivers sheet: every column explained, with the mistakes to avoid.

See The School Bus Tracker with your own routes in a short, friendly demo.