Sign up for free
The Rows spreadsheet

What’s New

Discover the latest updates in Rows!

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!
  • 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.
  • 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.

AI Analyst 3.7

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.

AI Analyst✨ 3.6

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.

Copilot for custom APIs

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

31-Dec-2024 Update

Comparisons in Data Tables 🆚

You can now automatically add comparison columns to your Data Tables.

New Features 🤩

  • Add comparison columns to your Data Tables to easily assess metrics across different periods.

Improvements 💪

  • We simplified the experience of creating a Formula Column: you can now see a preview of the formula result in the first row, and rename the column by simply double-clicking on its header.
  • You can now add formatting and style to your Pivot Tables, making them clearer, more professional, and easier to interpret at a glance.
  • You can now import any CSV/XLS(X) file in the same spreadsheet page, replacing the selected table if empty or navigating to the new one.
  • When duplicating a spreadsheet, we added a link in the notification badge to immediately navigate to the duplicated file.

Fixes 🐛

  • We fixed an issue that prevented a correct refresh of the permanent filter of Data Table when referring to external cells.
  • In some cases, table's values disappear when trying to print/save as PDF from browser. Now it's been fixed.
  • We fixed an issue with the UPDATE_DATABASE_PAGE_NOTION action that returned an error when trying to update a number with decimals.

24-Dec-2024 AI✨ Update

AI Analyst ✨ 3.4

The AI Analyst can provide you with relevant suggestions for your table.

suggestions AI analyst 3.4

The AI Analyst can now help you kickstart your data analysis. Here's what's new:

  • Generate suggestions: Get up to five tailored ideas or actions to work with your data, like creating a weekly sales table or plotting a bar chart of CTR by campaign.

  • Explore AI capabilities: Instantly access a summary of AI Analyst features, including answering questions, adding columns, building charts, and formatting cells.

02-Dec-2024 AI✨ Update

AI Analyst ✨ 3.3

The AI Analyst is now more powerful, handling complex tasks with multi-step analysis.

Analyst 3.2

Here's what's new:

  • Independent operations: Create multiple unrelated outputs in a single prompt—like adding several columns or generating a series of charts.

  • Sequential operations: Build workflows where steps depend on each other—like adding a column and creating a chart based on that column.

26-Nov-2024 Update

Banking Integration 🏦

You can now import live data from your account in +12,000 banks in the EU and U

New Features 🤩

  • Import live balance and transactions from your account in +12,000 banks in the EU and US. Try it in our new templates: Personal Expense Tracker and Cash Flow template.
  • You can now apply permanent Sort and Filter to any Data Table and surface key insights from any data source.

Improvements 💪

  • We added extra space for your spreadsheets by removing our top bar (~25% more visible rows in a 13"" display). All the previous links are now discoverable under your workspace icon in the top left corner of your viewport. Access our templates by clicking in the bottom left corner of any spreadsheet.
  • Furthermore, we reduced the padding of our cell to fit even more content in your tables.
  • You can now interact with the Data Actions side panel by just selecting the respective table in your spreadsheet.

Fixes 🐛

  • We fixed an issue that happened with the accounts dropdown list in the Data Actions side panel when changing the default account connection.
  • In some cases, some parameters in the Data Actions panel required double confirmation post changes in the action configuration. Now it's been fixed.

15-Nov-2024 AI✨ Update

AI Analyst ✨ 3.2

This release includes new scenario and analysis capabilities.

Analyst 3.2

The AI Analyst can now build tables to answer complex questions, like finding goals, modeling scenarios, and doing multi-variate analysis.

  • Goal Seek: Solve reverse calculations, and find the numbers you need to reach a target. Examples: How many orders do I need to hit $100k, $500k $1M in revenue? or How many cookies should I sell to make $1M?

  • What-If Analysis: See what happens when a key metric changes. Examples: How does my revenue change if my margin increases by 5%? or What if I raise prices by 10%?

Now, the Analyst can create new tables where each cell is a formula, value, or text to solve problems like these. It’s great for building models, calculators, and plans, simply by asking.

31-Oct-2024 Update

Pixel-perfect chart resizing ↙️↗️

You can now resize your charts by simply dragging an icon in the bottom right corner

New Features 🤩

  • Resize charts by dragging to create polished reports effortlessly.
  • Retrieve keywords data from Google Ads with our new function GET_KEYWORD_METRICS_GOOGLE_ADS.
  • Make your spreadsheet more powerful with three new functions: MINIFS, to calculate conditional minimum from a series of number, OFFSET to return a specific cell n-row and m-column away, and TEXTJOIN to combine the text from multiple ranges/arrays using a delimiter.
  • Apply permanent sorting to Data Tables, by clicking on the Integration icon in the top right corner.

Improvements 💪

  • Quickly access source tables for Pivot and Data Tables with a new shortcut.
  • Pie charts now configure faster for easy data plotting.

Fixes 🐛

  • We fixed a issue where changing a series to ""line"" on the right axis in Combo Charts affected the left axis series incorrectly.
  • In some cases, you may have experienced formatting issues with data copied from Numbers/Excel/Sheets. Now it's been fixed.
  • Pasting data from Excel or Rows now accurately targets the selected range.
  • Changing data range from chart did not preserve deleted series from the plotting area. Now it's been fixed.
  • In some cases, you may have found issues in connecting multiple Instagram creator accounts to your spreadsheet. Now it's been solved.

30-Oct-2024 AI✨ Update

AI Analyst ✨ 3.1

This release includes 3 new features and 1 big improvement in the Analyst’s accuracy.

Analyst 3.1

This release comes with 3 new features and 1 big improvement in the Analyst’s accuracy:

  • Clear Chat: Easily reset the conversation with the Analyst by clearing the current chat and starting fresh.
  • Sample Dataset: Dive right into the Analyst's capabilities by loading a sample dataset from an empty table — perfect for quick exploration.
  • Chart Aggregation: The Analyst can now create charts with aggregated values (e.g., sum, count, average, median) for data points that share the same x-axis values, for more insightful visualizations.
  • Smart Retry: When the Analyst encounters an issue responding to a prompt, it now automatically self-assesses the error and tries again for smoother interactions.

25-Sep-2024 AI✨ Update

AI Analyst ✨ 3.0

Our biggest AI update yet, with data analysis and copilot capabilities.

Analyst 3 FRA-min

We just released the biggest AI update in the last 15 months. It's a completely new Analyst rebuilt from the ground up to be a smarter, faster and a more versatile data analyst for your spreadsheets.

New capabilities

You can now ask AI to perform several new actions, including:

  1. Get answers: Get direct answers to your business questions.
  2. Add Tables: Extracts trends, generate pivot tables, and slice the data.
  3. Create Charts: Turn numbers into visual stories just by asking.
  4. Add columns: Insert new calculated columns to expand your data.
  5. Enrich data: Add new datapoints to your tables with rich data columns.
  6. Format cells: Apply formats & styles that clean up your datasets.

Watch our demo and check out our guide.

24-Sep-2024 Update

JSON handling improvement </>

We added a new way to import JSONs and visualize them as tables

New Features 🤩

  • You can now generate a Data Table from a JSON just by copying its content in the respective JSON option under the ""Import data from..."" section of the Data Actions panel
  • You can now use three new functions:
    • FROM_JSON: converts a JSON string into a JSON object.
    • REGEXREPLACE: replaces part of a text string using regular expressions.
    • TRIM: removes white spaces from a string.

Improvements 💪

  • You can now quickly remove all the links of an entire selected range using the keyboard shortcut or the command in the contextual menu.
  • We added a shortcut in the Data Actions modal to create a Data Table from a data range.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • In some cases, the Date Range input in the Data Action panel adds numbers while trying to delete. Now it's been fixed.
  • Navigating to View mode with the chart panel opened prevented the spreadsheet from using the full viewport. Now it's been fixed.
  • We fixed an issue that displayed an unexpected error in the Data Source icon of embedded Data Tables.
  • In some cases, cells with very long text could not enter edit mode unless scrolled. Now it's been fixed.
  • When dismissing a dropdown list by clicking elsewhere, in some cases the value gets pasted. Now it's been fixed.

10-Sep-2024 Update

New functions 🧠

You can now use a bunch of new functions, including FLOOR, CEILING, REPT and SWITCH

New Features 🤩

  • You can now select different TikTok accounts in the Data Actions flow, in order for you to build reports including multiple properties.
  • You can now use:
    • FLOOR and CEILING to round numbers down or up to their closest multiple of a factor.
    • SWITCH to compare a value with a list of cases.
    • REPT to repeat a specified text a given number of times.
    • ISNUMBER to check whether a value is a number.

Improvements 💪

  • You can now quickly add a new connection from the bottom of the respective dropdown list in the Data Action panel.
  • We added a shortcut to generate a Data Table from a function directly from the Import Data section of the Data Actions panel.
  • We improved our Plans & Billing page, to let you understand more clearly the usage of Integrations, AI Analyst (including Subtitles), and Rows API.

27-Aug-2024 Update

Chart Aggregation 📈

You can now aggregate series with same-value on one axis, using common math functions

New Features 🤩

  • You can now use SUM, COUNT, MAX, and other operators to aggregate same-coordinate data on your charts.

Improvements 💪

  • We added a contextual menu to chart annotations, for you to quickly reach more settings with just a double click.
  • Not a big fan of selecting your chart data source manually? You can now pick the table that backs your graph from a dropdown list.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • Choosing a non-default connection when using an integration led to a misnamed table. Now it's been fixed.
  • In some cases, Data Tables could not be created using different connections than the ones already available in the spreadsheet. Now it's been fixed.
  • We fixed an issue that prevented the Data Tables column from keeping the format when the data was refreshed.
  • We fixed a glitch that duplicated the labels of the available accounts in the Data Action picker.

20-Aug-2024 Update

Chart annotations ✏️ 📊

You can now highlight and leave a note on single data points on a chart

New Features 🤩

  • You can now highlight with different colors single data points on a line, bar and scatter plots charts, and add a label to them. It's great to add info and improve your chart narrative.

Improvements 💪

  • To use one of our integrations, you can now pick the desired associated account directly from a drop-down list at the top of the Data Actions panel.
  • You can now select the desired data range for your charts from a simple dropdown list, where all the tables are organized by page.
  • We made it extra easy to plot selected data ranges on a Pie Chart, by improving the default display of labels and series.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that in some cases generated 404 errors with the GET_PAGE_POSTS_METRICS_FACEBOOK function
  • We fixed an issue that prevented to display of current day posts via Facebook functions.
  • Charts did not render properly when referencing a table from another page or outside the viewport. Now it's been fixed.

31-Jul-2024 Update

New functions 🧮

You can now level up your analysis with PERCENTILE, QUARTILE, SKEW and SORT

New Features 🤩

  • You can now use PERCENTILE, QUARTILE, SKEW and SORT to level up your spreadsheet analysis.

Improvements 💪

  • You can now create a Data Table from any formula, such as QUERY and RANGE2JSON. Support for nested formulas coming soon.
  • We redesign the shortcut to edit any Data Table by making extra easy to reach the data request, automation and table layout options.
  • You can now use COUNTUNIQUE to aggregate values in Pivot Tables.
  • You can now Paste anything from the clipboard in View mode using the right-click contextual menu.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed a glitch that prevented to scroll up the list of values when reordering columns in Data Tables' layout menu.
  • We fixed a issue that prevented some users to pull big amounts of data from the Facebook Ads integration.

23-Jul-2024 Update

Version Autosave 🕒

Version history now autosaves your spreadsheet every 5 minute

Improvements 💪

  • Version history now autosaves your spreadsheet every 5 minutes, holding a maximum of 7 snapshots saved per day.
  • You can now rename a saved version of your spreadsheet in the history menu.
  • Elements in Pivot Tables can be now reordered among rows, columns and values with drag&drop.
  • With GET_VIDEO_METRICS_TIKTOK you can now retrieve KPIs of single TikTok videos
  • You can now refer to another cell in any Formula Column's name.
  • You can now select unbounded date ranges when pulling data from our data integrations (e.g. 'Since' 2024 will return '>=2024').
  • You can now choose 'This year' to filter data from integrations for the current year.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an error that happened to guests when opening the Version History panel.
  • In presence of frozen headers, wrapping text failed to adjust the width of a column accordingly. Now it's been fixed.
  • We fixed an issue that prevented to fully see long axis labels of bar charts.
  • We fixed an issue that prevented data table to keep the chosen date format upon refresh.
  • We solved an issue that happened when selecting CTR as a metric in the function GET_ACCOUNT_INSIGHTS_LINKEDIN_ADS.

02-July-2024 Update

Version history ⏳

You can now manually save and restore a previous version of your spreadsheet

New features 🤩

  • With Version history, you can now manually save and restore a previous version of your spreadsheet. Autosave coming 🔜

Improvements 💪

  • We added several new TikTok ads functions to let you pull granular data about your ads performance, namely: GET_AD_METRICS_TIKTOK_ADS, GET_CAMPAIGN_TIKTOK_ADS, GET_ACCOUNT_METRICS_TIKTOK_ADS, GET_ADGROUP_METRICS_TIKTOK_ADS, GET_ADGROUP_TIKTOK_ADS, GET_ADVERTISER_TIKTOK_ADS, GET_AD_TIKTOK_ADS
  • We improved our Easy Adding experience with a tooltip that specifies where the table will be added: regular click to add it below the element in focus, option-click to add it above.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • In some cases, impressions were not returned in our GET_POST_METRICS_INSTAGRAM function. Now it's been fixed.
  • We fixed an issue that sometimes prevented the creation of new rules in Conditional Formatting.
  • In a few cases, opening the Options menu of a chart will cause the page to scroll unexpectedly, missing the right focus. Now it's been fixed.

20-Jun-2024 Update

TikTok Ads integration 🎥

You can now pull Ads metrics from your TikTok account and enable conditional formatting on text

New features 🤩

  • We rebuilt the process for configuring integrations on templates from the ground up: you can now connect your account and pick the desired properties in a single flow before landing on a fully working template.
  • With the new TikTok Ads integration you can pull insights from your campaigns directly on the spreadsheet.
  • With the new GET_FOLLOWER_GAIN_LINKEDIN you can get the number of followers gained on your pages over time broken by paid and organic.

Improvements 💪

  • Conditional formatting now works with custom colors and text conditions.
  • You can now use custom colors in any chart.
  • When embedding an element, you can now choose to share only the single element or give access to the whole spreadsheet.
  • We added an intermediate menu to make it extra clear what you can do to edit your Data Table: amend your Data Request, Schedule Automation or Adjust Columns and format.
  • You can now add a new element (table or chart) by clicking on the plus button next to the top left corner of any elements.
  • Pivot tables can now show/hide totals for columns and rows.
  • We improved the way drag&drop works to order charts and tables in the left navigation menu.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • Charts generated from pivot tables display wrong formats on the X-axis. Now it's been fixed.
  • In some cases, our Google Sheets Import function picked the wrong range. Now it's been fixed.
  • In a few cases, opening the Options menu of a chart will cause the page to scroll unexpectedly, missing the right focus. Now it's been fixed.

04-Jun-2024 AI✨ Update

Gpt-4o✨

All our OpenAI functions use the latest gpt-4o model by default.

New features 🤩

  • All our OpenAI functions now utilize the latest GPT-4o model, ensuring your extraction, classification, and cleanup tasks are faster and more accurate than ever before.
  • You can now resize charts using three different sizes and reorder them in your reports by dragging them vertically and horizontally.
  • With the new SEARCH_VIDEOS_YOUTUBE function you can retrieve metrics about your YouTube videos.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • In some cases, the table content disappeared momentarily while switching browsers' tabs. Now it's been fixed.
  • We fixed an issue that prevented dragging and dropping elements from the sidebar to an empty page.
  • We fixed a visual glitch that happened to tables' rulers when trying to reorder a column.
  • Our ADD_OR_UPDATE_RECORD_AIRTABLE in some cases failed to update a record. It's been fixed.
  • The Auto Beautify toggle of Data Tables now preserves its status once entering the edit mode.
  • We fixed a collision between the Pivot Table panel and the Data Actions menu.
  • In some cases, Notion rollup properties were not retrieved correctly by our functions. Now they work just fine.
  • We fixed a visual glitch that happened when scrolling big tables with frozen rows.

23-May-2024 Update

New TikTok integration 📣

You can fetch valuable insights from your TikTok account, such as followers, following and video metrics

New features 🤩

Improvements 📚

  • We added a dimension parameter in our GET_ACCOUNT_METRICS_INSTAGRAM to allow for a more insightful analysis of your Instagram performance

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that happened with our GET_CONTACTS_FROM_LIST_HUBSPOT function
  • Some users faced an 'invalid account error' when using our Google Ads integration. Now it's been fixed.

30-Apr-2024 Update

Drag elements ↕️

You can now reorder charts and tables vertically by dragging them

New features 🤩

Improvements 📚

  • We added a metric dropdown to our GET_PAGE_METRICS_LINKEDIN to make it extra easy to configure a custom report.
  • We powered up our GET_POSTS_LINKEDIN function with post insights, to make it extra easy to track the performance of your LinkedIn page.
  • We improved our Hubspot functions by adding support for has_property and not_has_property filters.
  • We open sourced RowsX under the MIT license. Check out our GitHub repository to get started and discover our Open Bounties Program.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that in some cases prevented our Google Ads integration from using valid setups.

18-Apr-2024 Update

New Pricing Plans 🤑

We simplified our paid plans and moved to a per-user basis

New features 🤩

We simplified our paid plans and turned them into a per-user basis:

  • Free: Enjoy access to all integrations with a limit of 50 executions per month. Invite unlimited members and up to 10 guests to your workspace.
  • Plus: Priced at $15/month/user. This plan offers unlimited integration tasks, hourly data refresh, unbranded embed and up to 25 guests.
  • Pro: Priced at $22/month/user. This plan includes unlimited integrations, minute-by-minute data refresh, unbranded embed and up to 100 guests.
  • Enterprise: Upon request. This plan includes unlimited guests, custom integrations and advanced API endpoints.

Discover more

16-Apr-2024 Update

New Formula Column UX 🎨

You can now enjoy an easier formula column UX plus leaving a comment at the spreadsheet level

New features 🤩

  • You can now leave a comment and engage in conversations with your team mates at the spreadsheet level.

Improvements 📚

  • We improved the experience to create a Formula Column, offering a list of preset popular functions, such as SUM, AVERAGE and COUNT. Once the formula is picked, you can easily select its values from a list of all table's columns names.
  • Date-picker fields now support all new date-time formats.
  • You can now use the right arrow key on any Data Table to add a Formula or regular column.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that, in some cases, prevented the correct inheritance of the percentage format.
  • In a few cases, downloading a table as a CSV led to an error. Now it's been fixed.
  • We fixed an issue that prevented a correct import of Excel files into Rows.

10-Apr-2024 AI✨ Update

AI Analyst✨ V2.0

AI-generated subtitles for tables and charts.

Analyst 2.0

New capabilities

You can now ask AI to generate tables and charts’ subtitles, including the key insights and eye-popping stats from the data. Select the Add subtitle option in a Chart or Table and press Enter. AI does the rest.

02-Apr-2024 AI✨ Update

AI Analyst✨ V1.4

Suggested questions and smarter replies.

GJ1v8boWwAAz5u7

New capabilities

  1. Suggested questions:

The Analyst now suggests a list of contextual questions to ask from the dataset, to give your a few ideas to get started.

  1. Smarter replies:

We upgraded the Analyst ability to answer all types of questions. It has now a broader awareness of the dataset, including data types, formats, and key variables.

02-Apr-2024 Update

Introducing comments 💬

You can now leave a comment on any table or chart, in both View and Edit modes

New features 🤩

19-Mar-2024 Update

GA4 preset reports and Point & Compose across pages 📊

You can now select presets for GA4 and build formulas using Point & Compose across different pages

New features 🤩

  • You can now select Google Analytics 4 presets from the Data Actions menu and create a report in as few as two clicks.
  • You can now build formulas using Point & Compose to refer to cells from different spreadsheet pages.

Improvements 📚

  • You can now Import data from Google Sheets using Google's picker to select your files.
  • We reorganized the Data Actions flow to make it extra easy to connect your data sources and pick your account.
  • We added the option to inspect the output of any data action before creating the table, for you to check the actual content and select only single data points.

04-Mar-2024 Update

Google Ads integration and more date formats 📅

Introducing a new Google Ads integration and 13 new date-time formats

New features 🤩

  • Google Ads integration: you can now pull data directly from your account, including click-through rates (CTR), conversion rates, ad spending, keywords performance, audience demographics, and geographical performance of the ads.
  • You can now combine 13 new date-time formats, including “day, month name, year”, “year-week” and “12-hour time”. 

Improvements 📚

  • We reduced by 20% the width of the right-end side panel, used to set up Data Actions, Charts, conditional formatting, etc, to give you extra room to analyze your data on the grid.
  • We made clearer the way you can output data from an integration, by adding a final step before generating any Data Table.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that, in the presence of cell of different heights, prevented users from editing with keyboard cells without scrolling.

20-Feb-2024 Update

New SUBTOTAL, ISBLANK and STDEVP functions 🔢

Your spreadsheets can now be upgraded with new powerful functions

New features 🤩

  • Use SUBTOTAL() to apply 11 filter-sensitive operations (such as average, sum, and variance) to any range, while ignoring hidden rows.
  • Use ISBLANK() to check if a cell is empty.
  • Use STDEVP() to compute the standard deviation of a population.

Improvements 📚

  • We added support for the ""in"" (""not in"") operators to our Hubspot functions, to check for the presence (absence) of a value within a collection

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that happened with our GET function when the input endpoint had accents.
  • We fixed an issue that happened when trying to connect our GA4 integration for the first time with Safari.

06-Feb-2024 Update

New HYPERLINK, MID, PROPER and other functions 📟

You can now power up your spreadsheets with a bunch of new powerful functions

New features 🤩

  • Use HYPERLINK() to generate a hyperlink inside a cell based on a URL and a user-defined label
  • Use MID() to extract a portion of a string, where the starting point and length are user-defined.
  • Use RANGE_CONTAINS() to check whether a value exists in a range.
  • Use PROPER() to make the first letter for each word in a string uppercase.
  • Use CODE() to return a numeric code for the first character in a text string, that corresponds to the character set used by your computer.
  • Use CHAR() to convert a code number to a readable character.

Improvements 📚

  • You can now use Col1, Col2,... clauses to refer to columns in nested QUERYs
  • Our spreadsheets now open in Edit mode by default. Live mode is now called View

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that in some cases broke cell references in imported .XLS files.
  • Searching for companies, deals, or contacts via our Hubspot integration in some cases led to a 429 error for bulk requests. Now it's been fixed.

30-Jan-2024 Update

Hide rows and columns 👻

You can now hide any row and column from your tables.

New features 🤩

  • You can now hide any column or row by right-clicking on its header's contextual menu.

Improvements 📚

  • We added support for Point&Compose in the formula bar: you can now build your functions referring to any cell both from the grid and the top bar.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that in some cases prevented to show decimals in numbers formatted with thousand separators.

19-Jan-2024 Update

Quick Command 2.0 ⌨️

A new UI, better search results and an option to navigate tables and pages instantly.

12

New feature 🤩

Our Quick Command experience got revamped from the ground up with a clearer UI, better search results and a 'Go To' command, to navigate tables and pages as fast as you can type. Try it typing command + K (⌘K) on your keyboard.

19-Jan-2024 Update

Custom color picker 🎨

Personalize your spreadsheets with your favorite colors.

color-picker

New feature 🤩

You can now add your brand colors to the text or fill color of any cell. Soon to Charts, too!

18-Jan-2024 Update

RowsX 🌐

Import tables and lists from thousands of websites into Rows in one-click.

RowsX

RowsX 🤩

Introducing RowsX, a Chrome extension that detects tables and lists on any webpage and lets you import them into Rows in one-click. Download it here.

17-Jan-2024 Update

Side-by-side charts 📈📊

You can now arrange charts side-by-side.

Side by side

New features 🤩

You can now arrange charts side-by-side, and build a new dashboard layout. Stay tuned for more updates that will make your reports pop 💅

16-Jan-2024 Update

AI Smart fill 🪄

You can now continue any series of numbers, dates or words by simply dragging the first two values.

smart fill

New features 🤩

  • Rows now detects patterns behind series of number, dates and even words and lets you fill the entire column just by dragging the first two values. Be it a quadratic series, the first day of a month or a list of capitals.
  • You can now paste the format of any cell, either through a option in the contextual menu or the shortcut ⌘ ⌥ V

Improvements 📚

  • We released a new version of our Hubspot integration, with a simplified setup, improved filters for searching and importing data, and increased limits for results.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • Our LinkedIn page returned an unexpected error when retrieving some pages' posts. Now it's fixed.

09-Jan-2024 Update

New currency formats 💴 and XLS import 🗳️

You can now add new currency formats to your spreadsheets and start off from your .XLS files

New features 🤩

  • We expanded our catalog of currency formats, adding ¥, ₹, ₿, and many more
  • You can now import .XLS files into Rows and start from where you left off.

Improvements 📚

  • We redesigned the OpenAI section of our Data Actions menu: you can now navigate it based on your role, and try out each function with interactive examples
  • We released a new version of our Facebook Ads integration improving the way you can pull metrics, especially conversions, actions (e.g. leads), and costs.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • Refreshing data containing hyperlinks in a Data Table failed to upload the underlying URL. Now it's fixed.
  • We adjusted the behavior of our INDEX to replicate Google Sheets' and prevent #VALUE! error from occurring unexpectedly.
  • We fixed an issue that caused the current dashboard to crash after removing a user from another workspace.
  • We fixed an issue that could happen when importing some .XLSX files, where numbers with decimals got trimmed to the displayed figures instead of including all of them.
  • In some cases, the page and cell failed to scroll down properly to allow for editing very long content. Now it's fixed.
  • When hovering a SCHEDULE function, in some cases the tooltip mentioning the last and next refreshes failed to load. Now it's fixed.

16-Nov-2023 AI✨ Update

AI Analyst✨ V1.3

Support for growth trends and forecasts.

Time series 2

New capabilities

Support for growth trends and forecasts

The Analyst can now handle time series and answer questions about historical growth trends and forecasts. Explore queries like ""What's the compounded growth rate of impressions over the last 5 days?"" or ""What's the expected number of clicks in the next 3 days?"".

15-Nov-2023 Update

New OpenAI functions ✨

You can now use OpenAI on a wider range of tasks, thanks to ten new functions

New features 🤩

We expanded our OpenAI catalog with 10 new functions, to help you automate your spreadsheet even more:

Improvements 📚

  • We redesigned our CLASSIFY_OPENAI, FIND_FACT_OPENAI, and APPLY_TASK_OPENAI from the ground up, to deliver more stable and accurate results.
  • Our GET_FOLLOWERS_TWITTER and GET_FOLLOWING_TWITTER functions will now return the number of followers and following directly in the cell, without requiring any other table transformation.
  • We changed the charts' footnotes format and made them easy to read.
  • We improved the Google Sign-in experience after a spreadsheet invite.
  • We added a shortcut to Filter and Sort in the top right corner of any Pivot table
  • Now you can use a convenient dropdown to select the Notion database to import.
  • We updated the authentication method of the existing Airtable integration, to follow the OAuth 2.0 PKCE standards.
  • You can now scroll big tables while selecting and dragging headers and cells.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • In some cases, deleting pages from duplicated spreadsheets returned an error. Now it's been fixed.
  • Copying cells from the contextual menu did not render a dashed border, compared to the shortcut. Now it's been fixed.
  • We fixed an issue that prevented selecting a wide horizontal range of cells in big tables.
  • We fixed an issue that happened with our Instagram integration, whose dropdown did not display all the available accounts.
  • Applying the 'Plain text' format twice to a date-formatted cell, changed the format to number. Now it's been fixed.
  • When referring to a cell out of the viewport, the grid failed to follow the selection, scroll, and display the selected cell. Now it's been fixed.

17-Oct-2023 Update

Notion Integration ⚽

Search and import any Notion database to Rows

New features 🤩

  • With the new Notion integration you can now take your Notion game to the next level: import and sync any database on your Notion docs to Rows, create charts, and Embed back to Notion. Watch our demo.

Improvements 📚

  • We increased the limit of footnotes and subtitles in tables and charts to 400 chars.

Fixes 🐛

We've made sure the following things won't bother you anymore:

  • We fixed an issue that happened when using percentage elements in dropdown lists.
  • In some cases, Ctrl+left-click on Safari failed to activate Rows contextual menu. Now it's been fixed.
  • Some dropdown lists failed at displaying new added options properly. Now it's been fixed.
  • Running PostgreSQL queries with empty output resulted in prolonged loading status. Now it's been fixed.
  • When adding a table above a chart, in some cases, the chart stopped displaying data until page refresh. Now it's been fixed.
  • Selecting content in formula bar missed numerical parameters, generating potential copy/paste mistakes. Now it's been fixed.
  • URLs were not automatically recognised in Data Tables. Now it's been fixed.

With ❤️, the Rows team!

🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.