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.
Free download. No signup required.
Excel (.xlsx) and CSV included. For Google Sheets, download the CSV and use File > Import > Upload.
Template preview
Sample rows so you can see what you will download. Scroll sideways on a phone if the table is wider than the screen.
| 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. |
What this spreadsheet looks like in ClientPlot
Upload your spreadsheet and ClientPlot turns the rows into clients, projects, tasks, deadlines and follow-ups on a live dashboard. Preview it before signup. Create a free account only if you want to save it. No credit card.
Dashboard preview
This replaces a formula Dashboard tab. Counts stay current after you import. Invoice totals and hours stay in the spreadsheet if you track them there.
Operational notes
After import, these counts stay current as you work. Invoice totals and hours stay in the spreadsheet if you track them there.
Clients with open work show here after import.
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.