Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-12 06:21 PM

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.

592 Views
0 Likes
1 Reply
marcus_sommer
MVP
MVP
‎2018-04-15 09:18 AM

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

536 Views