Multiple excel sheets

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.

Input

Accepted answers

DawnDuong

hi @sean-duncan

have you checked out this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

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

Dawn.

All comments

Jean-Balteryx

Hi @sean-duncan ,

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

DawnDuong

hi @sean-duncan

have you checked out this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

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

Input Methods.yxzp

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..

error.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703