using Jira Export file, I am facing the below error when i try to open the .xls file in Excel 365, Can you please provide me a workaround

"You are attempting to open a file type (Web pages and Excel 2003 XML Spreadsheets) that has been blocked by your File Block settings in the Trust center"

Tempo Plugin is able to offer xlsx - so it shouldn´t be rocket science?

We need it urgently too, because MS 365 isn´t able anymore to open this mysterious version of xls 

The following workaround can be used while waiting an official fix :

1) Rename the exported timesheet file to your desktop (call the file 't.xls')

2) Run this powershell script using powershell 7 (I haven't tested it elsewhere):
---------- Start of code ----------
$infile = Get-ChildItem -Path "C:\Users\$Env:UserName\Desktop" -Filter "t.xls"
$outfile = "C:\Users\$Env:UserName\Desktop\t-out.xlsx"
$Excel = New-Object -Com Excel.Application
$Excel.DisplayAlerts = $false
$Workbook = $Excel.Workbooks.Open($infile)
    if ($tabname)

$Workbook.SaveAs($outfile, 51)
$Workbook.Close()
$Excel.quit()
---------- End of code ----------

You can save this code to a .ps1 file and run it using pwsh .exe(=Power shell 7).

3) The 't-out.xlsx' file can be opened with excel 2019 without any error message (I hope it works with Office 365)

Remark: I'm not a developer but this code can be easily adapted to match with your environment or you needs.

WOW! Being able to export into a MODERN format should be possible by now. 

Another option Atlassian is lagging on.

Get with the times, Atlassian!

https://getsupport.atlassian.com/browse/PSSRV-69200

I understand that there are a lot of other ways how to export data to table but the excel format XLSX is still the most used format so it should be here as one of the possibilities.

Thanks