Skip to main content Skip to complementary content

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:

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.

Information noteThe file extension of DataFiles connections is case sensitive. For example: .qvd.

How do I load data from files?

There are several ways to load data from files.

Information noteUsers with edit permissions in a space can read, write, and load DataFiles in that space. Other users will not see the DataFiles.

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 Data Selection 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.

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!