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