Spreadsheet

Zoho Sheet is an online spreadsheet application that lets you create, edit and share spreadsheets. It can be used to work with large amount of data, functions, formulas and charts. It is a great online productivity application which businesses find extremely useful for collaboration.

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 9 & above
• Mozilla Firefox 4 & above
• Chrome 9 & above
• Safari 5 & above

Zoho Sheet is available in 13 languages - English, Chinese, Dutch, French, German, Korean, Italian, Japanese, Polish, Portuguese, Spanish, Swedish and Turkish.

Zoho Sheet supports up to 1 million cells for a single spreadsheet with a maximum number of 65536 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 350 built-in 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 with a notification "Saving..." followed by "Last saved at (time)" at the top.

Yes, versions can be created in Zoho Sheet. Versions are automatically created when when a collaborator makes changes to the spreadsheet. Zoho Sheet stores the most recent 100 versions if you wish to revert to any of them. You can also choose to save your versions from the Review toolbar.

As of now, you can access http://m.zoho.com/ to view your spreadsheets through an iPhone/iPad. Editing is not yet supported for iPhone/iPad.

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 not possible to import an individual spreadsheet which is part of a document.

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 over those cells, the name of the collaborator will be displayed.

No, it is not possible to be notified directly whenever a change is made to a spreadsheet. However, the Zoho Docs menu can be sorted according to the Date Modified, with which it is possible to know whether a change has been made.

At the bottom right below the spreadsheet you can see a notification showing the names of those who are currently present/working on the spreadsheet. In the Collaborators bar, you can see the number of collaborators viewing your spreadsheet.

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. You can 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 website/blog, follow the steps below:

1. Click share > Embed
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 to embed the spreadsheet.

Yes. You can hide and lock the formula cells by checking Hide and Lock Formula Cells option in the ' Embed to Website/Blog' 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 exporting the published spreadsheet.

No. You can edit the sheet if you wish to but any changes made by the user will not be saved to the published spreadsheet. You can save a copy of the spreadsheet to your Zoho Docs 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 Share > Publish > Publish this Range in.

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

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

• Column Chart
• Bar Chart
• Line Chart
• Pie Chart
• Scatter Chart
• Area Chart
• Web Chart
• Bubble Chart
• Stock Chart
• Doughnut Chart
• Time Series Chart
• Combination Chart
• Waterfall Chart

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 Macros menu and select the Record Macro option from the toolbar.
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.

No, currently Zoho Sheet does not support User Defined Functions.

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.