What are the requirements for importing BOQ Line Items from CSV?

Required Import File Format

Always download and input your data into the required CSV template from the appropriate Procore tool.

Delimiter

When downloading the blank import template, some Procore tools allow you to customise the delimiter. A delimiter is a character used to separate values or text strings. It marks both the beginning and end of a unit of data. The choices are:

• Comma. Separates data using a  comma (,). This is Procore's default option. 
• Semicolon. Separates data using a semicolon (;). 

Column Data

A CSV file is a delimited file that stores tabular data and uses a comma to separate values. Each row in the file corresponds to a data record. In this case, the data record is a line item that you want to add to the BOQ. 

• Do NOT add data columns to the template. Column headings must match the expected field names in Procore. 
• Do NOT move data columns in the template. Columns and any data that you input into them must be input in the order required by Procore's database. 

In order to import sub jobs, the sub job feature must be active on your project. See Enable Sub Jobs and Add a Sub Job to a Procore Project. 

Row Data

• Procore does NOT import line items when data entry is missing from these fields:
  • Cost Code Name. Your entry must exactly match the cost code name in the Project Admin tool. 
  • Cost Code Number. Your entry must exactly match the cost code number in the Project Admin tool. 
  • Line Item Type. You must enter a value in this field.
  • Amount or Quantity/Description/Unit Price. You must enter a value in this field. Your data entry requirements depend on the accounting method set on the contract. See How do I set the accounting method for a contract or funding?
• You can add multiple line items with the same cost codes, even if they have the same category. In the example below, two (2) separate line items are created.
  • 02-300 - Earthwork, M, $30,000
  • 02-300 - Earthwork, M, $10,500

Limitations

• The CSV import file does NOT support entry of budget codes. See What is a budget code in Procore's WBS? Instead, you must enter the appropriate cost code, cost type and optional sub job segment items for your line items directly into the import template. 

Additional Information

• Line Item Types/Cost Types can be found by navigating to the Contract Configuration page in the Company Admin tool. 
• To learn more about preparing for the import process, see How do I prepare my data for import into Procore?