Breadcrumbs

Excel Loop import: Import external properties


Want to take a quick glance at the Excel Loop feature? Check out this tutorial:


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 Traceability tab, click on ‘Import external properties’.

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

Gif-Import-excel-Loop.gif

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.

sample.png

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.

download-sample.png

How to find out more about imported files?

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

history.png

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.

success.png

Failed import

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

failed.png

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.