how to read different sheets from different Excel files?

Question

Hello everyone,

I contact you because I need your help with the following issue:

I need to process several Excel files, each file has a different name and each file has spreadsheets with different names.

- How to read those files in one go? I can have between 5 and 10 files at a time

- How do I ask Alteryx not only to read the right sheets but also select specific columns from each sheet?

- Not all sheets have the same amount of columns or the same column titles

Many thanks in advance for your assistance!

Kind regards,

Ioana

nagakavyasri · Accepted Answer

@ivoiculescu2020 Check this:

https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range-into-a-Workflow-1583461464206#MultipleSheets

OTrieger · Accepted Answer

@ivoiculescu2020

There are several different things that you are asking for.

I like to build batch macros as then I have ability to build in it a full WF that will do the same to all the data that I want.

If all the files will be in a folder with directory tool you can get them all in, then send them to the first Batch Macro where you ask to open all the files with List of Sheet Names, then with formula tool you replace List of Sheet Names with the File name. Now you can filter which sheets you need and which not. Then sending it into the next batch macro that will open the files and extract the data. Inside this batch macro you can define with columns will be output, and whatever else you wish