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; } } }

Content not exporting to Excel

unknown

I've created a filter and I'm trying to export it to Excel. The filter accurately shows which fields are populated. However, when I export it to Excel, some of the fields are blank for all issues, even though they're populated in the filter.

I've tried recreating the filter, and each time the issue occurs, but different fields are blank. I've even tried recreating the entire project and importing all the issues again.

Any suggestions?

Accepted answers

All comments

Ste Wright

Hi @[deleted]

It'd be good to get some extra details here. Could you clarify...

What steps you're taking to search, then export, the data
What types of fields are listed for export

A screenshot of both your search parameters, and the exported file, would be very useful here!

Ste

unknown

Thanks for the reply, @Ste Wright !

I'm creating a filter with the following fields/field types:

Key - Jira's Key field

Jira Identifier - Short text

Summary - Short Text

Status - Kanban category field

RFI Section - Short Text

Description - Paragraph

Additional Description - Paragraph

Current Response - Paragraph

Additional Current Response - Paragraph

Then, I'm using the "Open in Microsoft Excel" option to export, since that (typically) creates an Excel file that's a mirror of the filter, unlike the "Export Excel CSV" option.

Here's a screenshot of the filter results:

And here's a screenshot of the corresponding export to Excel:

You can see that the columns corresponding with the RFI Section, Additional Description, Current Response, and Additional Current Response fields are completely empty, though they're populated in the filter results.

Also, I'm unable to use any add-ons or plugins. I'll need to be able to use the native functions in Jira Software.

Ste Wright

Hi @[deleted]

The CSV export available via Export > Export Excel CSV (current fields), should also reflect the filter.

Can you try using this option and see if it it also has the fields as empty?

Ste

unknown

@Ste Wright

This is where it gets weirder - when I use that option, it does return values for all fields, BUT the fields that don't populate in the Excel export are duplicated 1, 2, 3, or 4 times in the CSV export (the number of times varies each time I try the export). The last duplication of that field is populated, and the others are blank (screenshots below).

Since this export will be ingested into another process, that makes that option unreliable. :-/

Excel 1.PNG

Excel 2.PNG

Aron Gombas

@[deleted]If everything else fails and you have to try an app, use the Better Excel Exporter app. It is developed by my team and it will just work with these columns.

Hex.Persephone

I have the same issue, the data is there in the field, the field is unlocked, the filter shows the data, but exporting to Excel does not pull out the data in a given field

the blank excel

jira field.png

the data in the filter view

jira field with data in filter.png

If I export ALL fields in a CSV, the field gets duplicated (???) one instance is totally blank like excel, second instance of field contains the data.

leadership doesn't like this though and wants a better way to export the data in the field as expected without using all fields to CSV

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

export

atl-orange