Import

Mike

AIRT ADD-IN IMPORT FOLDER TOOL

Easily consolidate data from many files based on the filters you set

IMPORT ALL FILES IN A FOLDER

Import Folder AIRT add-in

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

Consolidation Range ExampleIMPORT FOLDER DIALOG BOX

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.

Works with any version of Windows with installed Excel 2010 or later. [Mac, mobile and online versions not supported]