Jira Tools

How to use

Extract the selected tickets from Jira as CSV.
Copy the values to the "CSV" input and adjust the column names as needed.
Copy the CSV output. This will copy 3 tables: the first one being the data, the second is the matrix between sprint and ticket priorities, the third is the matrix between sprint and sections affected.

Input

CSV

Issue key,Issue id,Priority,Summary,Status,Custom field (Section / Feature),Custom field (Section / Feature),Custom field (Section / Feature),Custom field (Section / Feature),Sprint,Sprint,Custom field (Version or Sprint when issue is found),Custom field (Version or Sprint when issue is found),Custom field (Version or Sprint when issue is found)
XDD-844,229503,P3,Test Summary 1,To Do,Repository,,,,Backlog,,1.26,,
XDD-842,229382,P2,Test Summary 2,Done,Repository,,,,Test Sprint - 1.26,,1.26,,
XDD-841,229381,P2,Test Summary 3,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-840,229376,P2,Test Summary 4,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-839,229374,P2,Test Summary 5,REVIEW,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-837,229310,P2,Test Summary 6,Done,Pull Request,,,,Test Sprint - 1.26,,1.26,,
XDD-833,228926,P3,Test Summary 7,To Do,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-832,228925,P3,Test Summary 8,To Do,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-831,228915,P2,Test Summary 9,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-830,228896,P2,Test Summary 10,Done,Commit,Authentication,Repository,Pull Request,Test Sprint - 1.26,,1.26,,
XDD-829,228885,P3,Test Summary 11,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-828,228836,P2,Test Summary 12,Done,Commit,Authentication,Repository,Pull Request,Test Sprint - 1.26,,1.26,,
XDD-825,228329,P2,Test Summary 13,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-824,228206,P2,Test Summary 14,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-823,228205,P2,Test Summary 15,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-813,226532,P2,Test Summary 16,Done,Commit,,,,Test Sprint - 1.26,,1.26,,
XDD-811,226263,P2,Test Summary 17,Done,Commit,Repository,Pull Request,Users,Test Sprint - 1.25,,1.25,,
XDD-799,225879,P3,Test Summary 18,To Do,Authorization,,,,Backlog,,1.25,,
XDD-787,225080,P3,Test Summary 19,To Do,Authorization,,,,Backlog,,1.25,,
XDD-783,224572,P3,Test Summary 20,To Do,Authorization,,,,Backlog,,1.25,,
XDD-781,224495,P2,Test Summary 21,REVIEW,Authentication,,,,Test Sprint - 1.25,Test Sprint - 1.26,1.25,,
XDD-772,223123,P3,Test Summary 22,To Do,Authentication,,,,Backlog,,1.24,,
XDD-770,223119,P3,Test Summary 23,To Do,Users,,,,Backlog,,1.24,,
XDD-769,223115,P3,Test Summary 24,To Do,Users,,,,Backlog,,1.24,,
XDD-768,223113,P2,Test Summary 25,Done,Commit,,,,Test Sprint - 1.24,Test Sprint - 1.25,1.24,,
XDD-767,223103,P2,Test Summary 26,Done,Commit,,,,Test Sprint - 1.24,Test Sprint - 1.25,1.25,,
XDD-766,223101,P2,Test Summary 27,Done,Pull Request,,,,Test Sprint - 1.24,Test Sprint - 1.25,1.24,,
XDD-765,222979,P3,Test Summary 28,To Do,Repository,,,,Backlog,,1.24,,

Sprint column name

Section column name

Priority column name

Priority list

Jira Tools

How to use

Input

Output