Return to Blog

Automatic data extraction from public websites and government portals

Learn how to create visual scrapers that collect data from websites without an API, process the information and export it to spreadsheets or internal systems.

Government portals, public consultation sites, price tables, rankings and online directories — there is a huge amount of data accessible on the web that needs to be collected, organized and used. When there is no API available, visual data extraction with Dablio Robô is the most practical way to do this.

What is data extraction (web scraping) with RPA

Web scraping with RPA means using a robot that navigates the browser as a human would, identifies the data elements on the page — tables, fields, texts, links — and captures them for later use. Unlike code-based technical scrapers, Dablio Robô lets you do this visually by pointing to elements on the screen.

Step 1: identify the data selectors

Before creating the flow, access the target website and identify where the data you want to capture is located. Inspect the elements with the browser's DevTools (F12) and note the CSS selectors or label text nearby. The more stable the selector, the more reliable the automation.

Step 2: Create the extraction flow

In Dablio Robô, create a flow with the following actions: Open URL → Wait for loading → Capture element by selector → Store in variable → Repeat for other fields → Save row in spreadsheet → Go to next page (if there is pagination) → Repeat.

Extraction flow structure
Open portal URL or listing page
Wait for the page to load completely
Capture each data field per selector
Store values in flow variables
Write row to output sheet
Check for next page
Repeat until all records are exhausted

Step 3: Handle pagination and dynamic loading

Many portals display data on multiple pages or load content via JavaScript asynchronously. Configure Dablio Robô to wait for the presence of a specific element before capturing — this ensures that the data is already on the screen. For pagination, add a loop that clicks the 'Next' button and repeats the extraction.

Exporting the data

Dablio Robô can save the extracted data in an Excel spreadsheet, CSV file, database or send directly to an API. Configure the destination at the end of the flow. For large volumes, prefer CSV or bank — for human-ready reports, Excel is more practical.

All articles Request Demo
🤖 Next step

Ready to place
this in practice?

See Dablio Robô working with a personalized demo for your business.