I am working on a QlikView dashboard that is required to allow export of a big adhoc report. When user uses the 'Export to Excel' button on the window, it automatically exports it as a csv file (Since number of records are high). Surprisingly, the exported csv file is ~20MB, but when I open it and save it as Excel, it cuts it down to ~5MB. I had expected the csv file to be much smaller than corresponding Excel while am seeing exactly opposite Is this normal or am I setting any configuration, incorrectly.
