Free Google Sheets Work Order Template
For technicians and office staff who want a printable work order with labor, materials, priority and a signature line, plus a log of every order.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Work Orders, Materials and Price List, no typing needed. |
| Work Order | Totals and views built from Work Orders, Materials and Price List, no typing needed. |
| Work Orders | Columns Work order number, Created date, Customer name, Phone, Service address, Requested work, Technician ID, Scheduled date, Arrival window and 10 more. |
| Materials | Columns Line ID, Work order number, Item, Quantity, Unit override (optional), Unit price override (optional), Taxable override (optional), Description override (optional) and Notes. |
| Price List | Columns Item, Description, Unit, Unit price, Taxable and Kind. |
| Settings | Your own dropdown lists (unit, technician id, technician name, status and priority), so the choices match how you work. |
How to fill it in
- Fill Price List with parts and labor items.
- Create the order on Work Orders with the requested work, technician and arrival window.
- Add materials on Materials as they are used.
- Choose the order number on Work Order and print it for the job or the customer.
A tip from the field
Record labor hours and materials the same day. Orders filled in from memory at the end of the week miss parts.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Work Orders (8 sample rows)
- Materials (6 sample rows)
- Price List (8 sample rows)
Related templates
When you outgrow it
Smarfle work orders live on the technician’s phone with checklists, photos and a signature, even with no signal. See how it works on smarfle.com.