Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export to excel - csv file is much larger than corresponding excel

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.

1 Reply
marcus_sommer

Probably you saved the excel as xlsx which is a compressed file-format respectively a zip-file and therefore your observation seems quite normal.

- Marcus