The Import Projects from File feature in Havelock allows you to easily create multiple projects at once using a template Excel file. This is a convenient way to bulk import projects with predefined data.
Where to access this feature
You can import projects from a file in the following locations:
From the Projects page, using the three-dot menu (⋯) above the table.
From the Projects tab inside a Goal.
Adding projects from a file
Step 1: Download the template
⚠️ Important: Only the template downloaded from the platform guarantees correct project creation. Do not rename the file, sheet name, or column headers — otherwise, the system won’t read the content properly.
Step 2: Fill out the template
Fill in the template with the necessary information. All required fields are marked with an asterisk (*).
Required fields:
Project name* – Name of the project
Deadline* – Project deadline
Type* – Type of project
Optional fields:
Start date - Project start date
Priority - Project priority (Regular or High)
Access - Project access (Private; Shared (default) or Public)
Time factor - Time factors that could be related to the project
Reference - The reference could be anything (invoice, order or contract number etc)
Quantity - How many pcs
Providers - Providers you’ll work with on this project
Clients - Clients you'll work with on this project
Description - Project description
Use template - Name of an existing project template
ℹ️ The owner of the created projects will be the one executing the flow. The owner can be changed once the projects are created.
Behavior when using a template:
If the column Use template contains the name of an existing project template:
The template’s values override all other fields in the row.
This ensures full consistency with the template’s configuration.
Step 3: Upload the completed file
Once the template is filled out, upload it using the Upload File button.
Only one file can be uploaded at a time.
The system will display a loading indicator while processing the file.
If an error occurs:
If even a single row contains missing or invalid values, the upload will be rejected. The user will receive an error message with detailed information what is wrong in order to re-upload a corrected version.
Excel file format and behavior
Column | Required | Behavior |
Project name | Yes | Free text |
Start date | No | Must be today or a future date (e.g. 30.05.2025). If left blank start date will be equal to the project creation date. |
Deadline | Yes | Must be today or a future date (e.g. 30.05.2025). |
Type | Yes | Only one value can be added and it must match completely the name of the desired project type from your account |
Priority | No | Single-select drop-down with two predefined options: Regular and High. If no value is selected the project will be created with Regular priority |
Access | No | Single-select drop-down with three predefined options: Private, Shared and Public. If no value is selected the project will be created with Shared access. |
Time factor | No | Only one value can be added and it must match completely the name of the desired Time factor from your account |
Reference | No | Free text |
Quantity | No | Input only numbers, but no more than five digits (e.g. 54201) |
Providers | No | Multiple values can be added. They should be separated by “,” and they must match completely the names of the desired providers from your account (e.g. Provider 1, Provider 2) |
Clients | No | Multiple values can be added. They should be separated by “,” and they must match completely the names of the desired clients from your account (e.g. Client 1, Client 2) |
Description | No | Free text |
Use template | No | Only one value can be added and it must match completely the name of the desired Project template from your account |
🗒️ Since Type, Time factor, Providers, Clients and Use template are not drop-downs with your actual account data you must manually enter the exact values. Here’s where to find it in your account:
Type: Settings > Projects > Project types
Time factor: Settings > Projects > Time factors
Providers: Settings > General > Providers
Clients: Settings > General > Clients
Use template: Settings > Projects > Project templates > Projects templates (default tab)
If you need assistance or encounter difficulties, please contact our support team.