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
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.