1. Export the report with the format as Text
2. Open Excel
3. Open the exported file through File, Open
4. Click Finish on the Text Import Wizard when it opens.