AIRT ADD-IN IMPORT FOLDER TOOL
Easily consolidate data from many files based on the filters you set
IMPORT ALL FILES IN A FOLDER
This feature lets you import data from all files in a folder. You can filter on the following to ensure you only get the data you want:
♦ File types (Excel files types or CSVs)
♦ File names (with wildcards)
♦ Sheet name (with wildcards)
♦ Range of cells (variable bottom of range)
IDENTIFY THE RANGE FROM EACH SHEET
First select the folder, file types, file names and sheet names.
Then go ahead and select the data range.
The AIRT add-in will find the bottom of your range based on the the column you choose.
Decide if you want to include headings from the first file.
Check out other AIRT add-in features. All FREE.
Works with any version of Windows with installed Excel 2010 or later. [Mac, mobile and online versions not supported]