What the import wizard does
The Import Wizard lets you bring a project's estimate in from an Excel spreadsheet. You map your spreadsheet's columns to Project Commander's fields, then import up to five data sections. The first three must be imported in order.
The Import Wizard is for Excel files only. If your estimate comes from Ensign estimating software, drop the Ensign Estimate (.zip) on the Import a Project card instead — see Importing an Ensign Estimate.
Opening the import wizard
You open the wizard from the project's dashboard.
- 1
Open the project. The Project Dashboard opens.
- 2
Drop your Excel file (
.xlsxor.xls) onto the Import a Project card, or click the card to choose the file. - 3
A Spreadsheet detected message appears. The Import Wizard opens with your file already loaded.
The Import a Project card is only on the dashboard until a schedule of rates has been imported.
Preparing your file
The wizard finds each section by its sheet name. Name your sheets:
- Cost Codes
- Buying List
- Schedule of Rates
- Preliminaries
- Prime Costs
Capital letters do not matter, and you can use underscores instead of spaces (e.g. cost_codes). Sheets with any other name are ignored.
Click Download Template at the top of the wizard to get an Excel template. The template has the first three sheets. Add Preliminaries and Prime Costs yourself if you need them.
Uploading a file
If the wizard opens without a file, or you click Remove to start again, upload your file here.
- 1
Click the upload area or drag and drop your file. The maximum file size is 5 MB.
- 2
Check the status grid. It shows which sheets were found in the file and how many rows each contains.
In the status grid, a green tick means the sheet has data. An amber warning means a required sheet is empty or Not found. Preliminaries and Prime Costs show Optional if they are not in the file.
Import sections
The wizard has five tabs. The first three must be imported in order — each depends on the previous one. The last two are optional.
1. Cost Codes
| Field | Required | Description |
|---|---|---|
| code | Yes | The cost code identifier |
| description | Yes | Description of the cost code |
| discipline | No | The discipline or trade |
| on_cost | No | On-cost percentage |
2. Buying List
Depends on cost codes being imported first.
| Field | Required | Description |
|---|---|---|
| component_code | Yes | Unique component identifier |
| description | Yes | Item description |
| cost_code | Yes | The cost code this item belongs to |
| quantity | Yes | Item quantity |
| material_cost | Yes | Material cost |
| labour_cost | Yes | Labour cost |
| total_cost | No | Total cost (can be calculated) |
| net_price | No | Net price |
| labour_time | No | Labour time |
| subcontractor_cost | No | Subcontractor cost |
| size_1, size_2, size_3 | No | Size dimensions |
Additional optional fields include assembly_code, list_price, discount, shop_labour_cost, shop_labour_time, unit_material_cost, unit_total_cost, unit_shop_labour_cost, and unit_shop_labour_time.
3. Schedule of Rates
Depends on the buying list being imported first.
| Field | Required | Description |
|---|---|---|
| description | Yes | Item or section description |
| section_number | No | Section number in the hierarchy |
| cost_code | No | Associated cost code |
| quantity | No | Quantity |
| rate | No | Rate per unit |
| material_cost | No | Material cost |
| labour_cost | No | Labour cost |
| subcontractor_cost | No | Subcontractor cost |
| total_cost | No | Total cost |
Additional optional fields include id, parent_id, is_section, code, component_code, rate_per_unit, unit_material_cost, unit_shop_hours, unit_site_hours, unit_site_cost, unit_subcontractor_cost, unit_total_cost, shop_labour_cost, is_assembly, size, and unit_of_measure.
Once the schedule of rates is imported, the project's Order Value is set to the schedule's total. It shows as Estimate Value on the Project Dashboard, and the dashboard's figures and charts appear.
4. Preliminaries (optional)
You do not have to import this section. If you do, you must map both fields — the import is refused otherwise. The screen does not mark these fields as required.
| Field | Required | Description |
|---|---|---|
| description | Yes | Preliminary item description |
| total_cost | Yes | Total cost |
5. Prime Costs (optional)
You do not have to import this section. If you do, you must map both fields — the import is refused otherwise. The screen does not mark these fields as required.
| Field | Required | Description |
|---|---|---|
| description | Yes | Prime cost item description |
| total_cost | Yes | Total cost |
Mapping columns
For each section, the wizard displays a column mapping interface. It matches your spreadsheet's columns to the fields as soon as the file loads.
- 1
Click the tab for the section you want to import, starting with Cost Codes.
- 2
Review the mappings. Each field shows a dropdown listing your spreadsheet's column headers. Required fields are marked with a red asterisk.
- 3
Adjust any mappings that were not detected correctly by selecting the right column from the dropdown.
- 4
Check the Data Preview panel to verify the transformed data looks correct. It shows up to 20 rows.
- 5
Click Import [Section Name] (e.g. Import Cost Codes) to import the data. A success message confirms how many rows were imported.
The Keys panel on the right lists every field for the current section with its description, an example value, and a colour-coded indicator showing whether it has been mapped (green) or is unmapped and required (red).
Click Auto-scan columns to run the automatic matching again. To start the mapping over for a section, click Clear All.
Sections must be imported in order: Cost Codes first, then Buying List, then Schedule of Rates. The import button for each section is disabled until its dependency has been imported. The wizard only remembers what you imported during this visit, so import every section you need — including Preliminaries and Prime Costs — before you leave the page. Once the schedule of rates is imported, the Import a Project card is no longer on the dashboard.
Next steps
- Schedule of Rates — view the imported schedule of rates.
- Budgets — view the budget analysis derived from imported data.
- The Project Dashboard — see the project's figures and charts once the import is done.
- Creating a Project — set up the project before you import its estimate.