Skip to main content

How do I import work orders from a spreadsheet?

Create many work orders at once, as parent work orders against a site or as child work orders under an existing parent, by uploading a spreadsheet.

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 with the choice between Work orders and Child work orders circled

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.

The Child work orders option selected, with its template and upload steps below

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

  1. Fill in one row for each work order, using the template's columns.

  2. Leave WO Code blank to create a new work order. A blank WO Code always creates a new work order.

  3. If you enter a WO Code that already exists, that row is skipped. Existing work orders are not updated by this import.

  4. Select Choose file and pick your completed .xlsx file.

  5. 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

Did this answer your question?