Book demo
Start trial
Book demo
Start trial

The LEAP

Automation insights and productivity tips from LEAPWORK.

Go to Learning Center

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.

 
 
 
Video Thumbnail
Video Thumbnail
 
 
 
 
 
 
 
 
 
 
 
 
 

 

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.

 

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

Kasper Fehrend
Kasper Fehrend
Senior Product Evangelist at LEAPWORK.