Topics > Data Management

86 Tutorials

You got messy data. It's keeping you up late at night trying to manage it. You copy. You paste, and repeating too many tasks. These videos help you manage that data. You can use Apps Script or you can use Formulas. No matter the task, there is an answer.

No More Struggling
Are you struggling to manage your data in Google Sheets? Don't just delete all your sheets and start over!

Are you spending too many late nights copying and pasting data and repeating the same tasks over and over? If so, you're not alone. 

Many people struggle with messy data in Google Sheets, but the good news is that there are solutions available. In this section, we'll explore some of the best Google Sheets data management techniques to help you organize your data, save time, and save your sanity.


Why Google Sheets Data Management is Important
Google Sheets is a powerful tool for organizing and analyzing data, but it can be overwhelming for beginners or even experienced users when dealing with messy data. Without proper organization, you may end up spending a lot of time on repetitive tasks like copying and pasting or manually formatting cells. 

Bad data management can lead to errors and inconsistencies in your data, making it difficult to draw accurate conclusions. Your insights might be top notch, but if your data is bad, or messy, you won't ever get to the analysis part. You'll be bogged down with bad data, forever.


That's where Google Sheets data management come in. These tutorials can help you learn new skills and strategies to manage your data more efficiently. Whether you're using Apps Script or formulas or found a great tab naming system, you can find a solution that fits your needs and helps you save time and reduce errors.

Sheet Theory
I would also recommend checking out more theoretical videos in the Sheet Theory section. These tutorials will open your mind to new techniques beyond step-by-step tutorials.


Sorting and Filtering Data

One of the most basic tasks when working with data is sorting and filtering. Google Sheets offers powerful tools for sorting and filtering data, allowing you to quickly identify trends and patterns in your data.

Tutorials here go beyond just using the filter menu option. You'll learn new formulas like FILTER() and SORT() that give you more control and flexibility. 


Beyond Pivot Tables

Pivot tables are another powerful tool for managing data in Google Sheets. They allow you to summarize large data sets and identify trends and patterns. With pivot tables, you can quickly create summaries of your data without having to write complex formulas or macros.

But here at Better Sheets, we can do better. Learn how to create your own customized and personalized tables and summaries with the full power of Google Sheets Formulas


Using Apps Script

Apps Script is a powerful tool for automating tasks in Google Sheets. With Apps Script, you can write custom scripts to perform complex tasks like importing data from other sources, sending emails based on specific criteria, and much more.


To get started with Apps Script, click on the "Extensions" menu and choose "Apps Script." This will open a new window where you can write and edit your scripts. You can also find pre-written scripts and examples in the Apps Script section here on Better Sheets.

Using Formulas
Formulas are another powerful tool for managing data in Google Sheets. With formulas, you can perform complex calculations and manipulate data to create custom reports and analyses.

Some common formulas include:

  • SUM: Calculates the sum of a range of cells.
  • AVERAGE: Calculates the average of a range of cells.
  • COUNTIF: Counts the number of cells in a range. based on criteria.
  • MAX: Returns the highest value in a range.
  • MIN: Returns the lowest value in a range.

To use a formula, simply type it into a cell and include the range of cells you want to calculate.

Become a Google Sheets Pro
There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level. 
From ABS() to ZTEST(), Better Sheets has it all. 



86Tutorials

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.
Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.
One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas
 I'm sharing a magical checklist that will make your sheets so darn amazing. We'll start with a to-do list on a Monday and check off tasks to see them move to a "done" list. I'll guide you through the process of creating an "on edit" function in Google Sheets using app scripts. By the end, you'll know how to archive completed tasks from your to-do list. Get ready to boost your productivity and stay motivated! 🚀
How to create a form programmatically using Google Apps Script. I show you step-by-step how to create a form, set the title, add text items, and set the destination of the form to a specific sheet. This tutorial is perfect for anyone who wants to automate the process of creating forms, whether it's for templates, lead magnets, or recurring forms. No prior coding experience is required.
In this tutorial I go from raw data to a full formed dashboard. In this particular case we're looking at the number of weeks someone might have left to live. A bit of stoic motivation, part baroque style. You'll see how I look for inspiration in the Memento Mori medallion and also in images representative of  "Memento Mori" then I use those colors in the images to make this dashboard.  

In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.
Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.
In this video, I will show you how to clean up a list of names that may have extra white spaces using a formula. I will demonstrate how to identify and remove the extra spaces programmatically, making the list of names unique. By using the TRIM formula, we can easily clean up the names and create a new list with only the unique names. No action is required from you, just watch and learn!
Jodi asked:  ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place. 

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet.  I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:
https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula
https://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-trigger

Spreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101
Create a sheet that can trash itself. It can delete itself instantly or on a timer. Maybe in 24 hours or a month.
Revolutionize the way you handle data with the BetterSheets REGEXMATCHER! Imagine having the ability to effortlessly validate text patterns, ensuring the integrity of your data. Whether you're searching for specific mentions, cleaning up unwanted content, or filtering out irrelevant information, our REGEXMATCHER is your go-to solution.

Error-Free Data: 
Experience precise data validation ensuring your information is accurate and error-free.
Effortless Pattern Recognition: 
Easily identify and eliminate unwanted data patterns, guaranteeing a clean and organized dataset.
Tailored Data Classification: 
Classify your data based on specific patterns, streamlining your workflow and increasing efficiency.

Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need. 

  • Spin randomly to get one variation
  • Spin text for all variations
  • Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.
If you have a list of tasks and statuses, the FILTER formula will help keep you from the brink of Overload by allowing you see each status in a different tab.

Great if you're assigning work to VAs or you just became overloaded with tasks in your own task management system.

A great alternative to Conditional Formatting as well.

And a sneaky new little Apps Script that saves the day.
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.
Create a better checklist for project based task management.
Create a new sheet and do it well.
A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.
A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterSheets.co. Validate emails, detect hashtags, format data & more! Dive into the world of Regular Expressions. Start Your Regex Journey Now!

Use REGEXMATCHER to generate any REGEXTMATCH formula you want.
Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax
What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.
Google Sheets has a new way to do dropdowns. Is it naughty or nice?
There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.
Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.
10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets
  1. Squeezed Rows
  2. Garbage Data
  3. Looks The Same
  4. Crazy Column Width
  5. Where’s Waldo 
  6. Of Results
  7. Too Many Clicks
  8. Instructions Unclear
  9. Eye Strain and Headaches
  10. Lazy Conditional Formatting
  11. Too Many Cells
Extract the time from a Google Sheets timestamp.
We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.
Built a useful tool to filter Google Sheet formulas based on keywords.
Find out how to get a formula to get a row, but get it multiple times per row.
Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.
How to turn many columns into one column.
Hide data with these simple tricks. Just using the IF() formula.
Replace and find word will search your documents for specific text, replaced with different text, or you can replace it with something else.
Create a simple to-do list that does so much more.
Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.
The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!
Get this epic script that automatically edits two tabs and keeps them in sync.
Discover how to Save Your Sheets Every Week Automatically
Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.
This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.
Got a list of names, need to add new ones to main list.
generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
We have a question from Rupesh about the quick CRM. He wants to add some team members.
Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.
We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.
Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.
One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!
When you can't get the url of a hyperlinked cell, do this instead.
This video is a tutorial on how to create a dynamic weekly planner in Google Sheets with drop-down menus that change images based on selections. Here are three key takeaways:

Avoid Hidden Rows/Columns for Clarity

The speaker advises against using hidden rows or columns in Google Sheets. They suggest that this practice often leads to confusion and inefficiency, especially when sharing sheets with others. As an alternative, they recommend placing such data on a separate sheet.

Dynamic Dropdown Lists and Image Insertion

The tutorial demonstrates how to create dropdown lists where selecting a subject (e.g., English, Math, Study) changes the image displayed in another cell. This is achieved through data validation for dropdowns and using VLOOKUP or INDEX MATCH functions to link the chosen subject to its corresponding image.

Flexibility and Ease of Updates

The approach shown allows for easy updates and additions to the planner. For instance, adding new subjects or changing images is straightforward. The speaker emphasizes the versatility of the INDEX MATCH function over VLOOKUP, as it offers more control and adaptability, particularly when rearranging data.

The video also touches on the specifics of resizing rows for better image visibility, the importance of unique identifiers for dropdown options, and the benefits of expanding dropdown lists for future additions.






Count different types of blank cells. Cells with nothing in them.
We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.
Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.
Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.
The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.
Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.
Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.
We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.
Autofill inside of google sheets is possible with Dropdowns.
find out how to show the total number of data rows available in a sheet.
Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
This will allows you to analyze and organize your data.
How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.
Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends! 

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.
Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor. 
Learn how to find duplicates with a simple formula in Google Sheets.
Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.
Free tutorial for finding Minimum and Maximum data points.
Use neon blue to show where someone needs to enter data.
Fid out how to get the frequency of ProductIds, or Names, or Emails. or how many times they appear in a sheet/column/row.
Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.
Create a duplicate detector with a few google sheet formulas.
Create a sales pipeline quickly in Google Sheets.
Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Create a quick search dropdown to find keywords in any column.
tactics on how to keep your sheets secure.