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

Question

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?

Jerry Yen_rdo47p · Answer

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

Jira Cloud for Sheets - Google Workspace Marketplace

Jerry Yen_rdo47p · Answer

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

Aron Gombas _Midori_ · Answer

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.)