Exporting Reports to Excel Results in Extra Columns
Export file to Excel table (xml) format.
Open file within Excel.
Press Ctrl-A to copy all within the worksheet.
Paste all within Notepad. (Start > Programs > Accessories > Notepad.) This step brings the data into Notepad, and because Notepad is a scaled-down version of MS Word, it removes the majority of the excess formatting (extra columns) within Excel.
Press Ctrl-A to copy all within Notepad.
Paste into a new Worksheet within Excel. Once the data are pasted back into Excel, the data will be easier to work with, with only a few extra columns and column headings that can be deleted.