Salesforce Report Exports

If your report has less than 100 000 records then change the Export View Details Only export option to .xlsx. This will save the report in the latest Excel version and the size of the report will be far less than the default Details Only export option which is .xls.

The added advantage is that the Excel file will be named the same as the Salesforce report name and will include the export time stamp. This naming convention is the same as is used when the Formatted Report option is used.

Image showing the Salesforce Report Export dialog box