Product releases

Cross-workbook references

We’ve added the IMPORTRANGE function to support referencing data across multiple workbooks.

The function takes two arguments (source workbook URL and source range) and returns the corresponding data. You must have access to copy the source workbook in order to import data. Data is automatically kept in sync when the source data changes.

Spilled range operator

The spilled range operator (#) lets you reference an entire spilled range dynamically in a formula. In the example below, cell A1 =SEQUENCE(2,3) which spills into A1:C2. We then can use SUM(A1#) to sum all of the values in the spilled array range, which equals 21.

As we change the formula in A1 to SEQUENCE(3,3), the downstream formula dynamically updates to the new sum, 45.

The spilled range operator (#) is placed after the cell reference in a formula.

SQLServer connector

Row Zero now has a built-in SQLServer connector, so you can easily build connected spreadsheets that auto-update and write-back to SQLServer directly from your spreadsheet. See how to connect to SQLServer here.

View the full list of built-in data connectors.

Teradata connector

Row Zero now has a built-in Teradata connector, so you can seamlessly import and export data between your spreadsheets and Teradata. Everything built on connected data updates as source data is refreshed, including pivot tables, charts, formulas, etc. See how to connect to Teradata here.

Learn more about working with connected spreadsheets.

Connected data picker

We added a data picker that makes it easy to choose either a pre-built data source or an existing data connection. You can access it from the homepage by clicking Database query, or from a workbook via Insert > Connected table.

AI Chat now generally available

AI Chat is now available for Free, Pro, and Business users. AI Chat makes it easy to analyze massive datasets with natural language prompts and returns spreadsheet functions and features so analysis is fully auditable and editable.

Play video

Free, Pro, and Business users get a weekly allocation of AI tokens and access to our default model selection, which runs on Amazon Bedrock. Enterprise customers can “bring your own key” to connect workbooks to their AWS Bedrock, OpenAI, Anthropic, or Google Gemini account and work without daily limits. Learn more here.

New pivot table modes

Row Zero now has two modes for pivot tables, which you can select depending on your use case:

• The new Standard mode is best for final presentation of data and supports nesting fields, collapsible groupings, and subtotals.
• The Data table mode supports computed columns, filter/sort, and is best for transforming data and creating dynamic charts. Data table mode gives you the same pivot table experience you've had so far in Row Zero.

Here's a breakdown of the new functionality in Standard mode:

1. Built-in subtotals, nested fields, and collapsable groupings when you add multiple fields to Rows or Columns.

2. Standard mode supports cell references, so you can easily reference any cell in a pivot table in downstream formulas.

3. Standard mode lets you format individual cells in the pivot table.

4. You can freeze columns in Standard mode so you can keep row labels in view as you scroll right.

5. If you export a sheet to CSV, Standard pivot data is included in the export.

Learn more about the new pivot table modes.

350 built-in functions

We've added more than 100 new functions over the last few months across a wide range of use cases. Here's a breakdown of recently added functions:

• Logical: FALSE, TRUE, SWITCH, XOR
• Information: ISNONTEXT, ISREF, N, T, TYPE
• Date & Time: DATEDIF, TIMEVALUE, ISOYEAR
• Text: CODE, FIXED
• Math & Trig: CEILING.MATH, CEILING.PRECISE, DECIMAL, FLOOR.MATH, FLOOR.PRECISE, ISO.CEILING, LCM
• Engineering: BESSELI, BESSELJ, BESSELK, BESSELY, CONVERT, ERF, ERF.PRECISE, ERFC
• Statistical: BETA.DIST, BETA.INV, BETADIST, CONFIDENCE.NORM, CONFIDENCE.T, EXPON.DIST, FISHER, FISHERINV, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, GAUSS, HYPGEOM.DIST, HYPGEOMDIST, LINEST, MODE, NEGBINOM.DIST, NEGBINOMDIST, PHI, POISSON.DIST, STANDARDIZE, T.DIST.RT, TDIST, WEIBULL.DIST
• Financial: ACCRINT, ACCRINTM, AMORLINC, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, DB, DDB, DISC, DOLLARDE, DOLLARFR, EFFECT, INTRATE, ISPMT, MDURATION, NOMINAL, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PDURATION, PRICEDISC, PRICEMAT, RECEIVED, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, YIELDMAT

View all 350 spreadsheet functions here.

Comments

You can now add comments directly in a workbook. Right-click to add comments to cells, charts, and tables.

You can @ mention specific users, who will be alerted to new comments via the notifications bell in the top right corner.

You can also view all comments in a workbook by going to View > Comments in the navigation.

Charts show a yellow dot in context where the comment was added. Cells with comments have a yellow triangle in the top right corner. Both show the comment on hover.

Resolving a comment hides it in the sheet, but it will still show under "Resolved" when you view all comments so that you can track completed work.

Two-Dimensional MULTILOOKUP

We've updated our MULTILOOKUP function so that you can lookup across a row and column at the same time to return the intersecting value.

This is especially helpful for lookups in financial spreadsheets where you want to return a value from a given category row in a given month column and can be used in place of complex INDEX/MATCH or nested XLOOKUP formulas.