Bulk import your Tasks

In this article, we show you how to use the Tātou Office Bulk Import feature to quickly create new tasks. This handy feature will save you a lot of time setting up, so you can get on to doing what you do best—read on to find out how.

Before You Start

Download a copy of our template spreadsheet file to get started. You can open and edit this file using a spreadsheet program such as Microsoft Excel, or Google Sheets.

Make sure to save your spreadsheet as a .xlsx file or .csv file.

Step 1: Fill in the Details

Enter the details for your tasks in your spreadsheet. Simply create a new row for each new task code, with the appropriate details.

A list of the spreadsheet fields and what they mean can be found below:

  • task_category_name (required)

    • Name of the parent Task Category. Will be created if it doesn’t exist.

    • Example: Pruning

  • task_category_code (required)

    • Code of the parent Task Category

    • Example: PRU

  • task_category_costing_code (required if Type is “Client”)

    • Costing code for the parent Task Category

    • Example: WAGES

  • task_category_task_type (required)

    • Type of Task Category. Must be one of the following:

      • client

      • internal

    • Example: internal

  • name (required)

    • Task name

    • Example: Trim

  • code (required)

    • Task code

    • Example: TRIM

If you are using the Bulk Import feature to update existing tasks, make sure that the task_category_name and name fields match exactly what you have in Tātou.

Step 2: Import your File

To import your file, open Tātou Office, and find your list of task categories by clicking on Admin and then Tasks. Click on the IMPORT button, and then click the UPLOAD button to select your file.

If a row in your spreadsheet contains a task that already exists, this row will be skipped. If you are using the Bulk Import feature to update information for existing tasks, click the toggle to change the setting from Skip Existing Rows to Update Existing Rows.

Clicking CONFIRM will import your file—your changes have instantly been made!