Bulk import to multiple issues

Owned by Santa Rudzite
Last updated: Jan 04, 2024
2 min read

This page explains how to efficiently import CSV files to populate tables in multiple Jira issues, saving time and effort.

File format

To import a table, the CSV file must include both the table's configuration and data, separated by commas or semicolons. The CSV file should match the configuration of the table that is to be imported and must contain an additional column on the left side for the issue key.

To make sure that the table format is correct the import tool allows to download of a CSV file template for the specific table. To retrieve the template go to Manage apps → STAGIL Tables & Checklists → Bulk table import. Select the table field and specify the delimiter for table values. Then use the link below to download the template.

To include a table with multiple rows into the CSV file, duplicate the issue key for each table row.

Import

To import table data follow the steps:

  1. To import the table, go to Manage apps → STAGIL Tables & Checklists → Bulk table import.

  2. Select the table field into which the data should be imported.

  3. Click ‘Browse’ to upload the file with table data, then specify the delimiter.

  4. Click the ‘Import’ button.

After the last step is performed, import will start running in the background. While the import is running an info banner will be displayed above the configuration fields. Once the import process is completed, the banner will disappear.

Result: after import the rows from CSV file will be added to the table fields. If the table already has pre-existing rows, the new rows will be added to the end of the table.

A log file for data import is available via the import log file link in the banner.

Configuration page, during a running import

 

© 2023, STAGIL