Reports exported to Excel get additional formatting from the reporting tool.
Follow these steps to get around the additional formatting:
- Export to RTF (rich text format).
- Open the RTF document.
- Copy the table and paste it into a blank Excel file.
This copies the table without any complicated formatting that Excel might have added with just an export.