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

Specified file types

| File type | Description |
| --- | --- |
| txt | In a delimited text file<br>the columns in the table are separated by a delimiter character.<br><br>[Delimiter](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/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/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/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 | QlikView 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. |
| 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<br>the proprietary QVD files format,<br>exported from a QlikView document. |
| qvx | qvx is a file/stream format for high performance output to QlikView. |

## Learn more

* [Load](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Load.htm)
* [QVD files](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/QVD_files.htm)