Scrape data from a website and save it to a CSV file.

Name: Preethi J

Reg no: 212223220080

Aim:

To extract structured data (such as a table or list) from a website using UiPath Data Scraping/Extract Table Data activity and save the extracted data into a CSV file automatically.

Procedure:

• Step 1: Create a New Project

  • Open UiPath Studio.
  • Click Process → New Process.

• Step 2: Open the Target Website

  • Drag a Use Application/Browser (Modern) or Open Browser (Classic) activity into the Main sequence.
  • In the URL field, type the website link to scrape (e.g. https://quotes.toscrape.com/).
  • Choose the preferred browser (Chrome/Edge).

• Step 3: Use Data Scraping / Extract Table Data

  • In the ribbon, click Data Scraping (Classic) or use Extract Table Data activity (Modern).
  • Indicate the first and second elements of the data you want to extract (for example, two quotes or table rows).
  • UiPath automatically identifies the pattern and creates columns.
  • If the site has multiple pages, click Yes when asked “Do you want to extract data from multiple pages?” and indicate the Next button.
  • Finish the wizard — it creates an Extract Data Table activity and stores data in a variable like ExtractDataTable.

• Step 4: Store Data in a Variable

  • Rename the output variable to: dt_scrapedData (Type: DataTable)

• Step 5: Save the Data to CSV

  • Drag a Write Range Workbook activity below the extraction step.
  • This will save all the scraped data into a CSV file.

• Step 7: Run the Workflow

  • Click Run to execute the process.
  • UiPath will open the website, extract the table or list data, and save it as a CSV file automatically.

Output:

Extracted CSV file

Result:

The automation successfully extracted tabular data from the website and stored it in a CSV file