What's New

Zoho Sheet now supports executing custom functions through buttons either by assigning a new or existing custom functions to them.

Slicers help you quickly filter large amounts of data from one or more associated pivot tables simultaneously. You can insert, edit, and delete slicers anytime to adjust your options for organizing and visualizing data. 

Zia can now summarize and highlight insights from the generated charts and pivot tables.

When you have multiple sheets in a workbook, navigating them can become a challenge—but Zoho Sheet has the solution. You can now quickly search and find any sheet from the status bar using the search option.

Zoho Sheet now allows you to view the list of hidden sheets and unhide them all at once.

No more default gridline color! Choose from a range of colors and personalize your spreadsheet's gridlines. Try it now!

Do you spend hours drafting new records and copy-pasting data from other sources? Now, you can efficiently create and share bulk data records with Merge Template in Zoho Sheet.

Read more

Zoho Sheet's Zia has been helping our users with data cleaning, insights, and formatting. With this update, you can now experience the power of ChatGPT that helps you with formulas, tables, VBA macros, and more! 

Read more

Work seamlessly on your spreadsheets with Zoho Sheet's new alternate keys for shortcuts similar to your browser's. Use these keyboard shortcuts without interfering with your browser's shortcuts.

Read more

Focus on the record you're working on using the Highlight Row/Column option in Zoho Sheet. Our highlighters are dynamic, meaning they will automatically be enabled when you switch to a different cell.

Read more

Zoho Sheet now allows you to create multiple unique date type fields in a pivot table. You can repeat unique labels within a pivot table using the Repeat Item Labels option.

Read more

Smartly align objects, like charts, buttons, and images, based on the objects surrounding them on your worksheet.

Read more

Now you can seamlessly import data from multiple Zoho apps! Zoho Sheet allows you to create and manage data connections from URLs and 10+ Zoho apps, including CRM, Invoice, and Creator.

Read more

Link live data across spreadsheets in a matter of seconds using the Paste > Link option. Though this option primarily works through the IMPORTRANGE() function, you can link your data without manually entering the function each time.

Read more

Check out the sample codes we've added to help you write APIs in four programming languages, namely:

• Deluge
• Python
• jQuery
• Java
• Curl

Read more

Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text and spreadsheet functions.

Read more

Concerned about losing your spreadsheet data while collaborating with other users? With the new Edit History in Zoho Sheet, you can view a list of values that have been added, modified, or deleted from each cell. You'll also see who made each change and when.

You can now find your file's name at the top left corner. Plus, we've redesigned our side pane. Visit the side pane to manage all your conditional formatting rules, and to access Zia from a new, more prominent position.

Conveniently record, format, and analyze your data set with Zoho Sheet's Tables. You can customize the table style and color to suit your preference.

Highlight and compare values in a range of cells with the new Data Bar conditional formatting option in Zoho Sheet.

Not only can Zia help you crunch numbers, but she can now help you refine and better format your data set. Get AI-powered data formatting suggestions from Zia in Zoho Sheet.

Zoho Sheet's Font Library has been updated with new font styles in over 60+ languages. You can also choose a font style saved on your computer and add it to the Font Library. Try our new font styles in your spreadsheet!

Maintain consistent formatting across your spreadsheets with Zoho Sheet's Themes. You can select, customize, and apply any theme from the list of available options.

We've launched seven new functions to help you arrange data tables in the most preferred format. Here are they!

• TOROW
• TOCOL
• HSTACK
• VSTACK
• TAKE
• DROP
• NUMBERVALUE

Read more.

Spending too much time hovering over menus to find the desired feature? Use Feature Finder to locate the necessary tools for your spreadsheet data.

Read more.

Zoho Sheet now lets you format parts of the content in cells, separately. With these text formatting options, you can give your data a more defined representation.

Read more.

You can now group rows and columns, making it easier to organize and present data better. Try it out.

Read more.

Now, you can publish interactive sheets and specific data ranges using the new publish control and customization options from Zoho Sheet!

With the all new LAMBDA function, you'll now be able to create custom functions with ease. The LAMBDA function can also make your spreadsheet functions self-explanatory with the help of named variables.

Read more.

​

Take data from any website to your Zoho Sheet spreadsheet in just a few clicks! With the extension, you can also open new spreadsheets, access existing files or templates, and bring spreadsheets from your computer to cloud. A handy clipper and a hassle free extension, in one package.

Add to Chrome | Add to Firefox

Zoho Sheet's array formulas are now a whole lot easier to work with. Without having to select the result range before hand, or use the Cmd/Ctrl+Shift+Enter keys, you can now simply enter the array formula just like a non-array one.  With the #SPILL error, the '#' and '@' operators, the new and improved dynamic array formulas are simpler than ever, but a lot more effective.

While Zoho Sheet allows you to share and collaborate with your colleagues in real time, you might wish to send your spreadsheets as email attachments or keep an offline version of a confidential file with password protection.

Working with long, textual data in spreadsheets just got better! Zoho Sheet now supports text rotation, indentation, and wrapping options, which you can use to display the text and other values in your spreadsheet exactly the way you want.

We've introduced four new functions, powerful enough to revolutionize your spreadsheets forever! They are,

• LET
• IMAGE
• SPLIT
• IFNA

To learn more about the functions, read more.

We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant.

The latest enhancements to Zoho Sheet's Print settings allow you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Now, you can retain header/footer and frozen rows/columns, choose the order of printing, select from numerous fitting options, and preview without a extra click!

Picklists are custom drop-down lists with predefined values and formats that can be applied on the desired cell range. These customized drop-downs help you control the data entered into your spreadsheet and speed up the process too!

Here at Zoho Sheet, we know that functions are an integral part of any spreadsheet application. With more than 400 predefined functions, our team is still constantly working to improve the functions gallery even more. In this update, we’re happy to introduce XLOOKUP, XMATCH, and six other new functions in Zoho Sheet.

• XLOOKUP
• XMATCH
• SORT
• SORTBY
• RANDARRAY
• SEQUENCE
• RANK.EQ
• RANK.AVG

We're excited to announce our latest addition to the chart family—Race Charts. These animated bar charts help you bring your periodic data to life with the dynamic bars that move according to the data given. Zoho Sheet also allows you to customize the chart style, axis, animation speed, and more. You also get to publish and embed them in your web site or blog.

User-level filters allow each collaborator to create and apply filters based on their needs, without disrupting the view for other people working on the spreadsheet. You can also name these filters for quick access.

Now, convert hard copies of data such as receipts, invoices, books, etc, into spreadsheets in an instant using the new 'Data from Picture' feature on Zoho Sheet's mobile apps. It is available for iOS and Android devices, including tablets.

From currency conversion to data filtering, do more with Zoho Sheet's nine new functions: 

1. CURRENCY
2. FILTER
3. TEXTJOIN 
4. MAXIFS
5. MINIFS
6. IFS 
7. UNIQUE 
8. XOR 
9. DATEDIF 

Zoho Sheet has gone through a from-the-scratch facelift and is now all the more powerful. Artificial Intelligence powered Data Analysis, automatic Data Cleaning, the power to integrate Zoho Sheet with multiple applications via Custom Functions, more ways to visualize data, and a lot more new features to help improve your productivity! Learn more.

Filtering is a great way to organize and group visible information, especially when dealing with large datasets. Now, you can use the handy FILTER function to fetch only the data you need from a data set, in a separate cell range. For instance, in a table of profits and losses for different companies, use the =FILTER function to group companies that are showing losses in one area and companies that are showing profits in another. Unlike the column-wise filters, you will be able to view both the entire list and the filtered list at the same time.

Referring to another cell via a formula will automatically inherit the number format of the dependent cell, provided no explicit format has been set on the formula cell. If you refer to a range of cells, then the format of the top left cell will be inherited by the formula cell. If the formula cell refers to multiple cells and or ranges, the cell inherits the format of the first range you refer to. Once formatting has been inherited, it will become independent of the original cell that it was inherited from. 

Zoho Sheet aims to keep migration as smooth as possible, which is why we've made it possible to import without disrupting cell and sheet locks .xlsx files. Assuming that the spreadsheet is not password protected, all the cell or sheet level locks will be imported along with the files. These locks can be modified, extended or removed by the owner at any time.

Zoho Sheet's new listing page has made accessing your spreadsheet even simpler. Get started by simply uploading or dragging and dropping spreadsheets into your Zoho Sheet's new listing page. To help organize your work, files in your account are shelved on different views like Owned by me and Shared with me based on the ownership. You can choose to keep the spreadsheets you use the most in one place by marking them as Favorites. The new listing page keeps all the spreadsheets organized, with additional folders like 'Templates' and 'Trash' as well. 

We've added a few more custom formats to help view data more comfortably, one of which is to make it easier to deal with large numbers. You can now use a comma (,) for a thousands separator. A comma enclosed by zeros or number symbols (#) will separate thousands. Scale the number in multiples of 1000, by increasing the number of commas following the digit placeholder. For example, 1002998000 will be displayed as 1003.0 when formatted as #0.0,, and as 1002998.0 when formatted as #0.0,. 

​

Zoho Sheet has been supporting a few right-to-left languages like Arabic, Hebrew, etc. Now, we've made our spreadsheets customized for them too.

• The whole interface, including the menu tab, sheet tabs, row/column headers, along with the cursor, works from right to left.
• You can flip sheets individually from RTL to LTR or vice versa, with a single click.
• No matter how many sheets your spreadsheet holds, flip all of them in one go.

Learn more

Comparing and visualizing data in Zoho Sheet has gone one step further with Icon Sets. You can now insert colorful icons into your spreadsheet to represent data graphically within each cell. It's time to make the cells more exciting.

Here are some things you can do with icons in your spreadsheet:

• Use direction icons to show rise and fall in shares, profit, loss, or even to compare values of different currencies.
• Keep track of a project's progress or the percentage occupied, using pie symbols.
• Rate products, restaurants, and movies with stars, hearts, or smileys.
• Give a thumbs up to ideas/deals you like and a thumbs down to those that did not work out.
• Study trends in sales with arrows.
• Monitor patterns and analyze the weather conditions with cloud icons.
• Make your spreadsheet less clumsy by using icons with no numbers displayed.

The icons range from two to five in number per set making them flexible with your data. Apply Color Scales and Icon Sets together to display data patterns prominently. Want to mix symbols and create your own icon set? Use "Custom" under Icon Sets.

Learn more

Conditional Formatting gets a new look, in fact a colorful one. The Conditional Formatting present has been retained as 'Classic' and a new background color based formatting called 'Color Scales' has been introduced.

Now, perform charting effortlessly as Zoho Sheet brings to you the most user-friendly charts. Choose from recommended charts, copy styles, clone, and move them to other sheets in a spreadsheet.

Your helpmate for effective evaluation.

Often it's hard to decide on the chart type that works best for a set of data. Zoho Sheet makes it easy for you by recommending suitable charts for your data.

Creating 'same' and 'similar' charts.

Clone charts and tweak them to create different chart types that represent the same data. Struggling to reprise the perfect chart style you had achieved in another spreadsheet? Strain no more. Just copy-paste the styles to any chart and make it reflect your best style. Repeat the same within spreadsheets for a consistent style.

Find the right place for your charts.

Put an end to recreating or repeating charts with the same data range. It takes just one 'move' to relocate your chart within a spreadsheet. In case you want the same chart in two different sheets, clone and move it, swiftly.

Get charts done, even before you know it.

Analyzing and visualizing large data just got easier. Pivot Charts are back in Zoho Sheet with more indigeneity. Now, Pivot Charts coexist with your Pivot Tables. Watch all your Pivot Table data come alive as charts. And watch them change with any changes to your Pivot Table.

Copy function in Zoho Sheet has been improved, expanding the ambit of copy. The enhanced copy takes the function across spreadsheets broadly in two ways.

Charts help you analyse and compare data. With our new enhancements you can customize charts with ease, and perform charting your way. Just click on the chart you wish to edit and make changes.

Further your collaborative experience with the new comments feature in Zoho Sheet. Discuss with collaborators inside the spreadsheet, alongside content and avoid copy-pasting spreadsheet content in mail to communicate.

Checkbox, the most familiar interface element is now in Zoho Sheet. Checkboxes are easy to use, mouse friendly and having it in a spreadsheet makes it easy for people to enter data with a single click. This makes it a must have element in spreadsheets designed for other people.

Charts help you analyze and visualize the most complex of data in a spreadsheet and we folks at Zoho Sheet are continuously working to improve your charting experience. Here are a few enhancements to the Chart engine which will make your data more productive.

Zoho Sheet will now support .xlsm files. In order to import a macro enabled Excel workbook, click the File menu and choose Import. The option also allows changing file names upon import. You can also import files from a URL.

The Zoho Sheet experience just got bigger and better. The amount of data that the online spreadsheet can hold has doubled. Now, Zoho Sheet supports up to two million cells of data in one or more sheet, each of which holds up to 65,536 rows and 256 columns.

We are excited to present the new, elegant Zoho Sheet UI. The UI features new tabs, more colorful icons, and a look and feel that enriches the user's experience while retaining functionality. In addition, the design is in line with other productivity applications from Zoho at the same time enhancing your Zoho Sheet experience.

Forms, an intuitive cloud-based feature, is now available in Zoho Sheet. The good thing about integrating Forms in our spreadsheet is that you don't have to don your programmer hat to create one. Forms capture data in the most flexible and customized of ways. All you have to do is click on the Form tab and select the Create Form option.

The simple "Drag and Drop Builder" allows you to create a form quickly.

Entering data spanning a long range of cells can be time consuming. Forms in Zoho Sheet helps you hop through this error-prone zone with ease. Just supply the form with values and watch it get populated into the sheet in real time.

The Form feature also enables you to perform sophisticated actions, such as configuring Rules for fields or changing the Field properties of your Form elements. While ‘Forms’ caters to data in simpler formats, its integration into spreadsheet gives you the advantage of performing complex calculations on your data, thanks to the processing capabilities of 'Zoho Sheet’.

Last but not least, the most intriguing feature of Forms in Zoho Sheet is that it can be published. Share it inside your organization, or with the public via a link, or as an embed on your website. Present it to a larger audience!

In a nutshell, the integration not only makes data capturing easy, but makes sure all your data stays in a single place so it is ready to use anywhere, anytime.

Pivot Tables lets you slice and dice the data in your spreadsheet and helps you gather meaningful insights from your data. We have completely revamped the Pivot Table functionality in Zoho Sheet and have made it more native to the spreadsheet.

There have been quite a few enhancements to the chart engine. We have added two new chart types that will help you represent data even better. The funnel chart and the semi doughnut charts are the two types that have been introduced recently. The funnel chart helps you get a realistic understanding of data as it keeps varying with respect to other parameters in ascendence or descendence. The semi-doughnut chart also compares and indicates the position of the specific component as a ratio of the total. Multiple ranged doughnut charts have also been introduced. These are charts in which a maximum of five different data series are possible.

Data Visualization is an integral part of data analysis and we are happy to say that we have revamped our chart engine offer you interactive data visualization. This new update lets you interact with data in a way that ensures you receive the best possible intuition out of the data. The update also lets a new tab dedicated just for charting be created whenever a chart is published enabling easy access and editing of charts.

One of the most awaited features in Sheet has been released. Lock Cells gives you the ability to protect and secure your cell ranges from being modified further once they have been edited. Sheet also provides the additional benefit of locking a sheet completely disabling any editing or modifications. The ranges or sheets that are to be locked can be locked individually to specific users giving you greater collaboration benefits. You will be able to ensure that data once finalized will continue to remain undisturbed by other modifications using this feature. We hope that this feature will further enrich your experience of working with Sheet.

Invalid data that is now present in ranges where data validation has been enabled can now be highlighted. In a data validated range, this can be used specifically to identify and highlight those cells that violate the set validation rules. This feature can be found under the Data tab. You can choose to turn off or turn on the feature from the same.

Wanted to collaborate with other users on the web and thought it wasn't possible? Use password enabled sharing options now to achieve this functionality. Share your spreadsheet publicly on the net with security by enabling password protection. You can even collaborate with a user who has not signed up yet with Zoho. Your collaborator can choose his or her username which will be displayed to other collaborators of the spreadsheet. He is given full editing privileges to that particular spreadsheet that was shared. Now, collaboration became a lot more easier over the cloud...

Collaborator Presence

Our new features help you to accomplish tasks better with your collaborators. You can now not only view if a collaborator is present in a single cell, but also if he or she is working across a range of cells or is editing a particular cell. We believe enabling the presence of collaborators across a range will help in collaboration better. When a cell is being edited, the presence of the user is displayed through dotted lines across the cell. You can also choose to view or hide the presence of your collaborators by using Collaborators menu present under Share tab. With real time collaboration already being supported, this revamp will help you collaborate efficiently and increase your productivity.

This feature helps you to add a new cell to the existing data present in the spreadsheet. You can choose to shift cells either right or shift them down to make room for the cell that is to be inserted. This new feature can be accessed from the Insert Tab. This feature is helpful when you wish to insert data that has been missed during data entry into its appropriate position and don't wish to add a new row or column for this purpose.

This feature also enables you to delete a particular cell that is not required. You can shift the other cells either left or up in order to delete the required cell. This feature can also be accessed from the Home Tab and the context menu of the cell to be moved.

Tired of having inappropriate data entered in cells?

Data Validation will make it easy for you to enter valid and correct data in appropriate fields. This feature lets you set precise limits for the data to be entered into the fields. Be it text, numbers or date and time, data validation is capable of assuring you that there will be no errors during data entry.

'Text to Columns' is a feature that allows you to split data in cells to different columns based on a delimiter. This is quite useful when you want to split data in one column to multiple columns. This option is available under the Data tab. Select the range of cells you want to split and then click on the 'Text to Columns' button under the Data tab in the toolbar. This dialog will also be shown automatically when you paste data from an external application, provided it spans multiple rows and appears to be delimited by a character other than the tab character. We believe that this feature is very useful when you paste a bunch of data from external applications.

You can now notify collaborators via email right from within the spreadsheet editor. You can use this 'Notify Collaborators' to send an email right from within our application reminding them to fill in the required data. 'Notify Collaborators' is available under the Share tab. It is available for both the owner of a document as well as to those with whom it has been shared. An owner of a document can notify all collaborators or specific people. A collaborator can notify all other collaborators / specific people / owner / owners & co-owners. The feature is of great use to communicate with your collaborators easliy.

Version History interface has been revamped to help you identify what changes have gone into each version and who has made those changes. This becomes all the more essential when you work in a collaborative setup. Version History is accessible from the 'File' menu as well as the 'Review' tab. The Version History opens up and docks to the right side of the spreadsheet helping you quickly switch between different versions. In each version, the modified cells are highlighted using the color associated with each collaborator. The color of the collaborator is indicated in the Version History listing. You can turn off highlighting if you don't need it.