Import equipment timecards from an Excel file

Prepare an Excel file for import

  1. Open a blank Microsoft Excel spreadsheet or download the sample file.
  2. 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.

  3. Enter your data starting from the second row.

  4. Save the file in Excel 97-2003 format (*.xls).
  5. Close the file to enable Sage Construction Management to import the data.
To import equipment timecards from a Microsoft Excel file, ensure that the equipment codes, project numbers, prime contract numbers, and cost codes in the file match exactly those used in Sage Construction Management.

Import the file

  1. Go to Equipment.
  2. In the Equipment Timecard Stats section, select the actions menu icon () in the Eqp. Timecards row.
  3. Select Import Equipment Timecards From Excel.

  4. Select Choose File and find the file on your local drive.

    The data will be imported automatically.

Microsoft Excel import sample

Download the equipment timecards sample file.

Equipment timecard file fields

Column name / First row Required (*) Field type Comments
Date * Date

  • Recommended date format: DD-MMM-YYYY

    For example, 15-Oct-2023.

  • US supported format: MM-DD-YYYY

    For example, 10/15/2023.

  • ISO supported format: YYYY-MM-DD

    For example, 2023-10-15.
EquipmentCode * Text The equipment code.
ProjectNumber * Text
PrimeContractNumber * Text
ChangeOrderNumber Text The change order number must exist in Sage Construction Management before importing the file.
CostCode * Text The project job cost code.
RTHours * Number The run-time in hours. For example, 4.25, 8, 8.5, 9.0, and so on.
ITHours * Number The idle-time in hours. For example, 4.25, 8, 8.5, 9.0, and so on.
DTHours * Number The down-time in hours. For example, 4.25, 8, 8.5, 9.0, and so on.
BillableStatus * Text

Options: Billable, Unbillable, or On Hold.

This field applies only to Cost Plus prime contracts.

Posted February 05, 2026 © 2026 The Sage Group plc or its affiliates ("Sage") or its licensors. All trademarks mentioned are the property of their respective owners. Use of non-Sage trademarks is not an endorsement of any person or product.