Webinar: How Enterprises like AWS are Closing the Spreadsheet Security Gap
Explore the latest updates from Row Zero.
Folders
We’re adding support for folders to organize workbooks.
Google Slides integration
We’re adding the ability to insert refreshable Row Zero charts into Google Slides.
Aggregations and filters for data sources
We’re adding drop-down filters for any column in a data source, allowing users to filter beyond predefined query variables. Users will also be able to aggregate data by selecting a column and choosing functions like sum or average.
We’ve added support for international dates, currencies, and number formats. Set your workbook locale by going to File > Settings > Locale and selecting your locale.
Workbook locale impacts formulas, numbers, and dates as well as the dropdown formatting options.
You can now import multiple CSV files at a time. Simply select multiple files during import and the files will combine into one sheet.
You can now sort by color in filtered ranges and data tables.
Sorting by color is useful for workflows where you want to pull color-coded rows to the top for review and is particularly powerful when combined with conditional formatting that automatically color-codes your data.
We’ve added new controls for expanding and collapsing pivot table fields. Right-click to expand/collapse by group, field, or the whole pivot.
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.
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.
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.
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.
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 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.
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.
Get started with Row Zero
