Skip to main content

How to view, manage and export your scraped data

Tables are where you can manage robot runs and data including quick actions, bulk actions, and export options. For monitored data, tables become a live historical database of the data your robot has extracted.

M
Written by Melissa Shires

Tables are your operational command center for managing robot runs and your historical database.

From Tables you can:

To access Tables:

  1. Click on any approved robot in your dashboard.

  2. The robot opens on Tables. From any other tab, select Tables from the menu at the top.

💡 Every robot has its own Table so you can view historical runs, export your data, and set up bulk operations.

⏰ If your robot has a monitor, every time your robot captures new data it will automatically be added to Tables creating a live historical database of your extracted data. This is great for audit trails, analyzing historical trends, and more.

Viewing your data

Every Table includes a Main tab where you can trigger runs, bulk operations, and view status details.

The Main tab

The Main tab provides a summary of each time your robot has run. You will see:

  • Extract date - when the data was extracted

  • Status - status of the extraction (queued, in-progress, successful, or failed)

  • Extraction details including Origin URL, and/or input parameter(s)

Additional tabs

Some tables include additional tabs of data. This depends on the data you've scraped and how it's structured. You can navigate through the table to view your data and its structure.

💡 You can only view extracted text, links or HTML in tables. To view screenshots you need to click on the History tab.

Add a Filter

You can add a filter to view your data based on:

  • Input parameter(s), and/or Origin URL

  • Status

  • Extract date

  • Created by

  • Bulk run name

📖 Learn more on how to filter data in a Table.

Show or hide Historical Data

View the latest data your robot has extracted or view all historical data.

  • Show historical data off - see only the latest captures

  • Show historical data on (highlighted) - view the complete archive

📖 Learn more about working with historical data in Tables.

Show or hide columns

To hide a column, click ⋮ in its header and select Hide column. To show hidden columns again, click 1 hidden column (the count changes) above your Table and turn them back on.

📖 Learn more about how to change your visual layout in Tables.

Run and trigger automations in tables

Quick actions

From the Main tab you can:

  • Update Row - triggers the robot to 'run' and capture data. With Show historical data on, this button reads Re-extract.

  • View robot status details - hover over a row and click the View Task icon next to the status to open that run in History.

  • View data - click the item count (for example 10 Products) to open that run's data in its tab.

Add a row to scrape more data

Adding a row (click New Row) runs your robot to extract the same data based on a:

  • Origin URL - scrapes the same data on a different URL.

  • Input parameter - extracts the same data based on a different input parameter.

Import CSV to automatically extract data from many pages

You can add many rows at once (up to 500,000 rows in one bulk run) by uploading a CSV, this will automatically scrape or extract data based on a list of input parameters or Origin URLs.

Uploaded image

📖 Learn more about how to run bulk extractions in Tables.

Exporting data

You can export:

  • All of the data your robot has captured (all tabs).

  • Select data your robot has captured (single tab).

Exporting all data

You can export all of your data from the Main tab.

  1. Go to the Main tab.

  2. (Optional) Filter the data based on what you'd like to export.

  3. Click the Export button.

  4. In the Export panel, click Download next to Download CSV or Download JSON.

This will extract all of your data into a zipped file that contains one CSV for the Main tab and one CSV file per captured list.

💡 Exports will respect filters that have been added.

💡 If you only want to export the most up to date data, leave Show historical data unchecked, and then click Export.

Exporting a tab

You can export any tab in your Table as CSV or JSON format.

  1. Select the tab you want to export.

  2. (Optional) Filter the data based on what you'd like to export.

  3. Click the Export button above your Table. The panel confirms which tab is being exported.

  4. Click Download next to Download CSV or Download JSON.

The file will be available for immediate download, and you'll also receive an email with a download link.

Monitor robot performance

Tables show the status of every run, so you can see how your robot is performing.

Every extraction in your Table shows a status indicator:

  • Successful - data was extracted without issues.

  • Failed - the extraction encountered an error.

  • In-progress - The extraction is currently running.

  • Queued - the extraction is waiting to start.

💡 You can filter any table by status to quickly identify failed extractions.

Hover over a run and click the View Task icon next to its status to view detailed history for that specific run, including error messages and troubleshooting information.

Transform your data with formula columns

Add formula columns to transform your extracted data, this is useful for:

  • Cleaning messy data (remove spaces, extract numbers)

  • Creating categories (IF statements for grouping)

  • Performing calculations (add margins, compute totals)

To add one, click Add column and select Formula. Name the column, describe the formula you want and click Generate formula. AI writes the formula for you and shows a preview. Click Add column to save it.

📖 Learn how to create formula columns.

Did this answer your question?