"Add-ons for Google Sheets" category

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

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

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

Pages: 1 2