The input data tool lets you bring data into your workflow by connecting to a file or database. This will most likely be the starting tool for your workflows. In this lesson, we're going to import an Excel sheet, which I've illustrated here on the right. The first picture shows us going to the in app tab and dragging in and input data tool into our workflow. The second picture shows us selecting our workbook and worksheet. And the third picture has us running out work for with the results outputted in the preview pane.

Let's start by going to the in app pane and dragging in an input data tool into our workflow. If we look at the configuration menu on the left, under connector, file or database, we have the option of selecting a file such as CSV, Excel, or zip, and several types of databases like Microsoft, Oracle, Hadoop, and many others. Let's open our Excel file by clicking on File And navigating to where our course files are and selecting 1.1 input data. A list of sheet names in the workbook will appear and we'll select example HR. As this is the only sheet in the workbook. You know notice when we import a file, our configuration pane gives us a preview of our data set up to 100 Records.

Press the run workflow button or Ctrl r on the keyboard. And the contents of our worksheet have been imported and can be viewed in the preview pane below.