Gradience Pro / Enterprise - Solution To: Exporting Reports to Excel Results in Extra Columns

Exporting Reports to Excel Results in Extra Columns

Workaround:

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.