Help · Office

Imports

Bring in your tools, people, jobs, locations and categories from Excel or CSV, check every row first, and undo for 30 days.

On this page

Templates

Each list has a template. The Excel one has a sheet to fill in (with dropdowns), an Examples sheet that is never imported, and a Read me sheet explaining every column. The CSV has just the header row.

ListDownloadColumns (* = required)
CategoriesExcel · CSVCode*, Name*, Active, Service every (days), Service every (meter), Inspect every (days)
LocationsExcel · CSVName*, Kind, Sort order, Active
PeopleExcel · CSVEmployee no, Name*, Preferred name, Email, Phone, Title, Occupation, Field lead, Active
JobsExcel · CSVJob number, Job name*, PM, City, State, Status, Notes
ToolsExcel · CSVTool number*, Category code*, Description*, Type, Make, Model, Model year, Serial number, Barcode, VIN, License plate, Plate state, Replacement cost, Meter, Quantity, Location, Notes, Status, Purchase date, Category name

You can also download them in the app on each tab of Admin → Import (Download template (Excel)). Those copies have dropdowns of your own categories and locations.

Keep the header row exactly as it is. The column order can change; the names can't. A blank cell means "no value" for a new record and "keep what is there" for an existing one.

Which order

  1. Categories and Locations (or let the tools import add the missing ones).
  2. People, so each job can find its PM.
  3. Jobs.
  4. Tools.

Who can do this Categories, Locations and Tools: Admin. People and Jobs: Admin and Crib.

Import a file

  1. Open Admin → Import and pick the tab: Categories, Locations, People, Jobs or Tools.
  2. Under 2. Upload and check, choose your .xlsx or .csv file. (An old .xls? Open it in Excel and save it as .xlsx.)
  3. Choose Add new and update existing or Add new only (skip existing).
  4. Tools only: tick Add missing categories and locations if your file names some that aren't in yet.
  5. Read the 3. Preview. Nothing has been saved yet. It shows how many rows will be added, updated, left unchanged or skipped, and lists every problem by row and column.
  6. Fix problems in your file and upload it again, or press Import N rows to bring in the good rows and leave out the rest.
Import: get the template, upload, and check the preview before anything is saved.
Import: get the template, upload, and check the preview before anything is saved.

How rows are matched

  • Categories by code; Locations by name (capitals don't matter).
  • People by employee number, else the exact name.
  • Jobs by job number. A job with no number is always added as new.
  • Tools by tool number. For a tool that already exists only the descriptive columns are updated. Location and Status only apply to new tools: moves are made in the app, not by import.

Nothing is ever deleted by an import. A person marked Active = no is deactivated and their tools become unassigned. Over your plan's tool limit after the grace period, the preview says how many new tools would be refused.

Undo an import

Every import is listed under Import history. For 30 days you can press Undo…: what it added is removed and what it changed is put back. Anything that has been used or changed since the import is kept as it is, and the dry run shows you what is kept and why before you press Undo N now.

Get your lists out

Each tab has Export current … (Excel) and Export current (CSV): your current list in the same columns as the template. Handy for a big clean-up: export, fix in Excel, import back.