"Add-ons for Google Sheets" category

Merge two Google sheets: update cells, add related columns & non-matching rows

Did you know that when you merge 2 Google sheets you can not only update records in one column but also pull whole related columns and even non-matching rows? Today I will show you how it's done with VLOOKUP, INDEX/MATCH, QUERY functions and the Merge Sheets add-on. Continue reading

Merge two Google sheets: lookup, match and update records

Today's blog post features all ways to merge 2 Google Sheets. You will use VLOOKUP, INDEX/MATCH, QUERY and Merge Sheets add-on to update cells in one sheet from records from another one based on matches in common columns. Continue reading

Video: Format your tables in Google Sheets using Table Styles add-on

Make a statement with your Google Sheets tables using the updated Table Styles add-on! 50+ supplied styles, the ability to edit each or create your own style templates. Set font, colors, borders & other formatting, apply styles by parts – even the tailor-made tables now won't be left behind. Continue reading

Video: How to protect & unprotect multiple Google sheets in bulk

In this video, you'll learn one new feature our Sheets Manager introduced to Google Sheets: protect more than one Google sheet at the same time. Of course, the option to unprotect multiple Google sheets is included. Come take a look. Continue reading

Video: How to move multiple Google sheets to new, existing or several separate spreadsheets

Have you ever tried to move – cut & paste – Google sheets from one file to another? There's no such option available in spreadsheets. But it doesn't really matter if you have Sheets Manager at hand. It knows how to split your Google spreadsheet by tabs or simply move multiple tabs to a new or the existing file at once. Continue reading

Video: How to copy multiple Google sheets to the current, new, existing or several separate spreadsheets

In today's video, I'll show you why Sheets Manager is a better alternative when it comes to copying multiple Google sheets. You'll see the handiest way of duplicating several tabs and, what's more, learn how to copy them into multiple separate spreadsheets in one go. Continue reading

Video: How to lock several Google sheets, copy them, hide/unhide, move, etc. with a special add-on

Though Google Sheets offers its ways to process multiple tabs, there's a faster and user-friendly solution I'd like to share – our Sheets Manager add-on. It even knows a few tricks you won't cover with standard tools. But please, don't take my word for it – come watch today's video to see for yourself.  Continue reading

Video: How to extract data from Google Sheets cells

If you haven't tried our Extract Data add-on for Google Sheets yet, this video will make up your mind. See how easy it is to extract links, email addresses, numbers and text from different positions of multiple Google Sheets cells at once. Continue reading

How to split one Google sheet or spreadsheet into multiple separate tables or files

When you work with a large Google spreadsheet, you may find yourself constantly filtering the table to get only particular datasets. Wouldn't it be best to split all info into multiple separate sheets or even files in Drive? If so, today I invite you to split your sheets and spreadsheets together. Pick the way you want to get your data and follow the steps described there. Continue reading

Video: How to replace special characters in Google Sheets

There's a small add-on for Google Sheets we offer that proves itself super useful. See how it quickly replaces accented characters, smart quotes with straight ones, codes with their symbols and vice versa. Continue reading

Video: How to count colored cells in Google Sheets

If you haven't tried our Function by Color add-on for Google Sheets yet, you will be pleasantly surprised. It calculates values based on their font, fill, or both colors using 13 aggregation functions. Today's video will show you how it works. Continue reading

Video: remove the same characters and substrings from multiple Google Sheets cells

Today's video is all about getting rid of unwanted text from several Google Sheets cells at once. You'll see how our Remove Text add-on removes specific characters and various substrings from different positions in cells. Continue reading

Extract data from Google Sheets cells: text, numbers, URLs, hyperlinks, email addresses, dates, and time

This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading

Video: how to add text to multiple Google Sheets cells

We have plenty of useful add-ons to manage text in spreadsheets. Add Text is one of them. Watch today's video to learn how to insert the same text to multiple Google Sheets cells: at the beginning & at the end of cells, after the Nth character, before/after a certain text string. Continue reading

Video: how to split cells with text to multiple columns in Google Sheets

Yet another splitting instrument for your Google spreadsheet toolset: Split Text add-on. It splits cells in Google Sheets by multiple delimiters at once, by text strings, by the desired position, and even by capital letters. Come see for yourself ;) Continue reading

Video: how to split cells with names in Google Sheets

Come take a look at our Split Names add-on for Google Sheets. It's much more powerful than the standard Split text to columns tool for it separates first, middle and last names, and recognizes more than 80 titles and 40 post-nominals in any name combinations. Continue reading

Video: how to change case in Google Sheets

When it comes to changing cases in Google Sheets, formulas are hardly the best option. Come take a look at a small utility that changes cases in your entire selection on the fly. Continue reading

Video: how to enable formulas built by the Combine Sheets add-on

If you're about to pull data from multiple Google sheets into one using our Combine Sheets add-on, you will most likely try to get the result as a formula to keep it in-sync with the original tables. This video features 2 important steps you have to take before that formula starts working for you. Continue reading

Video: how to pull data from other Google sheets into one table

Today's video features the easiest way to combine numerous Google sheets into one. Combine Sheets add-on brings data from different documents and common columns together, keeps your formatting, and automatically supplies the resulting table with the up-to-date info from the source sheets. Continue reading

Video series: 3 quick ways to merge multiple Google sheets

There's a perfect solution we all seek to combine data from multiple sheets: open the table, make 3 mouse clicks at most, and get the exact desired result without any extra tools or adjustments. But until there's an AI like in movies, we have to use other software at hands. Today I will show you 3 powerful add-ons that will help you combine several Google sheets into one. Continue reading

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