how to read different sheets from different Excel files?

[ivoiculescu2020]

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 solution]

@ivoiculescu2020 Check this:

https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Exce...

[OTrieger · Accepted solution]

@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

[ivoiculescu2020]

@OTrieger @nagakavyasri 

thank you for your prompt replies. I do appreciate it!