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.

The Sheets editor with formatted cells, coloured status cells and the toolbar

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.

The All workbooks list with search, sort and the Created by me filter

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.

In this section

  • Charts — Turn a block of cells into a bar, line, area or pie chart that updates with the data.
  • Comment on cells and mention teammates — Start a discussion on any cell, reply in threads, @mention teammates so they get notified, and resolve threads when the question is answered.
  • Create and import workbooks — Create a workbook blank or from a template, import an Excel file, and find, copy, rename or delete workbooks.
  • Data validation — Limit a column to a list, a range, a length or a format like GSTIN, and refuse or flag values that break it.
  • Edit records in Sheets — Export a record type to a spreadsheet, edit it in bulk, and push changes back with live sync rules and limits.
  • Edit together — See who else is in a workbook, where they are, and how simultaneous edits are handled.
  • Format cells — Bold and colour cells, align text, set number and date formats, add notes and colour cells automatically with conditional formatting.
  • Function reference — All 97 functions you can use in Sheets formulas, with syntax and what each does, from SUM and AVERAGE to date maths and text formatting.
  • Import and export — Import CSV into a sheet, export a sheet as CSV, and export a whole workbook as Excel.
  • Import, export and print sheets — Bring in CSV, TSV, text, Excel, OpenDocument files or a Google Sheets link, export to any of them, and print or save a sheet as a PDF.
  • Keyboard shortcuts — Every keyboard shortcut in the Sheets editor, from editing cells and undo to cut, copy, paste and formatting. Press ? in a sheet to see the list.
  • Limits — Maximum tabs, columns, rows and cells in Sheets, and the rows allowed on each plan.
  • Use Sheets on your phone — Read, edit and check spreadsheet rows from a phone — tap a cell to edit it, or see a whole row as a card.
  • Open a query in Sheets — Send an Analytics query result to a workbook, editable and linked to records when possible.
  • Summarize data with pivot tables — Turn a long list of rows into a compact summary — totals, counts and averages by category — that refreshes from your data.
  • Protect sheets and ranges — Stop teammates changing approved figures, headers or whole sheets by mistake — choose who can still edit, and whether others are blocked or just warned.
  • Sort, filter and find — Sort rows by one or more columns, filter by values or conditions, and find or replace text.
  • Tabs and columns — Add, rename, colour, hide, duplicate and reorder sheets; insert, resize, hide and delete columns.
  • Workbook templates — Start a workbook from a ready-made template — budget, invoices, stock count, timesheet, projects or sales pipeline.
  • Work in the grid — Type, select, undo, copy and paste, fill a series, insert rows and freeze panes in the Sheets grid.
  • Write formulas — Write Excel-style formulas, refer to other sheets, and look up workspace records with AXLOOKUP.