Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting All fields from all tables to excel spreadsheet or text file

Hi All,

I have a simple problem, where I'd like to export all the field names of all the tables that I have in my data model to an excel spreadsheet or a text file. It should also include all the derived fields as well. Could anyone please tell me if this is possible in Qlikview?

Thank you. I'd really apprecicate your reply.


5 Replies
Contributor III
Contributor III

Hi have you tried export structure in source table view? Convert File to text and it should help you out

Specialist III
Specialist III

You can create a System Table object which lists all the tables and their fields and export it to Excel.

Not applicable

Document Properties > Tables > Export Structure



Just have $Field as list box this will give you all the fields in your data model and right click select Send to Excel.

Contributor II
Contributor II

Your old anwer help me now.

Good soluce.