Keeping ²վ Sheet inline with the updates from our Office Suite apps, we’re happy to introduceartificial intelligence,arefreshing look, improved performance,robustintegrations, and a bundle of exciting new features that make up the.
Welcoming Zia to ²վ Sheet
Taking ²վ Sheet a step ahead with artificial intelligence, we’re happy to introduce “Insights by Zia”. Zia helps you bring out the essence of your data, with credible conclusions, insights, charts, and pivot tables. Zia answers all your data-related queries and provides you with insertable formulas too.Zia isgoing to continue getting stronger, smarter, and friendlier, so keep watching this space for more updates.Learn more
Cleaner data, better analysis
Anybody who works with hugesets ofdata knows the struggle of removing duplicate rows, rectifying data inconsistencies, and filling in random missing values. Well, that won’t be a problem anymore with the data cleaning tool from ²վ Sheet as it removes the hassle of large data sets. No matter how much data you have, ²վ Sheet will catch everyflawso youcan review andfix them.
Custom functions to suit your needs
²վ Sheet already has an extensive array of 350+ default functions, but you need room to customize. Sowe’re introducing custom functions in ²վ Sheet, powered byDeluge. You can bringcontextual data from other ²վ and third-party applications such as ²վ CRM and Mailchimp into your spreadsheet using these functions, with minimal coding knowledge. Allthe code youneed to create your function is a single line that tells the function what to do—the syntax. Don’t worry, we’ll help you with that too!Learn more
Visualize data better
²վ Sheet now offers you more ways to visualize your data, with three new chart types: Histogram, Pareto, and Wordcloud, as well as chart series aggregation and Sparklines. Sparklines, the in-cell graphs, help you observe changes in data trends without having to move your eyes away from the actual data.
²վ Flow and Zapier Integrations
With ²վ Sheet’s integration with Zapier and ²վ Flow, build automated workflows between ²վ Sheet and hundreds of other ²վ and third-party applications like MailChimp, Slack, Trello,andSalesforce. As an introductory gift here are some pre-built workflows from us.
Your interface, our engineering
This release is abenefit, not just for spreadsheet users, but also for those who intend to create extraordinary applications that deal with data storage, viewing, and editing. If you’re one such developer looking for an API that suits your app,try out the latestData APIs from Sheet that can best fityour users’basic and advanced needs.
New look, feel, and features
²վ Sheet’s new interface is sure to make your experience smoother, faster, andmorecomfortable.Take a look at what’s new:
- Move spreadsheet filesto andfrom other cloud drives
- Chart aggregation
- Three new chart types:Histogram, Pareto, and Word Cloud.
- Views:Classic, Cozy, and Comfort, along with zooming options.
- Hide rows,columns, andsheets
- Newline styles andcolor palette
- Paste or fill values, formats, validations, and more
- Interactive phone numbers
Join the and get notified on all that’s new and trending in ²վ Sheet. Also,tell us how you like the latest updates in the comments below.
This announcement is part of the #FutureOffice series that talks about the latest updates to the ²վ Office Suite. Read the complete announcement here.
I love the ²վ Sheets and Zia. But I am unable to find out if there is a way to create a Table or List like feature in MS Excel. Given that you already have dynamic array functions for calculations, I wish there was a way to handle dynamically growing inputs (without using offset functions with defined names)
Thank you for the feedback! Currently, there is no alternative way to achieve the same, however, we are already working on the Table feature and it will be made available soon.
Really improved a lot !!! It was better than microsoft excel online !!! And as soon as importrange is available as a native function it will be better than google spreadsheets !! but the price for zoho workplace is skyrocketing !! :(
Hi Leonardo, thank you for your lovely words about ²վ Sheet. You just made our day! You can currently use Custom functions in ²վ Sheet to achieve the 'Importrange' use cases. The pricing for the Workplace bundle had been changed minimally owing to the complete revamp of the package with better collaboration and communication tools for improved productivity. Please drop us an email at support@zohosheet.com for further details on the same.