Jira Export Custom Fields to Excel

[Hemanshu Sood]

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

[Aron Gombas _Midori_ · Accepted solution]

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.

[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

[Hemanshu Sood]

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.

[Hemanshu Sood]

If we have more than 1000 custom fields, just want to export only certain kinds of fields(like picker kind of or date kind of), is it possible with this solution?

[Nic Brough -Adaptavist-]

Yes, although it's not done by type, you have to choose the columns you want to download.

[Hemanshu Sood]

Thank you Nic.

[Atlassian Learner]

Hi

may i now the exact filter u used to extract the custem fields in jira cloud

[Nic Brough -Adaptavist-]

Filters do not extract custom fields, they give you a list of issues that match a query.

For an "extract", you probably want to use "export" in the issue navigator, which can give you all the fields that it is currently displaying when it show your list of results.

[JGJUNK]

Follow up on comment above - "CSV (all fields)." 

This option does not appear my export drop down. I only see CSV (current fields). Why might that be?

[Atlassian Learner]

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

[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

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

[Andreas Meier]

Hi

There are other export-AddOns too - we use

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

and are very sattisfied

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

[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