'Google Sheets add-ons' category archive

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

INDEX MATCH in Google Sheets – flexible Vlookup for your spreadsheets

When you need to find data in your sheet that corresponds to a certain key record, it is usually Google Sheets VLOOKUP you turn to. But there you go: VLOOKUP slaps you with limitations almost immediately. That's why you'd better increase the resources for the task by learning INDEX MATCH. Continue reading

Google Sheets QUERY function: a spreadsheet cure-all you have yet to discover

If you've been following this blog for a while, you may remember QUERY. I mentioned it as a possible solution for a couple of cases. But those are far from enough to uncover its full potential. Today, it's high time we get to know this spreadsheets superhero properly. And guess what – one equally noteworthy tool will also be there :) Continue reading

Google Sheets FILTER function: formulas and tools to filter data in spreadsheets

If the only way you know of creating a filter in Google Sheets is the standard tool, I have a surprise for you. :) Come explore the FILTER function with me. There are plenty of ready-made formulas you can borrow, along with a new powerful tool that complements the filtering toolset immensely. 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

How to merge several Google sheets into one without copy-pasting

Every once in a while each Google Sheets user faces the inevitable: combining several sheets into one. Copy-pasting is tedious and time-consuming, so there has to be another way. And you're right - there are several ways, in fact. So get your tables ready and follow the steps from this article. Continue reading

Google Sheets formulas for 12 most useful Google Sheets functions

This time we decided to provide you with the most simple Google Sheets functions that you definitely need to learn. They will not only help you with the plain calculations but also contribute to extending your knowledge of building Google Sheets formulas. Continue reading

CONCATENATE function: formulas to merge cells in Google Sheets

"Concatenate" usually means to link something together in a series or a chain. This operation is used in Google spreadsheets whenever you need to join records from multiple cells. This article collects the most popular and easy solutions to help you solve the concatenation puzzle. Continue reading

Google Sheets percentage formulas - usage and examples

You may think percentage calculations are useful only if you use them for work. But in reality, they help you in everyday life. Do you know how to tip properly? Is this discount a real deal? How much will you pay with this interest rate? Come find the answers to these and other similar questions in this article. Continue reading

How to compare data in two Google sheets or columns

Whether there's summer knocking on our doors or winter invading Westeros, we still work in Google Sheets and have to compare different pieces of tables with one another. In this article, I'm sharing ways of matching your data and giving away tips on doing that swiftly. Continue reading

Merge data from duplicate rows in Google Sheets based on a unique column

Combining duplicate rows in your spreadsheets may turn to one of the most intricate tasks. Let's see what Google formulas can help and get to know one smart add-on that does all the job for you. 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

If VLOOKUP in Google Sheets is not working

How to do a Vlookup without errors in Google Sheets? Take a closer look at the most common mistakes made when working with the VLOOKUP function. Continue reading

Ways to move, merge, hide, and change rows in Google Sheets

Google Sheets lets you manage rows in many different ways: move, hide and unhide, change their height, and merge multiple rows into one. A special styling tool will also make your table easy to understand and work with. Continue reading

Working in Google Sheets: add, freeze, and remove rows

It's time to learn more about rows in Google Sheets. Learn how to insert new rows to your table – one or many at once; freeze lines in a spreadsheet in a few clicks; delete selected or only empty rows in your table. Some useful shortcuts and the add-on are there to ease your work. Continue reading

Columns in Google Sheets - split text to columns and convert columns to rows

I'd like to share with you a few more pieces of advice about columns in Google Sheets. If you ever needed to split the content from one column into separate ones or turn the table around so that columns become rows, this is your lucky day. Today I'm going to reveal a few quick tips on how to do that. Continue reading

Columns in Google Sheets - move, merge, hide and freeze columns in a spreadsheet

Today I invite you to learn a little bit more about columns in Google Sheets. Did you know that you can move and hide columns in your spreadsheet? And what about freezing and merging them? Let's explore these functions together! Continue reading

Pages: 1 2