Loading data from files
Qlik Cloud Analytics and Qlik Sense can read data from a variety of file formats.
File formats
There are several supported data file formats:
-
Text files: Data in fields must be separated by delimiters such as commas, tabs, or semicolons. For example: comma-separated variable (CSV) files.
- HTML tables
-
Excel files
Information noteYou cannot load data from password-protected Excel files, or Excel Binary Workbook files (.xlsb).For more information, see Loading data from Microsoft Excel spreadsheets.
-
XML files
-
Qlik native QVD and QVX files
For more information, see Working with QVD files.
-
Apache Parquet files
For more information, see Working with Apache Parquet files.
-
JSON files
For more information, see Working with JSON files
- Fixed record length files
-
Data Interchange Format (DIF) files: DIF files can only be loaded with the data load editor.
-
Geographic data files:
-
GEOJSON
-
ESRIJSON
-
GML
-
KML
-
SHPZIP
-
DXF
-
-
QlikView script files (QVS)
DataFiles connections are automatically created for each space you can access. For example, under Data Connections you might see:
- DataFiles: connection to your personal space.
- DataFiles (Marketing team): connection to a shared space.
You can also load and store files from shared space folders if you have edit permission. For more information, see Adding data from uploaded data files.
How do I load data from files?
There are several ways to load data from files.
Adding data from the data catalog
You can load data from datasets to which you have access using the data catalog. You can load data from multiple datasets.
Under Add data, click Add from data catalog.
For more information, see Loading data from the data catalog.
Selecting data from a data connection in the data load editor
You can go to Data Connections, and use the Select data dialog to select data to load.
For more information, see Selecting data in load scripts.
Loading data from a file by writing script code
Files are loaded using a LOAD statement in the script. LOAD statements can include the full set of script expressions. To read in data from another Qlik Sense app, you can use a Binary statement.
For more information, see Load.