How to Automate Data Scraping from Websites into Excel

September 4, 2019

In the video above, you’ll see an Automate bot running a task that enters UPS tracking numbers into the UPS website, performs automated data scraping to get delivery tracking information, and enters it into an Excel file. After the task runs, it goes on to show how that task was built. All but step 1 are shown in the video.

Step 1: Download an Automate trial

Step 2: Build the task by starting with variables. (If you need a basic primer on how to build Automate tasks, Automate Academy is a great place to learn.)

In this task, you’ll add variables for file names, rows, etc. Notice that this task builder is drag and drop, with no coding required!

Step 3: Open Excel workbook to get tracking numbers. You’ll store this as a dataset to use later on.

Step 4: Add a step to create a report workbook to write the dataset to.

Step 5: Use the report workbook with tracking numbers and column headings in a web browser activity.

Step 6: Identify which pieces of information you need. This will include telling the Automate bot where to find the data you want scraped. Put this on a loop to go through all the tracking numbers to do automated data scraping from the UPS website into Excel.

Step 7: For each piece of data you want scraped from the website, write the variable value to a cell in the workbook.

This is just one example of Excel automation. There are so many other ways Automate and Excel can work together to take manual work off your plate.

See RPA in action

Schedule a demo with one of our automation experts to see more ways to automate data scraping from websites into Excel

Stay up to date on what matters.