How to import issue links from a CSV file in Jira

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

This article contains instructions to help in importing issue links to Jira from a CSV file.

The process for importing Issue Link through CSV is similar to importing Sub-tasks, as described in Importing Data from CSV. One column must be mapped to a respective issue, which may or may not exist already in Jira, and the other as the desired link type (e.g. 'X blocks Y').

When importing the issue link via CSV, Jira will consider the link you provide as the Outward link description. You can't choose between Inward or Outward links. This is currently being tracked in:  JRASERVER-61571 - Getting issue details... STATUS

In the CSV file, the column with the Outward Link Description you want to create a link, needs to have a value for the corresponding issue that the link should be created against. See the example below:


Summary,Issue Key,Blocks  ,Clones
Issue1,TEST-1    ,TEST-2  ,    
Issue2,TEST-2    ,        ,TEST-3
Issue3,TEST-3    ,        ,     

Once the CSV file is prepared like in the example above you can follow the steps from Importing data from CSV to import it. If the import is successful, you should end up with the following relationship between the issues:

  • Issue1 (TEST-1): blocks Issue2 (TEST-2)
  • Issue2 (TEST-2): clones Issue3 (TEST-3)

We will also have the Inward links created automatically. In the UI we should see the following:

It's important to note that you need to select the proper Issue Link Type you want the import to create during the import. The column name isn't responsible for doing this, but you should use a name that helps you identify them in the import tool because you will need to associate the column with the link type in the Map Fields step of the CSV import, as in the example below:


If you have multiple links from the same issue to different issues, you can add these in two ways

  • 1: Add a new line for each link 

    Summary,Issue Key,Blocks  ,Clones
    Issue1,TEST-1    ,TEST-2  ,   
    Issue1,TEST-1    ,TEST-3  ,
    ...   

2: Add an extra column 

Summary,Issue Key,Blocks  ,Blocks  ,Clones
Issue1,TEST-1    ,TEST-2  , TEST-3 ,  
...   

Both the above options will create 2 links:

  • Issue1 (TEST-1): blocks Issue2 (TEST-2)
  • Issue1 (TEST-1): blocks Issue3 (TEST-3)


Optionally, you can also create new Jira issues with their respective issue links. However, for this you need to correctly specify the issue keys that Jira will create once those issues are imported, otherwise, the issue linking will happen to the wrong issue keys.

The easiest way to identify the next issue keys that will be used for the projects you are importing data against is by creating a new issue on them and checking the number in the issue key. For example, if you create a new issue in the project called TEST and the issue key is TEST-299; The next issue key should be TEST-300.

During this time, you need to ensure that users are not actively creating issues on those projects. We usually see that it's easier to follow a two-step approach in such scenarios:

  1. First, create the issues using one CSV file;
  2. Import the issue links using a separate CSV file, using the issue keys you obtained after the step above.

In case any assistance is required from Atlassian please get in touch through https://support.atlassian.com/contact/.


Last modified on Sep 11, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.