Skip to main content Skip to complementary content

Table format

The table format is a file specifier for the LOAD statement that defines the file type. If nothing is specified, a .txt file is assumed.

txt In a delimited text file, .txt, the columns in the table are separated by some character.
fix In a fixed record length file, .fix, each column is exactly a certain number of characters wide.
dif In a .dif file, (Data Interchange Format) a special format for defining the table is used.
biff Qlik Sense can also interpret data in standard Excel files by means of the biff format (Binary Interchange File Format).
ooxml Excel 2007 and later versions use the ooxml .xslx format.
html If the table is part of an html page or file, html should be used.
xml xml (Extensible Markup Language) is a common markup language that is used to represent data structures in a textual format.
qvd The format qvd is the proprietary QVD files format, exported from a Qlik Sense app.
qvx qvx is a file/stream format for high performance output to Qlik Sense.

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!