Import Equipment Records

Things to Consider

  • Required User Permissions

  • Imported equipment categories, types, makes, models, and custom statuses are added to the tool's configuration settings.

  • The fields Equipment ID, Status Type, Status, Category, Type and Ownership are required.

  • If using the following custom statuses, the must have the following status types:

    • 'Available' needs an 'Available' status type.

    • 'Active' needs an 'In Use' status type.

    • 'Inactive' needs an 'Unavailable' status type.

  • The document must be in .xlsx format.

Early Access - Bulk Update Equipment

Company Administrators can enable the Resource Management: Q2 Improvements early access program in Procore Explore. (US 2 | UK)

  • You can re-import equipment to make bulk updates.

  • Equipment with matching Equipment IDs are updated.

Prepare Equipment Records for Import

  1. Navigate to the company's Equipment tool.

  2. Click Import.

  3. Click Download Excel Template to download the template.

  4. Enter your equipment information into the spreadsheet.

    Show/Hide Fields

    • Equipment ID. The unique ID for the piece of equipment.

    • Name. The name of the equipment.

    • Status Type. The category for the custom status:

      • Available

      • In Use

      • Unavailable

    • Status. The custom status name. See Configure Custom Statuses for Equipment.

    • Category. The category of equipment. Example: Earthmoving Equipment, Lifting Equipment, etc.

    • Type. The type of equipment. Example: Cement Mixer, Skid Steer, etc.

    • Make. The equipment's make.

    • Model. The equipment's model.

    • Year. The year the equipment was made. The year must be between 1970-Present.

    • Serial #. The equipment's serial number.

    • Notes. Any notes about the equipment.

    • Ownership. Who owns the equipment:

      • Owned

      • Rented

      • Subcontracted

    • Rate/Hr. The equipment's rate per hour in decimal format.

  5. Save the file.

Import

  1. Navigate to the company's Equipment tool.

  2. Click Import.

  3. Select the file.

    • Click Upload .xlsx File and select the prepared equipment file.

    • Drag and drop the prepared equipment file from you computer to the upload box.

  4. Click Upload.

Early Access

Company Administrators can enable the Resource Management: Q2 Improvements early access program in Procore Explore. (US 2 | UK)

  1. Navigate to the company's Equipment tool.

  2. Click Import.

  3. Click Update Existing.

  4. Click Upload .xlsx File and select the prepared equipment file.
    OR
    Drag and drop the prepared equipment file from you computer to the upload box.

  5. Click Upload.