Free Work Order Tracker Template
Work orders are jobs with a number, a customer, a technician, and a scheduled time. This template is a simple work order log for shops and field teams that still dispatch from a spreadsheet.
Excel and CSV included. For Google Sheets, download CSV and use File > Import, or click Open Google Sheets and upload the file.
Example
Sample rows so you can see how the tracker is meant to be used.
| Work Order | Customer | Job | Status | Scheduled Date | Assigned To | Waiting On | Notes |
|---|---|---|---|---|---|---|---|
| WO-1042 | Metro Deli | Walk-in cooler service | Scheduled | 2026-08-21 | Dee | After close, 8pm. Rear alley. | |
| WO-1043 | Ruiz Residence | Deck staining | Scheduled | 2026-08-23 | Chris | Side yard water shutoff. Friendly dog. | |
| WO-1044 | Patel Household | Roof leak inspection | Open | 2026-08-26 | Rina | Homeowner photos | North slope above the kitchen. |
| WO-1045 | Cedar Goods | Lighting retrofit remaining cans | Waiting | 2026-08-28 | Luis | LED cans from supplier | Sales floor only. Do not block register. |
| WO-1046 | Hale HVAC | Office mini-split install | Open | 2026-09-04 | Chris | Landlord approval | Quote 4412. Second floor office. |
Your spreadsheet stores the data. ClientPlot helps you work from it.
Import this tracker into ClientPlot and see clients, follow-ups, deadlines, tasks, and upcoming work in one dashboard.
Dashboard preview
This is the workspace shape, not a chart wall.
Upcoming schedule
- 2026-08-21 · Walk-in cooler service · Metro Deli
- 2026-08-23 · Deck staining · Ruiz Residence
- 2026-08-26 · Roof leak inspection · Patel Household
- 2026-08-28 · Lighting retrofit remaining cans · Cedar Goods
- 2026-09-04 · Office mini-split install · Hale HVAC
What is in the template
Work order number, customer, job/service, status, scheduled date, technician, waiting-on, and notes. Sample rows include emergency, scheduled, and waiting-on-parts work.
Work OrderThe ticket or WO number.
CustomerWho the work is for.
JobService being performed.
StatusOpen, scheduled, waiting, complete.
Scheduled DateWhen the technician is on site.
Assigned ToTechnician or crew.
Waiting OnParts, access, approval.
NotesLocation, codes, symptoms.
Who it is for
Service businesses that issue work orders and need to see what is open today without a field-service platform.
How to use it
1. Give every row a work order number
Even if it is just 2026-014. Numbers make callbacks and invoices match later.
2. Scheduled date is when you show up
Due date, if you add one in notes, can be when the customer needed it done.
3. Close or cancel rows. Do not delete history
A finished work order is still useful when they call in three months.
When a spreadsheet starts becoming difficult
- Dispatch is a group text
- Technicians do not see site notes until they arrive
- Waiting-on-parts orders vanish until the customer yells
- You cannot answer 'where is my guy' from one screen
Work orders as jobs under a customer
ClientPlot keeps the customer record and the work order as a job, with notes that travel to the phone.
Schedule on a calendar
Scheduled dates show up in calendar and today views instead of a buried column.
Assignment you can see
Technician names become assignments you can scan, not cell colors.
Frequently asked questions
Is this a full work-order system?
No. It is a tracker. It does not print parts lists or take payments. It keeps the queue visible.
How does a work order map in ClientPlot?
Customer becomes the client. Job becomes the job/project. Work Order number goes into notes so you do not lose the ticket id. Scheduled Date maps to due date.
Can technicians update this from a phone?
The spreadsheet depends on how you share it. In ClientPlot, team members can update assigned work from a browser on their phone.