Drive Automation with Excel Data

This tutorial covers how to use Excel as a data source to drive an automation flow. It's part of our series about data-driven automation with Leapwork.

Separating data from functionality when automating processes is a great help. Especially if the functionality can be used with different data sets, like automating software tests using different inputs or running business processes with different data every day, then the input data needs to be separated from the functionality.

In other words, it's not best practice to hard-code data into flows if the data changes frequently. The preferred alternative is to use external data sources, such as an Excel spreadsheet. 

The Read Excel block in Leapwork provides access to columns and rows inside an Excel sheet and makes it very easy to use data from the sheet directly in automation flows.

 

 

 

 

 

 

 

 

 

 

 

 

 

10:36

 

 

 

 

 

 

 

 

 

 

 

The Read Excel block works for practically any automation scenario relying on data input from an Excel sheet. In some cases, you might need to do a lookup in an Excel sheet or write data back into Excel. The easiest way to do this is to access the spreadsheet as a database using the Database block. This is covered in the second tutorial of this series on database automation.

Go back to our overview of Leapwork tutorials for
data-driven automation.