How to export JIRA data field containing multiple entries into single row/cell in Excel?

[Jerry Yen]

Hello,

I'm trying to export data from JIRA to Excel.  One of the data fields contain multiple entries that are exported into multiple cells in Excel.  Example:

Impacted_Products

product_a

product_b

product_c

In example above, product_a, product_b, and product_c are exported in 3 separate rows under the impacted_products column.

How can I export the data into a single row or cell in Excel?  We've tried using 3rd party products like Looker and manually combining the data in Excel, which is not really ideal.

Is there a command in jql that would allow you to specify, under each change record, the data under specific field should be merged so it wouldn't output as multiple rows in Excel?

[Aron Gombas _Midori_]

You can't control the "structure" or  the "format" of the Excel output from JQL. JQL only selects the issues to export.

Instead, try to export the issues with Better Excel Exporter!

You haven't mentioned the field type of the "impacted_products" field, but for multi-value fields, this app typically exports the full value to the same cell. See the "Labels" or the "Components" field here:

In worst case, even if the output is not exactly matches your expecation, it is extremely customizable! You will be able to export multiple values to the same cell, multiple values to multiple rows, etc.

(Discl. it is a paid and supported app developed by our team. Free for 10 users.)

[Jerry Yen]

Sadly I don't think they support new sales to server (not cloud) installs now.  :(

[Sanjog Sigdel]

Hello @Jerry Yen

Welcome to the community.

If you use Export to Google Sheets or run a Jira() function in Google Sheets to retrieve the issues from a jira query, your filed with multiple information gets accommodated within a cell.

Please find the output which I get for my sub-tasks within a cell. A ticket can have multiple subtasks like your column has multiple impacted product names:

[Jerry Yen]

Is this option only avail for JIRA Cloud?  We're running server version of JIRA.

Jira Cloud for Sheets - Google Workspace Marketplace