Skip to main content
Skip table of contents

Excel Loop import: Import external properties

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.

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.