# Sheets: A Spreadsheet That Works as a Shared Data Source

> Start from a query result, a workbook or a blank sheet and work together with familiar formulas. Then use your tables in AI Analyst, agents, automations and datasites.

HTML version: https://supaboard.ai/product/sheets

A spreadsheet that works as a shared data source.

Start with a query result, import a workbook or create a blank sheet. Work together with familiar formulas, then use your tables in AI analysis, automations and datasites.

## From spreadsheet analysis to shared data

One sheet, followed from the first rows to the tools that read it.

### Pick up where the query left off

Choose “Save as booklet” to save a table from Query Bench, a dashboard or a conversation as a sheet, import a workbook, or start a blank one. Saved results are snapshots. You can edit the sheet, but changes in the original source won’t update it automatically.

Starts from: [Query Bench](https://supaboard.ai/product/query-builder), [Dashboards](https://supaboard.ai/product/dashboards), [AI Analyst](https://supaboard.ai/product/ask-analysts).

### The formulas you already know

Add the change column, total it, look a value up: 515 functions, from SUMIFS and XLOOKUP to QUERY and SPARKLINE. Edit together and see each other’s changes as they happen.

- Import xlsx, xlsm, CSV or TSV; export xlsx, CSV or TSV
- One shared version, with 30 days of history

### A data source the rest of Supaboard can use

A sheet works like any connected source. Ask AI Analyst about it, give your agents access, or build a datasite on it, and they read the rows on your sheet.

Used by: [AI Analyst](https://supaboard.ai/product/ask-analysts), [Agents](https://supaboard.ai/product/agents), [Datasites](https://supaboard.ai/product/datasites).

### Keep a workflow moving as rows change

When a new row is added, email the right team and log it in another sheet. Automations can also find, add, update or delete rows.

- Triggers: Booklet changed, New row in a Databook view
- Actions: Add, Update, Delete and Find booklet rows

Runs in: [Automations](https://supaboard.ai/product/automations).

## Where your sheet goes

Use the same shared tables across your analysis and workflows.

[Query Bench](https://supaboard.ai/product/query-builder) results go into [Sheets](https://supaboard.ai/product/sheets) with "Save as booklet".

- [AI Analyst](https://supaboard.ai/product/ask-analysts): Ask about a sheet, like “Which plan grew fastest from August to September?”, and get the answer from its rows.
- [Agents](https://supaboard.ai/product/agents): Give an agent access and it works from the rows you checked.
- [Automations](https://supaboard.ai/product/automations): Start a workflow when a row is added or a sheet is edited, and let it add, update or find rows as it runs.
- [Datasites](https://supaboard.ai/product/datasites): Use a query or a sheet as the data behind a datasite, and share it with a public link.

## Sheets, in detail

| Feature | Detail |
| --- | --- |
| **Functions** | 515, including SUMIFS, XLOOKUP, QUERY and SPARKLINE. Functions that fetch from the internet return #N/A. |
| **Import** | xlsx, xlsm, CSV or TSV, up to 100 MB. Macros are never run. |
| **Export** | xlsx, CSV or TSV |
| **Size** | Up to 1,000 columns |
| **Storage** | Each tab is a Postgres table in your workspace |
| **Sharing** | Private until you share it, with viewer and editor roles |
| **History** | 30 days |
| **Ranges as tables** | “Leaf from selection” turns a range into a table that agents, dashboards, datasites and Query Bench can read. It always shows the current cells. |

## FAQ

### Does a sheet update when my database changes?

No. Saved results are snapshots. You can edit the sheet, but changes in the original source won’t update it automatically. Save the result again for fresh numbers.

### What can use a sheet as a data source?

AI Analyst, agents you give access to, automations and datasites. Every tab is stored as a database table in your workspace, so they read it like any other connection.

### Can an automation change a sheet?

Yes. Automations can add, update, delete and find booklet rows, and start when a booklet changes or a new row appears.

### Can I open my Excel files?

Yes. Import xlsx, xlsm, CSV or TSV up to 100 MB, and export as xlsx, CSV or TSV. Macros in an imported file are never run.

### Who can see my sheet?

Only you, until you share it. People you share with are viewers or editors.

Part of [Up close with your data](https://supaboard.ai/product/up-close).

---

- Site index for agents: https://supaboard.ai/llms.txt
- Sitemap: https://supaboard.ai/sitemap.xml
- Blog feed: https://supaboard.ai/blog/rss.xml
- Product documentation: https://docs.supaboard.ai

Any page on https://supaboard.ai is available as markdown: append `.md` to its path, or send `Accept: text/markdown`.
