Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
The default maximum number of rows and columns in the Excel export file is:
1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.
The default maximum number of cells in the export file is:
1000000 to export to an Excel file
5000000 to export to a CSV file
Qlik Sense September 2019
Please reference the Qlik help website to find the export to excel limitations for Qlik Sense version that you are using.
The maximum amount of data in Excel export file is:
Starting with the June 2018 version of Qlik Sense, the limitations for exporting to excel are listed in one place: in the Qlik Engine API documentation, which can be found in the Sense Developers area of the Qlik Help website.
The information can be found in the ExportData method page for each Qlik Sense release.
Example: Qlik Sense on Windows > September 2019 > Collaborate > Exporting and printing > Exporting data from visualization > ExportData method.
NOTE: the user may end up to errors like the following ones without passing the above limits! This could occur due to the default size limit described in API version 3.2 ExportData method page, which is 1024*1024*800 for an export to an Excel file (If the exported file is larger than the maximum value, then an out of memory error with code 13000 is returned):
It's not so much that the XLSX file has a limitation of 1024*1024*800 bytes (always important to put units on numbers). It's that an XLSX file consists of many different text files in a .zip file. Each individual (text/xml) file in there has a limitation of 1024*1024*800 bytes. For example, every sheet has an individual file, if they get over the limit the error happens. But the data in a Sheet is compressed by referencing commonly occurring cells in another file so it's not possible to calculate this size by just looking at data in the current sheet. From the user point of view the 1024*1024*800 number is likely meaningless; usually a part of the XLSX file was too large during export (likely the contents of a sheet).
Review the documentation for the Qlik Sense version in use to determine the documented excel export limitations. If you get a warning or an error about limitations, make selections to limit the data you want to export and then export again.
If you believe you are facing a situation which does not agree with the documented limitations, you can use the search on the support portal to see if the issue has an existing solution. Currently this search includes the Knowledge Base, the Qlik Community, product documentation (Qlik Help) and the Qlik YouTube videos. Based on your entitlement you can also contact Qlik Support. Additionally, you can post about the situation on the Qlik Community.
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.