Spreadsheet

Zoho Sheet is an online spreadsheet application that lets you create, edit, share, and collaborate on spreadsheets. With AI-powered tools for analysis and data cleaning, Zoho Sheet makes your work easier. Read more about Zoho Sheet here.

With Zoho Sheet, you can create, manage and share spreadsheets online. You can collaborate with users/ groups/ organizations in real time. It comes in handy for business people, accountants, scientists, scholars, students and anyone who deals with tabular data and needs to use spreadsheets. Zoho Sheet boosts your productivity by letting you gather, record, analyze, visualize data.

• Internet Explorer 11 & above
• Mozilla Firefox 50 & above
• Chrome 50 & above
• Safari 9 & above
• Opera 40 & above

Zoho Sheet is available in 18 languages - English, German, Spanish, French, Hungarian, Italian, Japanese, Dutch, Polish, Portugese, Russian, Swedish, Turkish, Chinese, Croatian, Korean, Bulgarian, and Esperanto.

Zoho Sheet supports up to 2 million cells of data in a single spreadsheet (across multiple sheets) with a maximum number of 65,536 rows and 256 columns per sheet.

Click here to get the complete list of keyboard shortcuts that you can use in Zoho Sheet.

Zoho Sheet supports more than 400 predefined functions. All the functions supported by Zoho Sheet are listed in the Functions Reference page.

You don't need to explicitly save your spreadsheet. The moment you edit something, your spreadsheet saves automatically.

While Zoho Sheet automatically saves versions of your spreadsheet, you can choose to create versions too. Zoho Sheet stores the most recent 100 versions, if you wish to revert to any of them. Learn how to create a new version, here.

Zoho Sheet is available for free download on the App Store and Play Store using which you can install the app and work on your spreadsheets using your iPhones, iPads, Android smartphones and tablets..

You can import spreadsheets in one of the below formats:

• .xlsx (Microsoft Excel Workbook)
• .xls (Microsoft Excel 97-2003 Workbook)
• .xlsm (Microsoft Excel Macro - Enabled Workbook)
• .sxc (OpenOffice Spreadsheet)
• .ods (OpenDocument Spreadsheet)
• .csv (Comma Separated Values)
• .tsv (Tab Separated Values)

The maximum file size allowed is 10 MB.

No. You cannot import the password protected spreadsheets. Only unprotected spreadsheets can be imported in Zoho Sheet.

You can export your spreadsheet into a variety of formats as given below:

• .xls (MS Excel 97-2003 Workbook)
• .xlsx (MS Excel Workbook)
• .ods (OpenDocument Spreadsheet)
• .csv (Comma Separated Values)
• .tsv (Tab Separated Values)
• .html (HTML Document)
• .pdf (PDF Document)

No, it is currently not possible to export individual sheets which are a part of a spreadsheet.

There is no limit on the maximum number of spreadsheets that you can export or download. All the spreadsheets that have been created in the document can be exported. The maximum number of spreadsheets that can be created per document is 256.

Yes, you can filter data using the Filter Option from Data tab. Data can be filtered using Cell Value, Cell Color and Text Color. Data can also be sorted using conditions

Yes. In Zoho Sheet you can fetch data periodically from the configured URL which could include CSV files, RSS Feeds or HTML pages and update the spreadsheet automatically. Click the More menu from the toolbar and select the Link External Data option. Provide URL, select Sheet name in which you want the data to be populated and configure the Schedule to import the data.

Rotating text in a cell is currently not supported in Zoho Sheet. However as a workaround, you can make the text to appear vertical by typing one character per line and using Ctrl+Enter or Alt+Enter keys for line break within a cell.

Yes. Array of constant values can be passed to any function as argument. An array should be framed by enclosing the array values with curly braces like {1, 2, 3}. Comma or Semicolon should be used as column separator and vertical bar | as row separator. For example: {1,2,3 | 4,5,6} or {"a";"b";"c" | "d";"e";"f"}. Array functions are executed using Ctrl + Shift + Enter instead of Enter.

Yes. It is possible to view the changes made by the collaborators in real time. The changes made by the owner and the collaborators in the spreadsheet are immediately viewed by other collaborators and the owner. During collaboration, each collaborator is given a color code. The cells in which collaborators work are displayed in the respective colors and highlighted. When you hover the mouse pointer over those cells, the name of the collaborator will be displayed.

Though it is not possible to get a notification from Zoho Sheet directly, you can use Zoho Sheet's integration with Zapier and Zoho Flow to achieve the same.

In the side panel, you can choose the "Chat" option and then choose "Users" tab to see all the collaborators in your spreadsheet and those who are currently active. The active collaborators profiles will also be displayed at the right bottom of the spreadsheet editor.

Yes, you can send an email to all the shared users by selecting Notify Collaborators option from Share menu. When you use this option, individual emails are sent to each shared user in that particular spreadsheet. You can also choose to send mails only to owners and co-owners of the document or to all collaborators or only to specific collaborators.

To make your spreadsheet public, follow the below steps:

1. Click Share > Publish
2. Select the required options in the dialog box that opens.
3. Click OK.

To embed your spreadsheet in a website/blog, follow the steps below:

1. Click Share > Publish
2. Select the required options in the dialog box that opens. Spreadsheet will be made public and a HTML snippet to embed in your website/blog will be shown.
3. Copy and paste the snippet in the source code of your web page or blog to embed the spreadsheet.

Yes, you can hide and lock the formula cells by checking "Hide and Lock Formula Cells" option in the "Publish Spreadsheet" dialog box while publishing a spreadsheet. Once you select this option, all formula cells will be locked in the published spreadsheet. Users will not be able to view and make any changes to the formula.

While publishing you can uncheck the "Allow to export" option to restrict users from downloading the published spreadsheet.

No. Any changes made to the published spreadsheet will not be saved to the source file. Users can choose to save a copy of the spreadsheet to their Zoho account and edit it later as well.

Yes, it is possible to publish a specific range from a spreadsheet. To publish a range of cells,

1. Click Data > Publish Range > Publish this Range.

Or you can right click the range to be published and choose Publish this Range from the context menu. {Code Snippet}

Zoho Sheet supports both 2D and 3D charts. The following are the types of charts available

Visual Basic for Applications (VBA) is the programming language used to write macros in Zoho Sheet.

Yes, you can record a macro and play it back. Follow the steps below to record a macro:

1. Click the VBA Macros option from the Tools menu and select the Record Macro option.
2. Name the macro and click Start Recording.
3. Do the required actions and click Stop Recording.

To play the recorded macro:

1. Click the Macros menu and click on the Run Macro option from the toolbar or press the shortcut Alt+F8.
2. Select the macro that you want to run.

Zoho Sheet supports the following events:

Workbook Events:

1. Open
2. New Sheet

Sheet Events:

1. Change

You can make use of the Change event. This event is triggered whenever the values are entered/edited by the user or by an external link.

You can make use of the Open event of the 'ThisWorkbook' module in the VBA editor. This event is triggered whenever a spreadsheet is opened.

Yes, user defined functions in Zoho Sheet are powered by Deluge. Click here to learn more about Custom Functions in Zoho Sheet.

No. Currently, it is not possible to import/reuse the macro from one spreadsheet to another in Zoho Sheet. However, you can copy the macro code from the old spreadsheet and paste it in your new spreadsheet.

You can achieve this by performing the following actions:

To lock cells:

1. Select the range of cells you would like to lock.
2. Click Data > Lock Cells.
3. Choose the collaborators for whom you want to lock cells and click the Lock icon.

To hide gridlines, click View > Hide Gridlines. To bring them back, click Show Gridlines from the same menu.

Yes, read-only users can create a new filter and apply existing named filters. However, the users cannot rename or delete an existing named filter.

You can name a filter only if you have specified a condition on the columns of your filter range.

Yes. While creating the new filter, enter the name of the existing filter that is to be replaced. On submission, an alert will be displayed where you can confirm and replace the filter with the new one.

Any number of named filters can be created in a sheet.