Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fosuzuki
Valued Contributor II

Export to Excel - limitation in number of rows

Hi all,

In Sense Desktop, I tried to export 2M rows in one single column, and it truncated to exactly 1M rows. When exporting two columns, it dropped to 500k rows. With three columns, 333.333 rows.


Can someone please confirm if it limits the export to 1M cells?

If so, is there any way to increase this limit?

Does Qlik Sense Server also has this limitation?

Regards,

Fernando

Tags (3)
1 Solution

Accepted Solutions
fosuzuki
Valued Contributor II

Re: Export to Excel - limitation in number of rows

Thanks Daniel.

I also opened a support case and got a confirmation that the Excel export limitation is to 1M cells, not rows.

My suggestion is to include this information in the documentation and also in the "Finished export" message window. Business users can get confused when exporting as the output is truncated at an apparently random limit.

9 Replies
Not applicable

Re: Export to Excel - limitation in number of rows

The ExcelFormat (xlsx) has some limitations see Excel specifications and limits - Excel

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards
Daniel Zanders
QlikSupport
fosuzuki
Valued Contributor II

Re: Export to Excel - limitation in number of rows

Hi Daniel, thank you for your response.

I'm sorry but I didn't find any useful information in the link you sent. Why didn't Sense export the limit of 1,048,576 in all three cases (with one, two and three columns)?

This is my test script:

load recno() AS Rec,

  'A' AS X,

     'B' AS Y

autogenerate(2000000);

Then, I created a table, added the columns and exported the data.

fosuzuki
Valued Contributor II

Re: Export to Excel - limitation in number of rows

Bumping up...

Not applicable

Re: Export to Excel - limitation in number of rows

Hi Fernando, we will check this with our Product Team to get an answer that explains this.

fosuzuki
Valued Contributor II

Re: Export to Excel - limitation in number of rows

Hi Daniel Zanders!

Any news on this? Sorry the insistence, but this was reported by a prospect, and I'd like to give him a proper answer.

Not applicable

Re: Export to Excel - limitation in number of rows

We got a Feedback and have to say that the Export Function is not designed for bigger amount of data. In this cases it is better to use the store function in the script or the API Functions.

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards
Daniel Zanders
QlikSupport
Not applicable

Re: Export to Excel - limitation in number of rows

Will this be the Qlik position going forward into the future. That exporting of data will always be limited to some defined limit. This is something we need to be aware of for our consumer/clients of the Qlik platform continuing forward.

fosuzuki
Valued Contributor II

Re: Export to Excel - limitation in number of rows

Thanks Daniel.

I also opened a support case and got a confirmation that the Excel export limitation is to 1M cells, not rows.

My suggestion is to include this information in the documentation and also in the "Finished export" message window. Business users can get confused when exporting as the output is truncated at an apparently random limit.

Employee
Employee

Re: Export to Excel - limitation in number of rows

This is no longer true. Please refer to the updated documentation in Qlik help. New limit is the limit imposed by excel-


i.e. 1048566 rows per sheet and 16384 columns per sheet.

Exporting data from a visualization ‒ Qlik Sense

Community Browser