# 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.

Table format types

| Type | Description |
| --- | --- |
| txt | In a delimited text file<br>the columns in the table are separated by a delimiter character.<br><br>[Delimiter is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/delimiter.htm) |
| fix | In a fixed record file, each field<br>is exactly a certain number of characters.<br><br>Typically, many fixed record<br>length files contains records separated by a linefeed, but there are more advanced options to specify record size in bytes or to span over more than one line with Record is.<br><br>[Record is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/record-is.htm)<br><br>Information noteIf the data contains multi-byte characters, field breaks can become misaligned as the format is based on a fixed length in bytes. |
| dif | In a .dif<br>file, (Data Interchange Format) a special format for defining the table<br>is used. |
| biff | Qlik Sense can also interpret data in standard Excel files by means<br>of the biff format (Binary Interchange<br>File Format). |
| ooxml | Excel 2007 and later versions use the ooxml .xslx format.<br><br>The Table is specifier can be used to define the sheet name to be loaded as a table.<br><br>[Table is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-is.htm) |
| 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.<br><br>The Table is specifier can be used to define the path of the XML to be loaded as a table.<br><br>[Table is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-is.htm) |
| qvd | The format qvd is<br>the proprietary QVD files format,<br>exported from a Qlik Sense app. |
| qvx | qvx is a file/stream format for high performance output to Qlik Sense. |
| parquet | Apache Parquet is a columnar storage format, highly efficient for storing and querying large datasets.<br><br>With Parquet files containing nested data, you can specify the table from the Parquet file to load using Table is specifier. For example:`  LOAD * FROM [lib://DataFiles/company.parquet] (parquet, table is [company:salesrep.salesrep]); `.<br><br>[Table is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-is.htm)<br><br><br>For more information on loading nested data in Parquet files, see [Loading data from nested Parquet files](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-parquet-files.htm#Loading). |
| json | JSON (JavaScript Object Notation) is a language-independent data format.<br><br>If the JSON contains multiple arrays, the Table is specifier can be used to define the path to the iterator for the subtable.<br><br>[Table is](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-is.htm) |

## Learn more

* [Load](https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Load.htm)