Read Excel File in Alteryx

This section explains how to read data from excel files into the Alteryx designer with an example. First, we created a new workflow and renamed it as reading Excel data in Alteryx.

Read Excel File in Alteryx 1

How to read Excel Files in Alteryx

Drag and drop the Input Data Tool into the Designer window. Next, click on the down arrow button to connect to an Excel File.

Read Excel File in Alteryx 2

It opens the following window, and by default, it selects the Recent Tab. If you have any recent connections, it displays them. As we don’t have any recent connections, it shows empty. Please select the Files tab.

Read Excel File in Alteryx 3

From the following screenshot, you can see the list of all supported file types. In this Alteryx example, we want to read data from excel files. So, please click on the Select File button.

Read Excel File in Alteryx 4

For this Alteryx demo, we have chosen the Cust_wTransactions.xls Excel file.

Read Excel File in Alteryx 5

Select Excel Input: Here, you can select the Excel sheet, cells, rows, and columns. We have chosen the only available sheet output.

Read Excel File in Alteryx 6

You can see the Excel file information and the preview of the first 100 records on the left side configuration pane.

Read Excel File in Alteryx 7

By only hitting the Run button will show you the data inside this excel file. However, we used the Alteryx Browse tool (the standard way). So, drag and drop Browse tool to designer.

Read Excel File in Alteryx 8

Next, connect the Excel Input Data tool to Browse and click the Run button.

Read Excel File in Alteryx 9

From the below image, you can see all the records in that excel file.

Read Excel File in Alteryx 10

If you click on the Metadata tab, you can see the column information such as Name, Data type, size, and source name.

Read Excel File in Alteryx 11