Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Excel spreadsheet: import multiple sheets

davidmakovoz
7 - Meteor

I am importing an Excel spreadsheet. It has 8 sheets.

Each sheet has a header, and the headers are identical.

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

It shows <List of Sheet Names> in the 'Table or Query' name.

When I open my excel file, the middle option 'Select a named range' is grayed out. 

I can select one sheet ("Export Worksheet" is the name of the first sheet). 

Is there something I need to install to select multiple sheets?

Select input dialogSelect input dialog 

2 REPLIES 2
joshuaburkhow
ACE Emeritus
ACE Emeritus

What you need to do is select "Import Only sheet names..." then you attach that input tool to a "Dynamic Input" tool to actual read each sheet. I've attached an example workflow for you. 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
tomekz1283
5 - Atom

Does anyone have an idea as to how to select only the most recent sheet?  I have a workbook that updates daily with the new sheet name being the date it was created. How do I dynamically select the most recent date? 

 

Thanks 

Labels
Top Solution Authors