What’s New

24-Mar-2025 Update

Improvements 💪

• Bank account re-authentication! In our Bank Integration, accounts usually need to be re-authenticated every few months. Previously, that was done manually with a new authorization with the bank account, you needed to pick the account again etc. Now we support an easier re-authentication flow!
• Import Rows Table via URLs. So, a couple of weeks ago we shipped Rows Table, which is a new source for your spreadsheet that loads a table from another document. It has an easy, smart selector that even autocompletes spreadsheet names and table names. BUT NOW you can also just paste a spreadsheet url in the spreadsheet input and BAM. Done. Kind of got carried away in this description, but it's really really simple!
• Performance improvements: We have released big performance improvements on functions MIN, MAX, UNIQUE, FILTER_COLUMNS, FILTER. On a batch execution of 10.000 cells with each of those functions, the time to execute was cut by a minimum of 80% and a maximum of 98%. So, you know, a whole lot faster.
• We fixed 3 HubSpot data functions that were previously unable to use the HAS_PROPERTY filter operator. The affected functions are SEARCH_COMPANIES_HUBSPOT, SEARCH_CONTACTS_HUBSPOT, SEARCH_DEALS_HUBSPOT.
• The new Tab Navigation at the top has 3 improvements: 1) you can now drag Pages (tabs) to reorder them; 2) the title of the spreadsheet now has it's own settings, for renaming, deleting etc; 3) you duplicate or delete a Page element (Chart, Table) by right-clicking on the dropdown menu of a Page (Tab).
• On mobile devices, when you loaded certain spreadsheets, tables were rendering scrolled all the way to the right. We fixed that!

17-Mar-2025 Update

New Features 🤩

• New Tab Navigation 📑: You can now navigate any page of your spreadsheet using the new tab menu just above the formula bar. This is now the default navigation method, providing 15% more space for your data and a smoother exploration experience. You can still open that sidebar if you want it! This was inspired in ipadOS 18 Tabs.

Improvements 💪

• We've simplified the Data Action menu for a cleaner, more intuitive experience.
• We've upgraded our Quick Command (Cmd-K) search algorithm to deliver more accurate and relevant results.
• We improved processing of calculations, especially in sequential (A1:A1, A1:A2,.. A1:A10000). In a test scenario of 10k cells, calculation time went down by 75%.

10-Mar-2025 Update

New Features 🤩

• Dashboard layout 🖼️: you can now arrange charts and tables side by side, resize any element with a simple drag, and craft clean, organized dashboards.

Improvements 💪

• We shaved an additional 30% off the loading time for large spreadsheets.
• We've added a new error message to clarify that you can pull a maximum of 20 metrics per LinkedIn Ads action.

Fixes 🐛

• We fixed an issue where Data Tables collapsed when referencing a period with no data, causing potential issues with connected charts and tables. Now, the table stays put to maintain external references, displaying blank columns.

27-Feb-2025 Update

Import Rows Tables ⤵️ and PYTHON() 🐍

This week we shipped two major features (more on that below):

1. You can now use a Table of a spreadsheet in another spreadsheet
2. The PYTHON() function (Beta).

New Features 🤩

Ok, it's actually 5 new features!

1. You can now import a Table from any spreadsheet into any other spreadsheet. To do it, pick "Rows Table" as a source in the Data Action menu, choose the spreadsheet where the source Table is, and then the Table you want. Tables are automatically synced every few seconds. As with any other Data Table, you can filter the source, sort it, and pick columns.
2. Welcome to the PYTHON() function (Beta). Use it to leverage powerful data libraries and step up your analysis game. Support in our AI Analyst✨ coming soon 🔜.
3. We added a new AI✨ option when adding a column in Data Tables, to help you easily create Formula Columns with a guided prompt in the AI Analyst. On a Data Table, click + to add a new column, then pick AI✨.
4. We also added a new AI✨ action. You can now ask the AI Analyst✨ to change a cell or a group of cells. Change their values or change formulas by asking directly in the prompt!
5. You can now stop ongoing computation on tables by simply hovering and clicking on the spinning animation ↺. If the cells stopped contain Integrations, you can re-execute them later.

Improvements 💪

• We implemented this new Changelog under rows.com/docs. We think this is easier and faster to track.
• Syntax Highlight is now available whenever you need to write a SQL-like query for the QUERY formula, the BigQuery, Amazon Redshift, MySQL, PostgreSQL and Snowflake integrations. This makes writing complex queries easier and more error-free.
• We made Duplicating spreadsheets and installing Templates much faster. On a test spreadsheet with multiple tables and automations, we cut the duplication time by 97%, from 65s to 2s.
• We also improved the execution speed of FILTER. This will especially improve cells with a FILTER function that includes several conditions like in =FILTER(C:C,(B:B=B2)*(A:A=A2))). In our test scenario of 10k rows executions, the time to complete went down from 245s→8s, again a 97% reduction.

Fixes 🐛

• We fixed an issue that happened when referencing external cells in the Comparison setting of a Data Table.

19-Feb-2025 AI✨ Update

AI Analyst ✨ 3.7

The AI Analyst can now extract data from a URL.

You can now ask the Analyst to extract live data from an URL, such as meta data, product description or price information. Use the keyword ‘lookup’ to trigger our web research function.

Plus, the Analyst now provides a brief explanation of the action taken, giving you better context on how it answered your question.

18-Feb-2025 Update

New functions and performance improvement 🚅

You can now use new LOOKUP functions and faster QUERY.

New Features 🤩

• VLOOKUP finally got its twin, HLOOKUP! Use it when your comparison values are located in a row across the top of a table.
• You can now use XLOOKUP to search a range or an array and get the item corresponding to the first match.

Improvements 💪

• You can now import up to 10,000 rows of data from Google Search Console.
• We cut compute time by ~85% for conditional summing operations like SUMIF(S), COUNTIF(S), and AVERAGEIFS.
• QUERY and copy/cut & paste also got ~50% faster.
• You can now use shortcuts to Undo and Redo the Sort operation.
• You can now fetch Campaign Type and Campaign Objective fields from any LinkedIn Ads actions.
• FIND_FACT_OPENAI and SENTIMENT_ANALYSIS_OPENAI now deliver output with improved consistency in format and accuracy.

Fixes 🐛

• We fixed an issue that - in some cases - prevented properly listing all Ads from LinkedIn Ads Actions.
• In a few cases, due to multiple data retrievals, there could be discrepancies in LinkedIn Ads data when broken down by specific dimensions. Now it's fixed.
• The Copy/Paste shortcuts (CMD+C/CMD+V) did not work consistently on the side panel. Now it's been fixed.

03-Feb-2025 AI✨ Update

AI Analyst ✨ 3.6

The AI Analyst can now generate entire spreadsheets.

You can now ask AI Analyst to create entire spreadsheets from scratch—whether it’s a calculator, financial model, task list, or even a dataset with real or synthetic data.

Just click "Generate with AI" in the AI Analyst panel and go from zero to spreadsheet in seconds.

29-Jan-2025 AI✨ Update

AI Analyst ✨ 3.5

The AI Analyst can now handle custom API requests.

You can now ask the Analyst to connect to REST APIs and create columns that import or send data to third-party services such as ERPs, custom CRMs, lead enrichment tools and thousands of other web services.

The Analyst is able to execute our unique HTTP functions GET(), POST() and PARSE() to connect to the APIs and extract specific datapoints from its response.

22-Jan-2025 Update

More banks on your spreadsheets 🇨🇦

You can now pull balance and transactions from Canadian bank accounts.

New Features 🤩

• Our Bank Account integration now supports +160 Canadian banks 🇨🇦.

Improvements 💪

• You can now import data from Google Ads without limit.
• Charts use the aggregation option by default.
• You can now easily spot Data Tables by its integration icon on the sidebar.
• You can now pull the Ad Group Criterion property from the Google Ads integration.
• We removed the limit on the number of LinkedIn Ads accounts you can manage from our Data Table configuration menu.

Fixes 🐛

• The AI Analyst was not refreshing correctly after file imports. It's fixed.
• We fixed a cache issue that - in a few cases - did not allow users to see all integrations connected from their Setting section.
• The IMAGE() function returned the wrong error message when there was no image to fetch.
• In some cases, the shortcuts CMD+C/CMD+V were not working correctly on side panels

2023-2024 Changelog

📖➡️ Open on github.