Not seeing the option to download to csv anymore (upward arrow)

[Nathelena Wesley]

All of a sudden, I don't see the option to download to csv anymore (upward arrow), how can I get it back. Is there another way to download to excel or csv specific work items

[Paul Glantschnig _Appfire_ · Accepted solution]

Hi @Nathelena Wesley,

You're not the only one running into this. Jira has been rolling out UI changes that affect where (and whether) export options appear.

As @Trudy Claspill asked, the answer depends on which view you were exporting from. Here are the current options:

If you were exporting from Work item search (advanced search at /issues/): The old upward-arrow icon and CSV export link may have been replaced. Look for an Apps dropdown in the top bar of the search results. Options like "Open in Google Sheets" or "Open in Microsoft Excel" may appear there. Alternatively, check the ⋯ (three-dot menu) for a "Bulk change" or export option.

If you were exporting from a project's List view or All Work tab: The classic CSV export isn't available here. You'd need to copy your filter's JQL, navigate to the global Work item search (/issues/), and try the options above.

Manual fallback using the REST API: If the UI options aren't working, you can export via the search REST API. Jira exposes the search results at: https://your-site.atlassian.net/rest/api/3/search?jql=YOUR_JQL&maxResults=100

This returns JSON, which tools like Excel's Power Query or a quick script can convert to a spreadsheet. It's not the most convenient, but it's reliable.

Hope that helps track down the option!

Best, Paul

[Paul Glantschnig _Appfire_]

On that note, if you're open to solutions from the Atlassian Marketplace, JXL includes a straightforward export to Excel, CSV, or TSV. You choose your columns, apply any filters you need, and export what you see. It doesn't depend on the native Jira export UI, so it keeps working regardless of what Atlassian changes.

Disclosure: I work for the team that builds JXL.

Cheers, Paul

[Nathelena Wesley]

Hi Paul,

This is what I needed :). I used options 1 and 2 from your response and it gave me what I needed. I copied the JQL and used the three dots menu to download easily.

I tried the REST API and got the below error. May be a permissions thing

{"errorMessages":["The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at https://developer.atlassian.com/changelog/#CHANGE-2046"],"errors":{}}

Also tried JXL but may be its something the Company needs to adopt? In any case, I have what I need to do my daily work. I appreciate your responses very much. Thank you!

Regards,

Nathelena

[Trudy Claspill · Accepted solution]

Hello @Nathelena Wesley 

Can you provide a screen image of where you used to see that option?

From what view are you trying to access the option? Are you looking at the details of a single work item? Are you looking at the results of a search?

[Nathelena Wesley]

Hi Trudy,

Hopefully you can see the screenshot below. This is where I would go to simply choose my filters and be able to download from the All work space.  Thanks for the prompt reply

[David Nickell]

How crazy --- when Atlassian changed pagination logic for work items, many people found themselves with non-working excel extract logic.   So I hastily published an update to an Excel Extract I've had for years . (Free)

Just last night - I removed the link from my website. 

Today - I see your post (and a couple of others) so I have once again made the Excel Extract available.    There are a few related YouTube videos... but if you invest 15 minutes setting up your API token and run this "the first time" to work out any permission issues, you will forever be in control of your extracts :-).

I will try to clean up the instructions and maybe record a better video -- but do let me know if this is something you thnk you will be using.   

Thanks

https://splitdimedata.com/excel-extract

(Go to the bottom of the page and use the download link.  VII includes projects and Custom Fields).