Excel Loop import: Import external properties

Use cases

• Bulk import external properties.

• Import external properties from external tools (such as testing tools, internal applications, etc.).

How to import external properties?

To import external properties from Excel spreadsheets:

• Navigate to the Import tab.

• Drag and drop or click the dropzone to upload your files.

What’s the expected format for spreadsheets?

For now, the import template is fixed:

• The first column must contain the requirement keys.

• The following non-empty columns must contain the external property values.

• For external property columns, the first row must contain the external property name.

How does the import work?

• The external properties are imported to requirements in the current space.

• The external properties are imported to requirements in the current variant.

• Existing external properties are overridden.

• When a cell is empty, the corresponding external property is removed.

How to download a sample spreadsheet?

To download a sample spreadsheet:

• Navigate to the Import tab.

• Click the download box or the Download button.

• You can use it as a starting point to import your data.

How to find out more about imported files?

When you import files, a temporary history of imported files is displayed.

Successful import

When a file is successfully imported, you can check the details to find out how many external properties were created, updated or removed.

Failed import

When a file import fails, you can check the details to find out more about the reason for the failure.

Limitations

• For now, only external properties can be imported.

• External properties can only be imported to requirements in the current space.

• External properties can only be imported to requirements in the current variant.

• We only support .XLS and .XLSX files.

• We limit the size of the spreadsheet to 10 MB.

• We limit the number of columns to 200 columns per spreadsheet.

• We limit the number of rows to 1000 rows per spreadsheet.