Sheets
Spreadsheets in your workspace: formulas, formatting, charts, templates, Excel import, live co-editing and a two-way bridge to your records.
Sheets is a spreadsheet inside your workspace. Build workbooks with tabs, formulas, formatting and charts, start from ready-made templates, import Excel, OpenDocument and Google Sheets files, print to PDF, edit together with your team, and work on your records in a grid.

What you can do
- Create, import or copy a workbook — start blank, from a template or from an Excel file. Create and import workbooks · Templates
- Work in the grid — typing, typed columns, selecting, undo, copy and paste, the fill handle, rows and frozen panes. Work in the grid
- Format cells — bold, colours, alignment, number and date formats, notes and conditional formatting. Format cells
- Summarize data with pivot tables — totals, counts and averages by category that refresh from your data. Pivot tables
- Use tabs and columns — add, rename, colour, hide, duplicate, reorder and resize. Tabs and columns
- Keep columns clean — lists with dropdowns, ranges, lengths and GSTIN / PAN / IFSC / PIN formats. Data validation
- Discuss a number — comment on a cell, @mention a teammate and resolve threads. Comment on cells
- Protect what must not change — lock a range or a whole sheet, choose who can still edit, and block or warn. Protect sheets and ranges
- Sort, filter, find and replace. Sort, filter and find
- Write formulas — Excel-style formulas, cross-tab references and record lookups. Write formulas · Function reference
- Add charts — bar, line, area and pie charts from your data. Charts
- Import, export and print — CSV, TSV, text, Excel, OpenDocument or a Google Sheets link in; Excel, OpenDocument, CSV and TSV out; print or save a sheet as a PDF. Import, export and print · Import and export
- Edit together — see who is here and where they are. Edit together
- Edit records in Sheets — export a record type to a grid and push changes back. Edit records in Sheets
- Open a query result in Sheets — from the Analytics query workspace. Open a query in Sheets
- Work faster with the keyboard. Keyboard shortcuts
- Use Sheets on your phone — scroll the grid, tap a cell to edit it, or see a whole row as a card. Use Sheets on your phone
- Know the limits — tabs, columns, rows and plan caps. Limits
Before you start
- Who can use it: Sheets on the Roles page. Can view opens workbooks read-only. Can edit changes cells, formatting, rows and tabs. Full control also creates, copies, renames and deletes workbooks, and protects sheets and ranges.
- Sheets can be switched off in Settings › Apps. It must be on to appear.
- Without access you do not see a workbook at all.
Where to find it
Platform category in the launcher › Sheets. The left rail has four sections:
| Section | What it shows |
|---|---|
| All workbooks | Every workbook you can open, with search, sort, Created by me, and a list or card layout. |
| Recent | What you and your team edited lately, grouped into Today, Yesterday, This week and Earlier. |
| Linked to records | Workbooks whose sheets edit your records — changes flow both ways. |
| Templates | Ready-made workbooks with the formulas already in place. |
Import spreadsheet and New workbook sit at the top right. Click a workbook to open the full-screen editor: a top bar (back button, workbook name, loading status, collaborators, Print, Export), the toolbar, the formula bar, the grid, a status bar and the sheet tabs at the bottom. On a phone the editor is trimmed to the essentials and a tapped cell opens in a panel — see Use Sheets on your phone.

Key ideas
| Term | What it means |
|---|---|
| Workbook | A file of sheets, like an Excel workbook. |
| Sheet (tab) | One grid inside a workbook, shown in the tab strip. |
| Typed column | A column with a fixed type: Text, Number, Currency, Date, Checkbox or Select. |
| Formula | A cell that starts with =. Its result is calculated for you. |
| Conditional formatting | A rule that colours cells when their value matches, for example "Overdue" in red. |
| Record-linked tab | A tab connected to a record type so edits can flow back to the records. |
| Loaded for fast editing | When a workbook is open it is loaded so edits are quick. It is released automatically after about 30 minutes without use. |