How to bulk add options to custom fields via the Jira CSV Import
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
It is not well known that you can add multiple options to a Select List (multiple choices) custom fields, via a .csv External System Import. This article aims to shed some light on this process as it can assist admins in creating/updating this type of field.
Environment
Jira Server/Data Center on any version from 9.0.0.
Preparing the CSV file
To be able to add multiple options to the custom field, you will need to add as many columns as options you want to add to the field to the CSV file. Each of these column will include the field name in the header row, and the option in the non header row.
For example:
- Let's assume that you have a Select Field custom field called "Multi Choice Field", and that you want to add 3 values to this field (Option 1, Option 2 and Option 3) in the issue key SCRUM-23
- To update this field using the CSV import, you will need to have in the CSV file:
- 1 column which includes the issue key of the issue that you wish to update
- 1 column which includes the issue summary (this field is mandatory for the import to work)
- 3 columns, which each include 1 option to add to the custom field
The CSV file will look like this:
Issue key,Multi Choice Field,Multi Choice Field,Multi Choice Field,Summary SCRUM-23,Option 1,Option 2,Option 3,"Some Summary"
The Import
To import the data, follow the steps outlined in this article, making sure to map our three columns to the appropriate fields. During the CSV import, you will go through the steps below:
- Step where you need to map the fields listed in the CSV file to the fields from the Jira application:
- Step where you need to map the options listed in the CSV file to the options configured for the custom field in the Jira application
After the Import process is finished, you should see the values informed in the .csv as valid options added to the Select Custom Field: