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.