UiPath Data Scraping (Web Page to Excel) - Tutorial

In this tutorial, you will learn how to use Data Scraping in UiPath to scrape data from a website, place it in a Data Table and present it in Microsoft Excel afterward. You will see two practical examples where the last one will have problems with the ‘Next Link Selector’. Here we will solve the problem by creating a dynamic selector and a simple While Loop. You could also watch: 🔵 Data Scraping Beginners Guide - https://youtu.be/kOPfG44-CBw 🔵 UiPath Beginners Tutorial - https://youtu.be/3ZKzTHdpsTs 🔵 Try Open Source Data Scraping with OpenRPA - https://youtu.be/sUQL2-rFOfw 🔵 UiPath Data Scrape from Amazon to Excel - https://youtu.be/96ZfYM3z28w 00:00 Intro 00:30 Data Scraping case #1 - Strava The first use case scrapes data from Strava, a social network for running and cycling tracking. 02:35 UiPath Data Scraping We are using the build-in Data Scraping guide in UiPath. By selecting two elements in the structured data, UiPath recognizes the entire data set, including that the data spans multiple pages (the Data Scraping will automatically click the next page). 03:30 Renaming Data Table To operate within the best practices for UiPath, we are renaming the Data Table to camel format. 03:55 Export data to Excel With a Write Range, we are exporting the scraped data to an Excel sheet. 06:30 Data Scraping case #2 - 'Smiley-ordning' Scraping the data from the Food Control (applied by the Danish Government) web page. Again, we indicate that our data is spanning multiple pages and renaming the data table to fit the UiPath best practice standard. 08:32 Write out the scraped data to Excel 10:15 Fixing the Problem - creating a dynamic selector To do Data Scraping that can target multiple pages, when the build-in wizard fails, we create a dynamic selector. 13:36 Element Exist We are asking if the "Next Page" button exists. 14:18 Creating a While Loop to scrape the Data If yes, then click it and scrape the data. 18:34 Bingo 😄 FOLLOW ME: 💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg 🐦 Twitter: https://twitter.com/andersjensenorg 📸 Instagram: https://www.instagram.com/andersjensenorg 👨 Facebook: https://www.facebook.com/andersjensenorg 👨‍👩‍👧‍👦 Discord: https://discord.gg/d8KQpTUvFD 💌 Email Newsletter: https://andersjensen.org/email-newsletter 📂Get the files from the video https://1drv.ms/u/s!Al9RjoWZcShJiNouBDw52U-0kuoSIg?e=3SVUgf #uipath #webscraping #datascraping