Input multiple Excel sheets/tabs to one

How do you input multiple sheets/tabs (about 200) with identical columns and output this into one data sheet? I've read a few articles referring to this but it's only referring to if you're looking at including only a portion of those sheets, not all of them. What's the best way to do this?

Thanks!

Input

Output

Dynamic Processing

Accepted answers

AndréB

Hi @melissadata,

To answer your first response. You do not have to output the source of the data. If you click "edit" in the "Input Data Source Template" section of the "Dynamic Input" tool. Option 5 where it says Output File Name as Source, is where you can configure that. Just select the dropdown and choose "No".

To your second response. I'm able to duplicate your error message, but only when the schema in a tab within my spreadsheet isn't the same as the schema in the tab being referenced as the "input data source template"

Is your workflow bringing in any data at all from your spreadsheet? Maybe try removing the tab that is erroring out from your dataset as a test?

-AndréB

All comments

AndréB

Hi @melissadata,

This is a perfect scenario for dynamic input. I built out a basic workflow for you to reference.

Output the list of sheet names
use dynamic input to change the file/table name while using any tab from your spreadsheet as a source template

Let me know if that helps!

-AndréB

Dynamic Input-Melissadata.yxzp

melissadata

Hi Andre,

Thank you so much. For the dynamic input it says to "use a template worksheet to specify the schema (shape) of the tables, etc..." I just want to copy all of the columns from each tab in the one spreadsheet and then output it to one spreadsheet. I don't even need to reference which tab they came from, just need the data on one tab. Could I skip that next step? Would that be possible?

Thanks again!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703