Multiple Workbooks

Input: Multiple Excel files with a single sheet of data.

Download sample input file here

Download all sample workbooks here

Goal: Setup a DataFromExcel formula that collates the data from all the workbooks and puts it in one single place.


  1. Get the file list using GetAllFiles
  2. Setup the import via the UI for DataFromExcel on a single file.
  3. Modify the formula to link to all files via RegionDown.SK