Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

load file excel

I would like to know the best solution to load excel files every month at once, each file contains the same fields, just the values ​​that change each month.
Thank you for your help.
Best regards


1 Reply
MVP & Luminary
MVP & Luminary

You can load all the excel files using a * as wildcard:


LOAD * FROM [D:\ExcelFiles\*.xlsx] (ooxml, embedded label, table is Sheet1);

Or you can use a loop: loop through to load all files from a folder and its subfolders?

talk is cheap, supply exceeds demand