Import labor items from an Excel file
Prepare an Excel file for import
- Open a blank Microsoft Excel spreadsheet or download the sample file.
- Label the first row with the column names shown in the table below.
Make sure that all the required fields are included. Field names do not contain any spacing within the word, or before and after.
Make sure that the sheet is labeled as Sheet1.
-
Enter your data starting from the second row.
- Save the file in Excel 97-2003 format (*.xls).
- Close the file to enable Sage Construction Management to import the data.
Import the file from the Cost DB module
- Go to Cost DB.
- In the Internal Cost Database Stats section, select the three-dot menu icon (
) in the Labor Items row. - Select Import From Excel.
-
Select Choose File and find the file on your local drive.
The data will be imported automatically.
Import the file from the Time & Expenses module
- Go to Time & Expenses.
- In the Employee and Labor Stats section, select the three-dot menu icon () in the Labor / Craft Codes row
- Select Import From Excel.
-
Select Choose File and find the file on your local drive.
The data will be imported automatically.
Microsoft Excel import sample
Download the import labor items sample file.
Labor item file fields
| Column name / First row | Required (*) | Field type | Comments |
|---|---|---|---|
| Code | * | Text | Must be 25 characters or fewer. |
| Description | * | Text | Must be 255 characters or fewer. |
| BaseCostRate | * | Number | |
| BurdenCostRate | * | Number | |
| BillRate | * | Number | |
| WorkHrs | * | Number | For example, 8, 9, 10, an so on. |
| Classification system type and Division, Major, Minor, Subminor | Text |
The column header must be the classification system type followed by one of the following values:
For example:
You can reference multiple classification structures in the spreadsheet. |