You can create many work orders in one go by filling in a spreadsheet and uploading it on the Work Order Import page. First choose whether you are importing parent work orders or child work orders. Colobbo records the result in Import History.
Open Work Order Import from the side menu.
The Work Order Import page. Step 1 asks what you are importing. Nothing in this picture was uploaded.
Step 1: Choose what you are importing
Work orders creates new work orders against a site. The service area, rate card and customer come from the site.
Child work orders creates work orders under an existing parent work order. Each child is matched to its parent by the parent's WO Code. The assignee, status, teams and rate cards come from the parent.
Choosing Child work orders changes the template that Step 2 downloads.
To create child work orders on their own, see How do I add child work orders to a work order on the web?.
Step 2: Download the template
Select Download parent template for parent work orders, or Download child template for child work orders. The template includes every custom field set up for the project, with dropdown lists for sites, types, assignees and teams.
Download a fresh copy each time. If the custom fields change, an older file is rejected. The Reference sheet inside the file lists the values that are worked out for you, rather than entered.
Step 3: Fill in and upload the file
Fill in one row for each work order, using the template's columns.
Leave WO Code blank to create a new work order. A blank WO Code always creates a new work order.
If you enter a WO Code that already exists, that row is skipped. Existing work orders are not updated by this import.
Select Choose file and pick your completed .xlsx file.
Select Import. The button shows how many work orders will be created.
Select Clear to remove the file and start again.
Step 4: Choose whether to publish
Under Step 4 — Options, tick Publish the work orders when the import finishes only if you want the work orders published straight away.
If you leave it unticked, every work order lands as a draft that you can review first.
If you tick it, publishing happens in one batch at the end, so each assignee gets a single notification rather than one for each work order.
A cancelled import never publishes.
Check the result in Import History
Import History is at the bottom of the page.
Frequently asked questions
Why was my WO Code skipped?
The code already belongs to a work order, so that row was skipped. Remove the code to create a new work order, or check the existing work order.
What file type can I upload?
An .xlsx file. If your file is in another format, open it in Excel, save it as an .xlsx workbook, then upload it again.
Related articles

