nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Export Custom Fields to Excel

Hemanshu Sood_yi365e

Hi, is there any way to export custom fields along with their values to excel? Please suggest an addon(if any) for this

Accepted answers

Aron Gombas _Midori_

Better Excel Exporter supports all built-in system fields, all built-in custom fields and the majority of the popular 3rd party custom field types.

You can try free if this fits your use case.

e22d75cc-9165-493a-81b4-bd223e2a428c

All comments

Charly _DEISER_

Hi @Hemanshu Sood

You can check this app in the marketplace:

https://marketplace.atlassian.com/plugins/com.deiser.jira.exporter/server/overview

This app will give you a lot of different functionalities to export your data from jira.

Cheers

Andreas Meier_idnfj1

There are other export-AddOns too - we use

https://marketplace.atlassian.com/plugins/com.xpandit.plugins.jiraxporter/cloud/overview

and are very sattisfied

Gezim Shehu [Communardo]

I'm confused.

You can directly export the issues and have the custom field values embedded (as direct values only, not reference).

Though, if you wish, you can of course directly query in the database.

You only need to check 3 tables.

Nic Brough -Adaptavist-

Indeed. Run a filter for the issues you want to see the custom field values for, choose the right columns, export to CSV, and open the result in Excel. It's built in, you don't need add-ons or anything

Aron Gombas _Midori_

Better Excel Exporter supports all built-in system fields, all built-in custom fields and the majority of the popular 3rd party custom field types.

You can try free if this fits your use case.

e22d75cc-9165-493a-81b4-bd223e2a428c

Hemanshu Sood_yi365e

Hi Nic, the filter works fine, but while excel exporting, all the fields for all the issues along with issue details, default and custom fields get printed in the excel sheet. My requirement stands still: I want to export only custom fields(values and definition) being used in my Jira instance to an excel file. Please guide

Nic Brough -Adaptavist-

Same answer - choose the columns you want in the export and export it to CSV - you should have seen the "CSV (current fields)" right next to the "CSV (all fields)" option you've used before.

Gezim Shehu [Communardo]

Use the database.

You can either connect directly to it, or use a SQL addon.

If am not mistaken something like "SQL Driver for JIRA"

Nic Brough -Adaptavist-

No. Do not. The query required for even the most basic issue download is hideous and this way lies madness.

gil cooper

I do it all the time and have no problem at all

JD Lobue

Does this app allow a dump of all custom fields regardless of issueID? I'm not seeing a way to use this to pull all CustomFields that are in my instance.

AJJI

Is there any builty in option to extratct all the custem fields in my instance . if exist then please give a conclusion or this

Samantha Sales

Is there a way to export it without it saying "Custom field" in the spreadsheet? I am trying to export but it keeps listing as follows: Custom field (item name).