You can add or update many projects at once by importing a spreadsheet with Assisted Import on the Assignar dashboard. Each project belongs to a client. Admins with the Data Import and Add Projects/Clients permissions can import projects.
A project import also updates projects: if a row's project name matches a project already in Assignar, that project is updated instead of a new one being created.
Your company can rename some words in Assignar, so you might see different words for Projects, Clients, Activities, Inductions, Competencies or Contacts in the column names.
Before you start
You need the Data Import and Add Projects/Clients permissions, and not Read Only.
Each project name must be unique. A row whose name matches two existing projects can't be imported.
A parent project must already be in Assignar before the import. You can't create a parent and its sub-project in the same file: import the parent projects first, then the sub-projects.
Import your workers first if you will list supervisors, so they are matched instead of created again.
Have your file ready as .csv, .tsv, .xls or .xlsx, with one row per project.
Columns for a project import on the dashboard
The table below shows the fields a project import on the Assignar dashboard accepts. Only Client Name and Project Name are required. Where a column takes several values, separate them with commas.
Field | Required | What to enter |
Client Name | Yes | The client the project belongs to, for example Harbour City Council. If no active client has this name, a new client is created. |
Project Name | Yes | The project's name, for example Kent St Stormwater Upgrade. Up to 100 characters. Can appear only once in the file. |
Start Date | No | Written as yyyy-mm-dd, for example 2026-10-26. |
End Date | No | Written as yyyy-mm-dd, for example 2026-11-13. |
Parent Project Name | No | The name of an existing project this one sits under. It can't be the project's own name. |
Project Address | No | The site address, for example Kent St, Sydney NSW 2000. Up to 255 characters. |
Supervisors | No | Workers who supervise the project, each written as first and last name, for example "Chloe Martin, Mia Kowalski". A name that doesn't match a worker creates a new worker with that name and no email. |
Project External ID | No | An ID from another system. Must not appear twice in the file or belong to another project. |
Project Inductions | No | Inductions needed for the project. New names are created as inductions with no issue or expiry date required. |
Project Competencies | No | Competencies needed for the project. New names are created as competencies. |
Project Tags | No | Project tags. New tags are created. |
Project Activities | No | Activities (cost codes) workers can use on the project, for example "Excavation, Demolition". New names are created as payable labour activities. |
Project Contacts | No | Contacts for the project, each written as first and last name. A name that doesn't match a contact creates a new contact. |
Names are matched without regard to capitals, so "excavation" matches the activity Excavation.
Import projects on the dashboard
To import projects with Assisted Import on the Assignar dashboard:
Go to Settings > Assisted Import.
On the Projects row, click Upload. The importer window opens straight away; there is no Data Formats window for projects.
Upload your file or type the projects in.
Match the columns in your file to the fields in the table above, and continue.
Fix any cells shown in red: a missing Client Name or Project Name, or the same project name twice in the file.
When every row is valid, click Submit Projects.
Wait for "This is now complete.", then close the importer.
The projects appear on the Projects page. The Audit Trail records how many projects the import created and how many it updated.
If any row has a problem when you submit, nothing from the file is saved, including any clients, activities, tags or contacts it would have created. The importer shows the problem, for example "Failed to import data due to error: Unable to import Project: Parent project 'Kent Street Stormwater Upgrade' not found." Fix the row and submit again.
Update existing projects with an import on the dashboard
To update projects on the Assignar dashboard with an import, put each project's exact current name in Project Name and fill in only the columns you want to change. When a project name matches an existing project:
A filled cell replaces that field, for example a new End Date or Project Address.
An empty cell leaves that field as it is.
Supervisors, inductions, competencies, tags, activities and contacts in the file are added to the project. The import never removes any. To remove one, edit the project on the Projects page.
You can't rename a project with an import, because the name is how the row is matched.
Error messages on a project import
These are the messages a project import on the Assignar dashboard can show after you click Submit Projects, each after "Failed to import data due to error: Unable to import Project:". The names in quotes are the ones from your file.
"Client name is required." or "Project name is required.": fill in the cell.
"Project name '…' appears multiple times in the import file. Project name must be unique per import.": keep one row for the project.
"External ID '…' appears multiple times in the import file. External ID must be unique per import." or "External ID already exists.": use a different Project External ID, or leave it blank.
"Parent project '…' not found.": the parent project isn't in Assignar. Import it first, or check the spelling.
"Parent project name '…' matches the project name for row …. A project cannot be its own parent.": clear Parent Project Name on that row. The row number in this message counts from 0, so row 0 is the first project.
"Multiple clients found with name '…'. Client name must be unique for import." (also for projects, parent projects, activities, inductions, competencies, contacts, tags and supervisors): Assignar has two records with that name. Rename or archive one of them, then import again.
"Supervisor '…' must be in 'First Last' format.": write the supervisor's first and last name.

