How to Input Data From Multiple Sheets in Alteryx

‍

It is very easy to input data from multiple sheets in Alteryx. Here’s a short tutorial on how to do it:

1. Inside Alteryx's workflow designer, head over to the left-side panel and find 'Input Data'. Drag this tool onto the canvas to make further configurations.
2. Following that, go to the right-hand panel and click 'Upload Data'.
3. Tap 'Choose File' and then select the XLSX file that contains the data you want to use.
4. Following that, click the 'Dataset Creation' menu and choose 'Selected Sheets'. If you want to use all the sheets in your XLSX file, set it to 'All Sheets' instead.
5. Subsequently, click the 'Select Sheets' menu and then choose all the sheets you want to use.
6. Once done, click 'Create Dataset'.
7. Finally, the data from the selected sheets will be entered into your Alteryx workflow.