You’ll want to export each report to .xls or .xlsx separately, and doing so will yield mixed results depending on the specific report. Those exported workbooks typically include multiple sheets! (important)
- see Export your content and data (Custom Reports section)
- see image
Export HubSpot Reports