How to change download settings
You cannot change the format of the downloaded file - it is only possible to export the data as a CSV.
You can change the column separator under Options > Browser tab
Whenever you download data and it is all truncated in Excel, try changing column separator to change how the data is displayed on Excel.