How to Use Data Tables
Introduction
With Tables by Browse AI, you no longer have to rely on external applications like Google Sheets, Excel, or Airtable to view your extracted data. If you want quick and easy access to your robot's data, you can now view it in a familiar table structure, directly within your Browse AI dashboard.
The Main Tab
The Main tab of your Table will show one row per run of your robot and include the following information:
- Last Run
- Origin URL
- [List Name] Limit
- Status
- The number of items extracted per list
- Non-List Extracted Data (if applicable)
In the screenshot below you can see Last Run, the Origin URL, 3 columns with information about the extracted lists limit, the Status column
Example: Without Extracted Data
In this example, there is only information about the robot run itself.
Example: With Extracted Data
Here, notice the columns for Site Title, Site Description, and Who Built It.
Those columns come from this section of the website that was scraped:
Other Tab(s)
Each subsequent tab of your Table will contain the items from your list(s):
- Extract Date
- Origin URL
- [List Name] Limit
- One column per list item field extracted
Export
You can export a CSV or JSON of any tab in your Table. Exports will respect filters that have been added, as well. We will always indicate what’s being exported when you’re in the Export Data so you can confidently export the exact data you want.
The file will be available for download right there in your Table, and we will send you an email with a link to download as well.
Filter
In order to have control of the data you’re viewing in Tables, you’re able to filter your tab(s) by the following:
- Extract Date
- Origin URL
- Created By
- [List Name] Limit
- Bulk Run Name
Historical Data
When the same data is captured multiple times, the previously captured data are historical data that you can choose to hide if you only want to see the most recent version.
Any data that are captured using an identical set of input parameters are considered the same data at different points in time.
Notice in this example that checking the box changes the number of rows from 12 to 24. Since that's the exact same items captured twice, you can choose whether to show/hide the duplicates.
Resizing Columns
As the title suggests, when viewing the data in your Tables you can resize the columns. This is helpful if you want to see the entire contents of a column, but also if you want to reduce the width of columns that are less important/relevant (the Origin URL, for example).
NOTE: You can double-click into a column that has more data than can be displayed, in order to see the entire contents.
FAQs
Q. Can I manually add data to Tables?
A. The only way you can (currently) add data to a Table is to run your robot. There is no way to manually add rows as you would in a dedicated spreadsheet application.
Q. Can I hide columns?
A. Hiding columns is not currently possible, though we’ll be implementing more advanced viewing features in later iterations of Tables.
Q. Can I filter by column data (fields extracted by the robot)?
A. At this stage, it’s not possible to filter data by columns that you extracted with your robot. It’s on our roadmap to support this, but it’s not in V1 of Tables.
Q. Can I delete data from Tables?
A. Tables show data that your robots have extracted, and as such it’s not possible to modify the rows that appear there. Consider it a historical record of what was extracted. In the future, we may make it possible to add, remove, or update data.
Q. How do I add new tabs to a Table?
A. As it stands now, each tab (aside from the Main tab) in a Table corresponds to a list being extracted by your robot. There is no way to manually add a tab to your Table.
Q. How do I access Bulk Run from the Tables tab?
You can simply click on the Run Task, and then Bulk Run, and find yourself in the Bulk Run tab. However, we're working on features to make it easier for you to access the Bulk Run Tab.
Q. How do I initiate a Bulk Run Task directly from Tables
You can click "Import CSV"
Click on "Download Sample CSV Here"
Prepare your CSV for a Bulk Run as explained here
Click on "Click to Upload", so you can upload your CSV.
After successfully uploading the file, you can start the bulk run by clicking on "Start Extracting Data"