Reading a worksheet from multiple Excel files all at once

This is one of the most common situations you’ll find when working with files. Maybe it’s sales data, purchase orders, or any type of data—at the end, you’ll have a bunch of Excel files in a folder or subfolders and you’ll need to read, consolidate, and analyze them.

This recipe will help you with the case where those files are in the same folder (including its subfolders) and the files have the same structure (columns).

Even though the recipe was crafted using Excel files (because they present an extra complication, including different worksheets within), it can be adjusted and will work with any file format you need to deal with.

Getting ready

If you want to try this recipe before applying it to your own data, we have a test set here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch1/Recipe1. You’ll find a ZIP file with a directory structure and...