Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Confluence
Teams
, (opens new window)
Requirement Yogi (Cloud)
Results will update as you type.
  • Getting Started - Tutorials
  • Best Practices
  • Administrator's guide
  • Features
    • Requirement types
    • Requirements search
    • Requirement dependencies
    • Traceability matrix
    • Report macro: Insert a matrix into a page
    • Coverage
    • Versioning
    • Transformation wizard: Transform your pages
    • Calculations
    • Linear documents: Manage requirements outside of tables
    • External properties
    • Excel Loop import: Import external properties
    • Configuration macro: Configure properties and documents
  • Requirement Yogi for Jira
  • Testing your requirements - Best practices
  • Integrations
  • REST APIs (Cloud)
  • Release notes
    Calendars
You‘re viewing this with anonymous access, so some content might be blocked.
/
Excel Loop import: Import external properties
Updated Sept 10

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

    {"serverDuration": 12, "requestCorrelationId": "5363699c36244659ba3a6c8e20ab6b71"}