Read All Excel sheets

[nmccarthy82]

Hello, I am looking for the simplest way to read in all the excel sheets in a workbook. I am trying to keep this workflow as simple as possible because I am a beginner in Alteryx.

[bpatel · Accepted solution]

hi @nmccarthy82 ,

this community post might be helpful. it outlines the steps necessary to read in all excel sheets. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

hope this helps!

[fmvizcaino · Accepted solution]

Hi @nmccarthy82 ,

Attached is an example showing how to get that done the easiest way possible.

1. You need to use an input data tool to get all sheets

2. Use a formula to clean the file name and then concatenate with sheet name

3. Use a dynamic input to read all at once.

Let me know if that works for you.

Best,

Fernando V.

[DanielDRU]

Hi,

is it also possible to append the data column wise?

Regards

Daniel

[bpatel]

hi @DanielDRU,

before you output the data you can use a tool like the find and replace to match on a unique identifier and append any columns you need to that data. Hope this helps!