How to link multiple issues by bulk change

[Zheng, Liuyuan]

If I want to link multiple issues to multiple Storys, how to operate by bulk change?

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Zheng, Liuyuan

welcome to the community!

If you'd prefer a more interactive solution, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including your issues' issue links - much like you’d do in e.g. Excel or Google Sheets.

It also supports inline bulk editing via copy/paste, like so:

This works within JXL, but also across JXL and pretty much any other app (like e.g. Excel or Google Sheets), and can update any number of issues in one action - so whatever bulk linking you want to do, you should be done with your work in no time.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Manoj Kumar Gangwar]

Hi @Zheng, Liuyuan Welcome to the Community!

Your CSV file should include at least these columns:

Summary	Issue Type	Issue Key	Linked Issues	Link Type
Task A	Task	TASK-1	STORY-1	Relates to
Task B	Task	TASK-2	STORY-1	Relates to
Task C	Task	TASK-3	STORY-2	Blocks

Important Notes:

1. "Issue Key": This is required if you’re updating existing issues (rather than creating new ones).

2. "Linked Issues": This should contain the Story issue key(s) you want to link to.

3. "Link Type": Use valid Jira link types.

If linking multiple stories to one issue, separate them with a semicolon (;):
STORY-1; STORY-2