Get started now
Zoho One | Team Collaboration & Projects

Zoho Sheet: Spreadsheets That Connect to the Rest of Zoho

Zoho Sheet
Formulas, pivots and charts with real co-editing, plus live data from Zoho CRM, Books and Forms.

At a glance

What it is
Online spreadsheet with collaboration, pivots, macros and live Zoho data connections
Best for
Teams sharing working spreadsheets and anyone who exports Zoho data to analyse it
Pricing
Free; included in Workplace and Zoho One
Zoho One
Included
✓2,000+Zoho projects delivered
13+13+ yearsbuilding Zoho systems
●US · Canada · EuropePremium Partner
Zoho Sheet is Zoho’s online spreadsheet, free with a Zoho account and included in Workplace and Zoho One. It covers formulas, pivot tables, conditional formatting, charts, data validation, macros and Zia-driven analysis, with real-time collaboration and version history. It opens and exports Excel files and connects to Zoho CRM, Books, Forms and Analytics, so a sheet can pull live data rather than a pasted export.

Spreadsheets are where business data goes when it leaves the system, and that is the problem: a pasted export is wrong the moment it is pasted. Zoho Sheet is a full spreadsheet, with the formulas, pivots and macros people expect, and it can hold live connections to Zoho CRM, Zoho Books and Zoho Forms, so the working file stays current. This guide covers the editor, the connections, and the line between Sheet and Zoho Analytics. It is one of the Team Collaboration & Projects apps in Zoho One.

What Zoho Sheet Does

  • 350+ functions, pivot tables, conditional formatting, data validation and named ranges.
  • Charts and sparklines, with chart styles for presentations.
  • Real-time co-editing, comments, cell-level locking and version history.
  • Macros recorded or written in VBA-compatible syntax, and Deluge custom functions.
  • Zia: ask a question in plain language and get a chart or pivot.
  • Data from Zoho CRM, Books, Forms, Analytics and WorkDrive; import from Excel, CSV, Google Sheets.
  • Publishing sheets or ranges to the web, and embedding.
  • Mobile apps with offline editing.

Zoho Sheet Pricing

PlanPriceNotes
Free$0Full spreadsheet with a Zoho account
Workplace and Zoho OneIncludedTeam sharing, admin controls and higher limits

See the official Zoho Sheet page for current limits; Sheet is included in Workplace and Zoho One.

Pricing checked October 2026. These are Zoho’s published rates at the time of writing. They change over time, vary by region and currency, and may differ inside Zoho One, so confirm the current figures on the official pricing page linked above before you decide.

Sheet or Zoho Analytics?

Use Zoho Sheet whenUse Zoho Analytics when
One person or a small team works a model or listMany people need the same dashboard refreshed automatically
The data is a few thousand rowsThe data is millions of rows across several apps
Formulas and manual adjustments are the pointScheduled reports, drill-downs and permissions are the point
It is a working fileIt is a reporting system

Many businesses prototype a report in Sheet and rebuild it in Analytics once the team relies on it.

Live Data From Zoho Apps

  1. Connect the sheet to Zoho CRM and pick the module, view and fields.
  2. Set the refresh: manual, or scheduled, so the sheet updates without re-exporting.
  3. Build pivots and charts on the connected range; they update with it.
  4. Share with view rights so colleagues see current data without editing the connection.
  5. For two-way updates, use Zoho Forms or CRM’s own import rather than editing CRM from a sheet.

Where Sheet Fits in Daily Work

  • Sales: territory planning and quota models on live pipeline data.
  • Finance: budget versus actual from Books, with manual forecast columns.
  • Operations: stock and order checks from Inventory exports.
  • Marketing: campaign trackers with Forms submissions arriving automatically.
  • Everyone: the quick calculation that does not deserve a report.

Sheet, Excel or Google Sheets?

Excel remains the deepest tool for heavy modelling and legacy macros, and Google Sheets has the widest sharing habit. Zoho Sheet matches most day-to-day needs, imports Excel files including many macros, and wins where data comes from Zoho apps. Teams on Zoho One usually keep Excel for the few people who need it and move shared working files to Sheet.

Common Mistakes

  • Exporting CRM to a sheet weekly when a live connection would refresh itself.
  • Building the company’s main reports in a spreadsheet that one person understands.
  • Sharing edit rights widely and losing formulas to accidental edits; lock the formula cells.
  • Keeping customer lists in sheets instead of CRM.

Macros and Custom Functions

Recorded macros cover repetitive formatting and clean-up. For logic, Sheet runs VBA-style macros, which brings many Excel workbooks across intact, and Deluge custom functions, which let a sheet call Zoho CRM or Books directly. A finance team can keep its Excel macros and add a Deluge function that fetches current receivables, which is a combination neither Excel nor Google Sheets offers.

Sharing and Control

  • View, comment and edit rights per person or group, with link expiry.
  • Lock ranges so formulas survive; leave input cells open.
  • Publish a range as a read-only web page for a team dashboard.
  • Version history with restore, and named versions before big changes.

Getting Started

  1. Import the spreadsheet the team argues about most.
  2. Replace its pasted export with a live Zoho connection.
  3. Lock the formulas and share with view rights.
  4. Rebuild its one important chart with Zia and compare.

Zia in Spreadsheets

Zia reads the sheet and answers questions in plain language: which region grew most, what the monthly average is, which rows look like outliers. It suggests charts and pivots, cleans data such as inconsistent formats and duplicates, and flags anomalies. For people who never learned pivot tables it is the fastest route to an answer, and for analysts it is a first draft they refine.

Sheet for Different Teams

TeamUse
SalesQuota and territory models on live CRM pipeline
FinanceBudget versus actual with Books data, forecast columns by hand
OperationsStock and order checks from Inventory, locked formulas
MarketingCampaign trackers fed by Forms submissions
LeadershipPublished read-only ranges as simple dashboards

Importing and Cleaning Data

Sheet imports Excel, CSV, TSV, ODS and Google Sheets files, and Zia’s data cleaning finds duplicates, inconsistent dates and mixed formats before they poison a formula. For data that will go into Zoho CRM or Books, clean it in Sheet, then import through the app’s own importer, which validates fields; a sheet connected to CRM is for reading, not for pushing changes back.

Common Questions

  • Will my Excel macros run? Many do, through the VBA-compatible engine; complex add-ins and external references do not.
  • Can clients view a sheet without a Zoho account? Yes, through a shared link or a published range.
  • Can I print or export to PDF? Yes, with page setup and print ranges.

Questions People Ask About Zoho Sheet

Short answers, drawn from the guide above.

Is Zoho Sheet free?

Yes, with a Zoho account; Workplace and Zoho One include it with team controls and higher limits.

Does Zoho Sheet open Excel files?

Yes. It imports and exports .xlsx and supports many Excel macros through its VBA-compatible macro engine.

Can Zoho Sheet pull live data from Zoho CRM?

Yes. A sheet can connect to CRM modules and views and refresh on a schedule, so pivots and charts stay current.

Does it support pivot tables and macros?

Yes. Pivot tables, conditional formatting, data validation, recorded and written macros, and Deluge custom functions.

What is the difference between Zoho Sheet and Zoho Analytics?

Sheet is a working spreadsheet for people and small teams. Analytics is a reporting system for large data, scheduled dashboards and permissions.

Can several people edit at once?

Yes, with real-time co-editing, comments, cell locking and version history.

Watch: video guides for this section

Demos and tutorials picked for this section. Subscribe to the ABR channel for more.

Subscribe to the channel

Guides in this section

Every article filed under this category, newest first.

A note on pricing. Prices and plan limits on this page are Zoho's published rates at the time of writing and change over time, vary by region and currency, and can differ inside Zoho One. Always confirm current figures on Zoho's official pricing page or ask us before you buy.

Want this set up properly?

We configure Zoho apps around how your business actually runs, connect them to the rest of your stack and train your team. ABR is a Zoho Premium Partner with 2,000+ completed projects since 2013.

  • A Zoho Premium Partner team
  • Configured around your process
  • Connected to CRM, Books and Cliq
  • Your team trained