Skip to main content

Loading data from files


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:

    Note: You 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.

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.

Note: The 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.

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

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.