I just received this question, have no idea and was hoping someone might be able to help.
There is a button for Export that allows you to export the Jira audit log to csv. Unfortunately when testing this, the export runs, but ability to open the file is blocked. The export to CSV in a filter view runs just fine, so it’s as if there is something else embedded in the audit log csv that limits it from opening (trust center issue).
Is there a way to change the export type of the audit log to Excel?
Does anyone know of a workaround?
We resolved this by discovering this is happening because the first two characters match the first two characters of the SYLK file format which is ID.
To fix this, open the file in Notepad and modify ID to be anything else. The easiest way is to add another character. Save and close Notepad. Then it should open in Excel correctly.
Thank you for reaching out to Atlassian Community!
The CSV type should work with Excel or Google Sheets.
Can you please open the file directly on Excel menu instead of clicking on the file to open?
If possible, send us a screenshot of the error that you see when trying to open the file.
Did you know Atlassian Access offers more than SAML single sign-on for Atlassian cloud products, like Jira and Confluence? Whether you're just starting to plan for your organization or in the pr...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events