Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How can I export data model from qlik sense into csv or excel file???

Hi ,

I have an .qvf file with 200 tables in it . I would like to know if it is possible to export these tables into .csv or .xls  from QLIK SENSE ??

Can any one help me out with this??

5 Replies

You can export tables in the script to csv format using the STORE command. You can export the data from charts and tables in the front end to excel by right clicking the chart or table and select the Export option.

talk is cheap, supply exceeds demand
Specialist II
Specialist II

Hi Nupur,

This may help you:

From the link:

//Iterate through the loaded tables

For t = 0 to NoOfTables() - 1

//Iterate through the fields of table

For f = 1 to NoOfFields(TableName($(t)))


      Load TableName($(t)) as Table,

          TableNumber(TableName($(t))) as TableNo,

           NoOfRows(TableName($(t))) as TableRows,

           FieldName($(f),TableName($(t))) as Field,           FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo Autogenerate 1;

     Next f

Next t;

You can get all table name, and then you can store it in csv with store command.



If you have the rights to reload that application, put these line of code at the end of Data Script load:

For i = 1 to nooftables() - 1

    Let vTableName = tablename($(i));

    Store $(vTableName) into [lib://Your_Connection_Name/$(vTableName).csv](txt);


If you dont have the data source to reload that application, you have to create a new application, do "binary load" from that qvf file, then excute the codes above in the new application.

For binary load, check:

Correct Syntax for Binary load in Qlik Sense

Contributor III
Contributor III


Do you know how to limit this export/store only to First N rows ?

Contributor II
Contributor II


Could you tell me how load data model to qlike sense file?