The Scenario
It's the week before a database migration and someone on the platform team just asked you to produce a complete inventory of every Baserow database and table in the company workspace — names, IDs, the works — for the handoff doc.
You have access to Baserow. You have an Excel workbook open. You do not have a script, a saved export template, or any kind of automation that would make this go fast.
The bad version:
- Open Baserow, click into the first database, manually note its name and ID, then click into each of its tables one by one and copy the table name and table ID into the workbook
- Repeat for every remaining database — fourteen of them, forty-three tables total — keeping track in your head of where you left off
- Realize halfway through that you missed two tables in database three because you navigated away by accident and had to re-open it
A data engineer who has forty-three tables to document and a migration kickoff on Thursday does not have an afternoon to click through a UI and manually transcribe IDs. The margin for a copy-paste error in a handoff doc is exactly zero.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and talks to Baserow on your behalf — no export dialogs, no clicking through each database individually. You describe what you want and it pulls the structure.
Fetch all Baserow databases and their tables from my workspace and populate my Excel sheet with columns: database name, database ID, table name, table ID — one row per table
What You Get
- Column A: database name
- Column B: database ID
- Column C: table name
- Column D: table ID
- One row per table, paginated across the full workspace — no manual cutoff at the first 20 results
What If the Data Is Not Quite Ready
The worksheet already has a header row and some partial notes
My worksheet has headers in row 1 (Database Name, Database ID, Table Name, Table ID) and some partial notes in rows 2 through 8 — start writing the Baserow inventory from row 9, overwriting nothing above it
Some databases are test environments that shouldn't be in the inventory
List all Baserow databases and their tables, but skip any database whose name contains "test" or "dev" — write the filtered results to my worksheet starting at row 2
I need the table count per database, not one row per table
For each Baserow database in my workspace, write one row to my worksheet: database name in column A, database ID in column B, and the count of tables in that database in column C
Full cleanup + scoping + inventory in one shot
Fetch all Baserow databases and tables from my workspace. Skip any database whose name starts with "Archive" or "Test". Sort the results by database name alphabetically. Write database name, database ID, table name, and table ID to my worksheet starting at row 2, clearing any existing content in those columns first.
The pattern is to handle filtering, sorting, and placement in the same ask — not as separate steps after the data arrives.
Try It
Open an Excel workbook you'll use as your system inventory doc, then get the 7-day free trial of SheetXAI and ask it to list every Baserow database and table in your workspace. For form field auditing across those tables, see the form configuration audit spoke. For evaluating Baserow templates as a starting point, see the template catalog spoke. The full Baserow overview covers all four methods for connecting Baserow to Excel.