Excel Loop import: Import external properties

Owned by João Brilhante
Last updated: Jun 11, 2024 by Mileva Briand
3 min read

 

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

https://youtu.be/s04m7OMfOMY?si=xrCLtpUhi_haWHMJ

 

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.

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.

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.