Skip to main content Skip to complementary content
Qlik Resources

Loading data from files

Qlik Sense can read data from files in a variety of formats:

  • Text files, where data in fields is separated by delimiters such as commas, tabs or semicolons (comma-separated variable (CSV) files).
  • HTML tables.

  • Excel files (except password protected Excel files).

    See: Loading data from Microsoft Excel spreadsheets

  • XML files.
  • Qlik native QVD and QVX files.
  • Fixed record length files.
  • DIF files (Data Interchange Format). DIF files can only be loaded with the data load editor).

You can load files from different data connection types:

How can I load data from files?

There are several ways to load data from files.

  • Adding data with Add data, the quickest way to load data from a file. You can load from an existing data connection, or connect to a new data source on the fly.

    See: Adding data to the app

  • Selecting data from a data connection in the data load editor.

    Instead of typing the statements manually in the data load editor, you can use the Select data dialog to select data to load.

    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.

    See: Load

Folder data connection settings

You can load files from local and network file folders with a folder connection.

Setting Description
Path

Path to the folder containing the data files. You can either:

  • Select the folder

  • Type a valid local path

    Example: C:\data\MyData\

  • Type a UNC path

    Example: \\myserver\filedir\

Information noteIt is not possible to use a mapped network drive in the path.
Name Name of the data connection.

Web file data connection settings

You can load files from web resources, such as FTP, HTTP or HTTPS, with a web file data connection. The file can be of any type supported by Qlik Sense.

Setting Description
URL

Full URL to the web file you want to connect to, including the protocol identifier.

Example: http://unstats.un.org/unsd/demographic/products/socind/Dec.%202012/1a.xls

If you connect to an FTP file you may need to use special characters, for example : or @, in the user name and password part of the URL. In this case you need to replace special characters with a percent character and the ASCII hexadecimal code of the character. For example, you should replace : with '%3a', and @ with '%40'.
Name Name of the data connection.

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!

Leave your feedback here