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!