# FileDataFormat

### FileType

Recognized file formats are:

* *CSV* for Delimited
* *FIX* for Fixed Record
* *DIF* for Data Interchange Format
* *EXCEL\_BIFF* for Microsoft Excel (XLS)
* *EXCEL\_OOXML* for Microsoft Excel (XLSX)
* *HTML* for HTML
* *QVD* for QVD file
* *XML* for XML
* *QVX* for QVX file
* *JSON* for JSON format
* *KML* for KML file
* *PARQUET* for PARQUET file

## Properties

| Name | Description | Type |
| --- | --- | --- |
| qType | Type of the file.<br><br>One of:<br><br><ul><li>CSV or FILE_TYPE_CSV</li><li>FIX or FILE_TYPE_FIX</li><li>DIF or FILE_TYPE_DIF</li><li>EXCEL_BIFF or FILE_TYPE_EXCEL_BIFF</li><li>EXCEL_OOXML or FILE_TYPE_EXCEL_OOXML</li><li>HTML or FILE_TYPE_HTML</li><li>QVD or FILE_TYPE_QVD</li><li>XML or FILE_TYPE_XML</li><li>QVX or FILE_TYPE_QVX</li><li>JSON or FILE_TYPE_JSON</li><li>KML or FILE_TYPE_KML</li><li>PARQUET or FILE_TYPE_PARQUET</li></ul> | String |
| qLabel | One of:<br><br><ul><li>Embedded labels (field names are present in the file)</li><li>No labels</li><li>Explicit labels (for DIFfiles)</li></ul> | String |
| qQuote | One of:<br><br><ul><li>None (no quotes)</li><li>MSQ (Modern Style Quoting)</li><li>Standard (quotes " " or ' ' can be used, but only if they are the first and last non blank characters of a field value)</li></ul><br><br>This property is used for delimited files. | String |
| qComment | String that marks the beginning of the comment line.<br>Example: “#” or “//”<br>The engine ignores the commented lines during the data load.<br>This property is only used for delimited files. | String |
| qDelimiter |  | [DelimiterInfo](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/EngineJSONAPI/Content/models-delimiterinfo.htm) |
| qCodePage | Character set used in the file. | Integer |
| qHeaderSize | Size of the header.<br>Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names. | Integer |
| qRecordSize | Record length.<br>Each record (row of data) contains a number of columns with a fixed field size.<br>This property is used for fixed record data files. | Integer |
| qTabSize | Number of spaces that one tab character represents in the table file.<br>This property is used for fixed record data files. | Integer |
| qIgnoreEOF | Is set to true, the end-of-file character is not taken into account during reload.<br>This property is used for delimited files and fixed record data files. | Boolean |
| qFixedWidthDelimiters | Positions of the field breaks in the table.<br>This property is used for fixed record data files. | String |