Hi @r2d2
Instead of exporting issues you can try https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?hosting=cloud&tab=overview which is a free app and which allows you to get data from Jira without exporting them.
As you wrote Excel is the preferred format, then this app can create and email or save or attach a standard XLSX spreadsheet file from issue data and do that automatically:
It will connect to this other app which creates the Excel file from a template. So you can set up the headers or other details in the template, then it will be created in exactly how you wanted:
https://marketplace.atlassian.com/apps/1212652?tab=overview&hosting=server
(Discl. the first is free, the second is a paid app, both developed by our team.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You might want to look at this article that I wrote that shows how to connect a JQL Filter to an Excel Spreadsheet and refresh it automatically.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not an expert with automations, but it appears you can make a Scheduled Rule to run on a schedule to run your JQL Query and then export each row to a database or file somewhere.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use a JIRA filter to gather your open defects and then use the Export to export them to a CSV.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.