Skip to main content
Close announcements banner
Loading data from files

ON THIS PAGE

Loading data from files

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
  • 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

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.

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 Select data in the data load editor.

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.