"Add-ons for Google Sheets" category, page 2

Video: how to consolidate data from multiple Google sheets by common columns

This video shows how to merge several Google sheets into one and calculate all numbers from the same columns at the same time. With a handy add-on that we offer, you won't have to open each file and copy-paste data manually anymore. Continue reading

Video: how to combine duplicate rows in Google Sheets

This video shows how you can merge and consolidate rows with duplicate data using the Combine Duplicate Rows add-on. Three simple yet advantageous steps will let you select data and pick columns to merge or concatenate. Continue reading

Video: how to vlookup multiple values in Google Sheets

This video tutorial shows the easiest way to vlookup by multiple criteria in Google Sheets. The add-on finds all matches and pulls data from another sheet as values or as ready-made Google Sheets QUERY formula. Continue reading

Video: how to merge 2 Google sheets

This video tutorial explains how to keep your Google Sheets tables up-to-date with the Merge Sheets add-on. The tool will scan two tables for matches and do a quick vlookup. It will update old records, add missing info, and pull new rows and columns to your main table. Continue reading

Handy tools to manage text in Google Sheets

Despite lots of perks offered by Google Sheets, it also has its drawbacks. A clear example of that is the shortage of simple tools to manage text. Are we bound to add or replace text in Google Sheets manually or with complex formulas? Not anymore. :) We've filled this gap with simple one-click tools. Allow me to introduce them to you in this blog post. Continue reading

Convert formulas to values in Google Sheets

In this article, you will learn about two ways of replacing all formulas with their results in a spreadsheet. Continue reading

How to split cells in Google Sheets to columns and convert columns to rows

If you ever needed to split text from one cell into separate columns or turn the table around so that columns become rows, this is your lucky day. Today I'm going to share a few quick tips on how to do that. Continue reading

Calculating time in Google Sheets: subtract, sum and extract date and time units

It's time to talk about the ways of calculating time in Google Sheets. We'll discuss the ways of finding time difference in detail, see how to sum dates and time together, and learn to display only date or time units and set them apart completely. Continue reading

How to combine duplicate rows, merge values, and add subtotals in Google Sheets

Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading

How to Automate Your Spreadsheets with Zapier

Spreadsheets today aren't just static documents with data carefully managed on one computer. With Google Sheets and Excel's companion web app, your spreadsheets can get work done while you're away. Learn how you can automatically pull your data into a Google Sheets spreadsheet and set up workflows with Zapier. Continue reading

Video: How to merge cells and preserve original values in Google Sheets

See how you can quickly combine the cells with all their data in Google Sheets. Join text in columns, rows, or ranges with simple and flexible settings that our free add-on offers. Continue reading

Advanced search and quick replacements in Google Sheets

Learn about our recent addition to Power Tools that lets you perform advanced search in the entire spreadsheet, export rows with all found values, and replace any records you need. Continue reading

Video: How to remove duplicates in Google Sheets

Learn how to work with Remove Duplicates add-on for Google Sheets: quickly find unique entries, compare two columns or even tables for duplicate rows. Continue reading

How to count cells by color in Google Sheets

If you color-code your data in Google Sheets, you've probably noticed the lack of standard formulas that summarize this kind of information. In this article you will learn how to use our add-on to count and sum cells by color. Continue reading

Ablebits add-ons go to the cloud

Have you heard the news? Ablebits add-ons are now available in the new Google Sheets. Use this exclusive opportunity to try out your favorite tools in the cloud for free! See the first add-ons that made the move and let us know what you think. Continue reading

Ukraine flag War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.