Multiple excel sheets

[sean-duncan]

Is it possible to import multiple excel sheets when importing a data input folder? I have an excel doc with multiple tabs and I need to pull specific statistics from a number of tabs but I can only seem to import one sheet at a time currently.

[Jean-Balteryx]

Hi @sean-duncan ,

Can you share your date files or a mock data similar to it ?

[DawnDuong · Accepted solution]

hi @sean-duncan 

have you checked out this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

This has covered scenarios such as multiple sheets from same files, multiple files, etc... 

Dawn.

[bensilv]

Hi @sean-duncan 

I have a workflow just for this!

It has the following examples:

• Wildcard input (same schema)
• Directory + dynamic input
• Directory + different schema macro
• Multiple sheets input
• Multiple tabs from different schema
• Multiple Tabs and Files

Ben

[sean-duncan]

Thanks all for your responses!

[samson211]

Hi @bensilv 

I am trying to use the third worflow where my files have different schema, but it is showing error

Error: Different Schema - XLSX (3): Record #2: Tool #1: No sheet specified, you must specify a sheet.

Can you guide please..