Latest

Automate Your Expense Tracking in Google Sheets: A Step-by-Step Guide

You can turn a manual chore into an efficient, automated workflow, allowing you to focus on your financial goals. As we usher in a new year, it's time to get our finances in perfect order. There's no better way to start than by automating our expense

Protect Your Formulas from Accidental Deletion in Google Sheets

Ever spent hours crafting the perfect formula in Google Sheets, only to accidentally delete it? It's a frustrating experience that can derail your productivity. Fear not! In this guide, we'll unveil some clever tricks to safeguard your hard work.

How To Make That Viral Growing Plant Progress Chart

Imagine checking off tasks and seeing a cute little plant sprout right before your eyes. That's exactly what we're going to create today!

Word Tracker and Progress Tracker in Google Sheets

Ever dreamed of having a personal writing assistant right there in your Google Sheets? Imagine tracking your word count, setting goals, and watching your progress grow – all without leaving your favourite spreadsheet app. Well, your dream is about to come true! In this post, we're going to show

5 Ways to Combine Names in Google Sheets

Ever found yourself stuck in a loop of copying and pasting names in Google Sheets? Let's face it, it's a task that can feel like a never-ending chore. But fear not, because I've got your back! So, we're diving into the world

5 More Fixes For Your Spreadsheets

Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change

Discover Misspelled Duplicates

The built-in feature can sometimes miss duplicates that have subtle differences, such as variations in spacing or formatting. Our formula-based approach, on the other hand, provides a more granular level of control

Easiest Mistakes to Make In Spreadsheets

When you start mixing unrelated data in the same rows or columns, it becomes harder to follow what’s going on.

Name Match: Who's In and Who's Out

Let's say you have a master list with over 700 names and a new list from a recent meeting containing 175 names. How will you identify which names from the new list aren't on the master list so they can be added.

Sensational Spreadsheet Styling

Not only do they need to be accurate and efficient, but they should also look beautiful and eye-catching.

9 Google Sheet Tips for Affiliate Marketers

Learn how to apply formulas and calculations within Google Sheets in order to develop a tracking system for the effectiveness of your campaigns.

5 Google Sheet Tips for Admin Assistants

As an admin assistant, you could use this Google Sheets tutorial to get better at managing the frequent data manipulation tasks your job requires.

Privacy Policy

Effective Date: January 1, 2024 Commitment Welcome to Better Sheets. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about this privacy notice, or our practices with regards to your personal information, please contact us at privacy@bettersheets.com.

Formulas Frustrating? It's Not The formula's fault.

When I first started using Google Sheets, I was full of excitement. I believed that every formula would work perfectly, that each one would fit my needs effortlessly, and that Google Sheets would be the ultimate solution to all my problems. But after years of using formulas that sometimes broke,

19 Google Sheet Tips for Administrative Assistants

Get better at google sheets to make your job easier.

Why Should I Code in Google Sheets?

Automate repetitive tasks, such as data entry, calculations, and formatting in Google Sheets.

4 Ways to Resize Columns, Change the Column Width in a Google Sheet

Adjusting column width is crucial for enhancing the readability and functionality of spreadsheets. Properly sized columns ensure that all data is visible without unnecessary scrolling or cutting off information, which can lead to errors or misinterpretations.

How to Send Google Forms Entries Automatically with Apps Script

Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.

Explore Coding in Google Sheets

Did you know you can actually code in Google Sheets?

Is using Google Sheets a recipe for chaos?

Expert: Hi Alex! I hear you're interested in project management and how to streamline it using Google Sheets? Alex: Yes, but I’m a bit skeptical. I mean, isn’t using Google Sheets for project management just a recipe for chaos? It seems like a lot of data

Automated Project Management in Google Sheets

When you have multiple people working on multiple tasks, and you want everyone to be on the page, what do you do? You can use a Google Sheet. But managing projects can be an intimidating task in Google Sheets. It's a lot of data entry, right? Especially when

Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas

You may be using Google Sheet to do math and find that you need to iterate a number. ROW() gets you the row you're on, and helps you with this.

How to Add Star Ratings in Google Sheets: A Step-by-Step Guide

Have you ever wondered if you could add star ratings in Google Sheets? Well, the answer is yes! TL;DR * You can add star ratings in Google Sheets using data validation and emojis, creating an engaging rating system for surveys and feedback forms. * The process involves creating a range of

10 Simple Ways to Make Your Spreadsheets Better

Here's a few things you can do very simply and in no time at all, to make your spreadsheets better. Make better spreadsheets for you to spend time in. And better for other people who have to use your spreadsheets.

How to Gain Confidence in Google Sheets

Building confidence in Google Sheets, and yourself is essential. It's benefits include: streamlining your workflow, ensuring data accuracy, and maximizing your productivity. If you’ve ever felt overwhelmed or unsure about using Google Sheets, this guide is here to help. Let’s explore some practical tips and strategies

How To Hide Data with Checkboxes in Google Sheets

Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.

Capitalize All Words or No Words in Google Sheets

When working with Google Sheets, you might find yourself needing to adjust the capitalization of text within your cells, whether that means capitalizing each word or making everything lowercase. Here’s a quick guide to help you master these formatting techniques. Capitalizing All Words If you want to capitalize each

Advanced Checkbox Hacks for Streamlined Approvals

Google Sheets is a powerful tool that offers a wide range of functionalities. One such feature that can significantly enhance your workflow is the use of checkboxes for approvals. In this blog post, we will delve into some advanced checkbox hacks in Google Sheets. These tips will help you move

How to Customize PROPER Function in Google Sheets (Creating a Headline Case)

Have you ever wanted to make all the words in your Google Sheet stand out?  Here is an easy tutorial for capitalizing each word, just like a title!

Can I get alerted when a tab name is changed?

Use Apps Script to receive emails whenever there’s a change in your Google Sheet structure Are you an organization with multiple people working on the same Google Sheets file? Then, you might want to know when one of your people changes something in the spreadsheet, whether that be adding

Google Sheets AI Formula

Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at

Automate Row Deletion in Google Sheets with Apps Script

In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way

How to Count Between 1 and 16 in Google Sheets

A question from the Facebook group "I Love Google Sheets" wants to know how to count numbers between 1 and 16 in a series.  So let us break it down and look at the best way to do this. The question was "How can I count the

How to Tell if Two Cells are the Same or Not the Same in Google Sheets

Determining whether two cells in Google Sheets are equal or not is a common task that can help streamline data analysis and ensure data accuracy. Open up your spreadsheet and follow along with this guide on how to do this using different methods. Are These Two Cells Equal or Not?

Mastering the Art of Template Creation

An Exclusive Interview with Becky, Owner of The Template Nook 📺Watch the entire 1 hour interview on YouTube In our latest edition of "Sheet Talking," we dove deep into the world of templates and organization with Becky, the owner of The Template Nook. Becky's unique approach

Philippines Phone Number Validation: Use of REGEXMATCH in Google Sheets

Every school year thousands of students and teachers’ data were being added to the school database. As someone who was always given the task to narrow down lots of information after the school enrollment, validating students’ data manually is very exhausting. Take this as an example, when you ask students

How to reference a different Google Spreadsheet in Apps Script?

Transferring Data Between Cells in Different Spreadsheets

One Simple Google Sheets Hack for Better Header Fonts

If you don’t want your spreadsheet to look dull and unprofessional, there’s one trick to make it stand out.

The Double-Edged Sword of Google Sheets Formulas: A Journey Through Frustration and Triumph

A misplaced comma, an incorrect range, or a simple syntax error can render a formula ineffective, leading to hours of troubleshooting. Formula Parse Error, anyone?

Generate Variations of Headlines EASILY in Spreadsheets (with Spintax)

You can now create headline variations and permutations super easily with Spintax. And do it in spreadsheets. More info on Spintax: https://spintax.bettersheets.co/ I just updated the Spintax tool to be able to generate spintax as well as parse it: What is Spintax? Spintax, or spin syntax, is

A Decade of Spreadsheet Wisdom

10 years ago Timber was the #1 song... and I was coding in spreadsheets then, just as I am now. Learn from my decade of experience.

The $10 Million Dollar Expense Tracker

YNAB started as a spreadsheet in 2003. Discover 15 more businesses that started as spreadsheets: https://bettersheets.co/started

20 Google Sheets Tips for Bloggers

Through the use of computational tools, like AI and automation functions, you can gain insight from data that was previously too time consuming to extract.

How to Make Better Lead Magnets

Create better lead magnets in Google Sheets so that when people share them you get the credit.

Simplifying Interest Gain Calculations with the EFFECT() Formula

This highlights how essential it is to have a dynamic and scalable tool that can adapt to real-world variables, such as changing interest rates and investment periods

Exporting a Google Sheet to PDF – Why Do It via URL?

Turning your Google Sheet into a PDF is a great option when you need to create a quick snapshot of your spreadsheet data, or send a report. With the new free BetterSheets tool, there is now a faster and more replicable way to distribute your Google Sheets data in PDF form (via URL).

How to Sell Google Sheets on Etsy & More Marketplaces

Etsy, the marketplace of unique goods, is also a great place to sell Google Sheets. You can sell Google Sheets templates for all kinds of uses.

Build Better Budget Templates

Let's build better budget templates with automation, design, and a little magic.

Build Better Financial Templates

By crafting and selling high-quality, customizable financial templates, one can cater to the needs of those who lack the time or expertise to create their own.

20 Google Sheet Tips for Business Analysts

Learning Google Sheets empowers Business Analysts to efficiently analyze data, create insightful visualizations, collaborate with stakeholders, and streamline their data analysis workflows. It's a valuable tool for data-driven decision-making and problem-solving in a business context.

3 Google Sheet Tips for Administrative Professionals

Learning more skills in Google Sheets empowers administrative professionals to manage data efficiently, make data-driven decisions, collaborate effectively, and improve overall productivity.

20 Google Sheet Tips for Bookkeepers

Google Sheets offers a cost-effective, flexible, and collaborative solution for managing financial data, performing calculations, generating reports, and staying organized.

HOW TO EXPORT YOUR GOOGLE SHEET TO PDF

Learn how to seamlessly export your Google Sheet to PDF using simple shareable URLs and various formatting options. Get expert insights and step-by-step instructions to optimize your PDF exports effortlessly.

The Simplest Bestest Checklist in Google Sheets

Build the ultimately, best, and simplest checklist. Designed well, and FUN to fill out!

How to Create a Random Motivational Quote Checklist

Learn how to make a motivational quote checklist in Google Sheets. Watch the tutorial on YouTube now. Enhance your day with inspiring quotes!

Shaman: AI writing assistant in Google Sheets

Unleash your blog post writing with Shaman. This AI assistant in Google Sheets eradicates writer's block and generates eye-catching headlines.

3 Google Sheet Tips for Budget Analysts

Budget analysts can improve their efficiency, accuracy, and ability to make data-driven financial decisions, enhancing their value in budget planning and analysis roles.

3 Google Sheet Tips for App Developers

App developers, this one is for you. Kick Trello out. Stomp out those new fangled project management apps.

3 Google Sheet Tips for Account Managers

Improving skills in Google Sheets equips account managers with valuable data management, analysis, and collaboration capabilities that can positively impact their work performance and contribute to the overall success of the organization.

Revolutionize Your CRM: 3 Game-Changing Google Sheet Formulas!

CRM software is essential for any business looking to increase revenue and build relationships with clients. Many small businesses are looking for their first piece of software to go from spreadsheets to something else. But what if I told you, you could just make your spreadsheets better.

How to Validate Email Addresses for FREE in 17 Minutes

How to Validate Email Addresses. Up to 1,000 free email validations per month. Using a free API and Google Sheets.

12 Google Sheet Tips for Business Consultants

Discover how to automate data analysis, manage clients, create striking visuals. Unlock the full potential of Google Sheets for your business consultancy.

Build a Business in a Google Sheet: Design Ideas Directory

Build a Swipe File of Design Inspiration in a Google Sheet and sell it.

Build a Business in a Google Sheet: VC Financial Model

Idea: VC Modeling for Future Funders This is an idea that someone with experience in VC modeling can build in a Google Sheet. What you might lack in Google Sheet skills can be easily learned via BetterSheets.co courses.

Business Idea: Script Writing Tips and Tricks in Google Sheets

Discover unique techniques, collaborations, and automated aids tailored for aspiring writers. Improve your scriptwriting skills with powerful Google Sheets tools.

10 Google Sheet Tips for Virtual Assistants

Boost your Virtual Assistant skills with these useful Google Sheet tips! Streamline workflows and automate tedious tasks.

Mr Beast Renames YouTube Titles

I needed help with my YouTube videos. So I enlisted an AI version of Mr. Beast to rename my YouTube Videos. Become a member to get the sheet: https://bettersheets.co/tutorials Tutorial and Sheet here: https://bettersheets.co/tutorials/mr-beast-renamed-my-youtube-titles

9 Google Sheets Tips for Data Analysts

Explore tutorials to enhance data analysis skills: manage large datasets, automate tasks, and uncover trends efficiently. Save time, increase accuracy, and gain valuable insights.

/Copy URL Trick

Discover a faster way to share Google Sheets using the /Copy URL Trick. Automate url editing, save time and promote effortless collaboration.

Run 100 ChatGPTs at One Time

Can you run 100 chats yourself, at the same time? Hell No. But you can do that in Google Sheets. We'll write 1 great prompt then use that 100 times with 100 different inputs in that prompt. Become a Better Sheets member to get the Apps Script api already written for you: https://bettersheets.co/

Formula Parse Error - Frequently Asked Questions(FAQ)

A formula parse error occurs when there is an error in the syntax of the formula.

Easily Write 1,000 Headlines in Google Sheets

Showing you how to use the new Spintax add-on to write 1,000 headlines from a spinned version of a headline. Get Spintax here: https://spintax.bettersheets.co/

Run Every Prompt in Every Cell All At Once

Welcome to the Prompt Parade. We are gonna write a bunch of prompts and we're gonna get responses of these prompts back, all in a google sheet. Great way to create a little web app inside of a Google Sheet.

Create a ChatGPT Cheat Sheet Spreadsheet

How to build an AI prompt engineering spreadsheet. Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet. More tutorials, courses, tools and templates at Better Sheets: https://bettersheets.co/

Google Sheets Templates - Frequently Asked Questions(FAQ)

Google Sheets Templates are pre-designed Google Sheets for a specific use-case or a specific action. They can be designed for certain roles, or for different amounts of people to access them.

The Hidden Joys of a Well-Crafted Spreadsheet

We delve into how a good design can make it easier to find, edit, and input data, and how it can be beneficial to your everyday work. It can help yourself and others.

80 Years In 1 Spreadsheet

See your entire life in a single spreadsheet. Watch the Memento Mori Dashboard here: https://www.youtube.com/watch?v=2iP54u6lQS8

Better FAQs: The FAQ Maker - Frequently Asked Questions(FAQ)

Generate, craft, and publish FAQs effortlessly using AI. For both new product launches and new features. Optimize your Google Search traffic with structured data.

Get Sheet Done: Start Your Business in Sheets

4 Ways Google Sheets Can Help You Start Up Create a list Curate Links Track Something Write Code

Writer Better Prompts

I take an api call to ai and turn it into the Ultimate Prompt Writer and Prompt Rater using Google Sheets Apps Script to save all my prompts, and responses into a sheet.

When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa

Esa is a beginner at Google Sheets. I discover the moment he discovered the deepest secrets of Google Sheets. And we wax poetic about AI in sheets, and data flow.

How to Spin Content

In this video I'm going to introduce you to a new tool from Better Sheets called spintax Content Spinner. Free add-on you can install in sheets today. Get Spintax free: https://spintax.bettersheets.co/ Sign up as a member to notified first: https://bettersheets.co/

GPT in SHEETS

Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!

How to create a formula for every row in a column in a Google Spreadsheet?

3 possible ways to create a formula for every row in a column in a Google Spreadsheet. And two bonus ways to make it look nicer. - Auto fill - Double Click - ArrayFormula

Write. Sell. Repeat.

Want to monetize your writing skills? Learn how to build a low-cost, profitable business by selling pre-written tweets via Google Sheets.

12 Google Sheets Tips for Project Managers: Boost Your Efficiency and Collaboration!

Enhance your data organization, collaboration, and efficiency.. Discover how to leverage Google Sheets for project management.

Build a Prioritization Framework Business

Build your own Prioritization Framework with Google Sheets. Get 100 free business ideas from Better Sheets and transform your professional life today.

Teaching Google Sheets: Challenging, Rewarding Journey

Teaching Google Sheets is a challenging, yet rewarding journey. As a teacher, you may find yourself struggling to keep up with the ever-changing features and updates of this powerful spreadsheet tool.

How To Make That Viral Growing Plant Progress Chart

You might have seen a viral TikTok where there is a progress bar and a growing sort of garden of flowers or potted plant that's growing as you check off these task bars tasks. So I want to walk through what this formula, the combination is how it's really cool it

Transform Your Spreadsheets with OpenAI API and Apps Script

Turn your spreadsheets into AI machines of epic-ness. Transform your sheets, your writing, your life into an amazing tool you'll never stop using, and producing with. I think you'll be able to 10x or 100x your output. This course is great for writers, businesses, agencies.

9 Tutorials to Help You Use the IF() Formula Better

Build tools like timers and savings thermometers. Unlock the power of the =IF() formula with the comprehensive tutorials on Better Sheets!

Quick Google Sheets Tips

Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.

How To Create a Stop Watch in Google Sheets

Create a Stop Watch in a Google Sheet. Start and stop time stamps, add up duration once you click. This is a sweet Google Sheet to make and you can see it step-by-step.

Guest Posts on Better Sheets

How to guest post on Better Sheets. You can be an expert or just love Google Sheets! You'll find specifics, about who reads Better Sheets, What I'd like to see more of, and how to submit a Guest Post to Better Sheets.

How To Calculate ROAS in Google Sheets

Showing you two ways to use sheets to calculate Return on ad Spend. ROAS. One way with formulas and one way with Apps Script. Learn more at Better Sheets: https://Bettersheets.co

How To Add Columns in Google Sheets

How to add columns in google sheets, in 7 different ways.

How to Use Sheets For Network Building

How to use Sheets to build your network. Using new interfaces from Google, it's possible to add today date SUPER easily. Sheets have added much more integrations with all of Google Workspace. Contacts also called People Chips makes it possible to curate your network in a sheet.

3 Advanced Tutorials for the IF() Formula in Google Sheets

3 advanced Google Sheets IF() formula tutorials. Improve your spreadsheet skills with password protection data, email notification.

Everything Aggravating about Apps Script

Been coding Apps Script for almost 10 years. Here's what I still find aggravating in Apps Script. The autocomplete is frustrating. Files don't save with errors. I lose my way in files. And the documentation is atrocious.

3 Advanced Ways to Use the INDEX Formula

Three video tutorials for advanced users. In these tutorials, I show you the different ways you can make use of the INDEX function to create fun and useful things with Google Sheets.

One Percent Better Every Day

Get better at making better Google Sheets every single day. I give you a few ways that you can improve every single day. Basic concept is to Explore, Experiment, Apply, and Explain

Great Sheets! Seedtable Created an amazing Community Board

The normal intuition here is to create different tabs, but he knows like as a web designer that any amount of clicks you have the user do is going to lessen the amount of people. So he puts it all into one spreadsheet, one key, and you just have to scroll down.

Sheet Talking Episode 7: Oz Excel on Fire

Follow Oz on YouTube at @OzduSoleilDATA and on LinkedIn: https://www.linkedin.com/in/ozdata/

Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same

I'm sharing with you two ways to use equal and two ways to use not equal or to get not equal or to get equals.

Why do I want to Email Myself Every Day?

Master the art of using Google Sheets to organize your daily tasks. Learn to create email reminders, track goals, and enhance productivity. Dive in now!

The Only Guide You Need: Google Sheets Free Resources

I have compiled a list of free resources that you’re going to find useful. There are courses, blog posts, YouTube videos, and Udemy and Coursera courses.

Google Sheets Interface Changes

New Date Chips and Integration with Google Workspace makes Google Sheets much more useful, within the ecosystem. It's a great tool within workspace now.

Unlock Your Earning Potential: Make $1,000 a Month Writing Tweets with this 1 Formula

You're already on Twitter. You're already writing great tweets, but maybe you're finding a lot of tweets that you like, a lot of tweet formats you like, and you want to replicate them with your own words, your own experience.

Simply Email Yourself From a Google Sheet

I wanted to share with you one of the simplest apps scripts that has immense power. Email! You can email others, but you can also email yourself.

Are You Frustrated With Sheets New Dropdown Chips?

Do those dropdown chips have you frustrated? They stand out far too much! Here's how you can change the look of your sheet instantly? With a few advanced options with Dropdown Chips in Google Sheets

Single Biggest Mistake When Converting Excel to Google Sheets

You might think the biggest mistakes when converting Excel spreadsheets to Google Sheets is how they work internally. But it's not. It's actually that you have to convert them. Google Drive has a unique function in that it does not actually convert your Excel documents unless you want to.

Learn Google Sheet Formulas The Hard Way

It is so stupidly simple as well that you might not do it and you might not think you'll get enough out of it. But I can tell you unequivocally: This is very much how I learned a lot of Google Sheet formulas.

Your First Formula in Google Sheets

Here’s what we are going to go into: Some errors you might encounter to get you over some challenging parts Show you a little bit of an expert trick that not many people know about the curly brackets Go into at least one very useful formula

Why is Coda so cool? | Sheet Talking Episode 6

What is it about Coda that people gravitate to? Why Coda and not notion, google docs, excel, glide, spread simple.... what does it do? Find Scott on Twitter: https://twitter.com/thecodaguy and at Coda School: https://www.codaschool.io/

How to Say "I Do Google Sheets"

We do spreadsheets. That's what we do. We use Google Sheets for everything. So how on earth are we to get across all of the nuance and power that we hold at our finger tips?

6 Different Ways to Use INDEX()

This is the syntax for the INDEX formula. Below are video tutorials that talk about the INDEX formula, These are fun tutorials that show you how you can use INDEX for different cases and uses.

How To Hide Data with Checkboxes in Google Sheets

Google Sheets, Google Sheets Tutorials | This tutorial is meant to show you not just what magical things you can do with checkboxes, but also to show you my process on how when you become a member of Better Sheets.

Excel Exposed! Interview with Ben Currier on Sheet Talking Episode 4

In today’s tech-savvy world, spreadsheets are everywhere. For years, Microsoft Excel has dominated the market for spreadsheet applications, but with the rise of cloud-based applications, Google Sheets has been gaining popularity. So which is better? Let’s settle this debate once and for all.

How to Bring value from other cells | How to Reference an array in a cell

Today’s tutorial will cover how to bring a value from other cells. How do you reference an array in a cell? Anika is a member of Better Sheets and she was the one who asked this question.

The Most Popular Google Sheet Tutorial on the IF() Formula

The IF() formula is a logical function that makes it easy for users to compare a certain value and an expected value. It takes a look at a value to see if basic conditions are met.

change any language with this one trick

we're gonna try understanding language and understanding what they're saying we can go to a cell we can do equals Google translate but here's the thing when we use Google Translate we need three things

Dark Mode for Google Sheets Video Tutorial

Dark mode doesn't exist in Google Sheets *unless you're on mobile. But in this video tutorial you can learn how to create your own dark mode in Google Sheets.

How To Use a 1-Cell Google Sheet

Introduction to Tiny Sheets a free google sheet add-on to make tiny spreadsheets. Delete unnecessary rows and columns easily.

VisiCalc, the Revolutionary Spreadsheet Software from 1979, Returns!

Like a Jedi master resurrecting a fallen ally, VisiCalc has been reborn and redesigned inside of Google Sheets. And with it, a new hope for those who seek to master the power of spreadsheets.

No More Google Sheet Tricks

No more Google Sheet tricks. This is it folks. A new day has dawned. I have a new product to launch and I'm so nervous! Free Template: https://bettersheets.co/visicalc

The Google Sheets Formula Conspiracy

Did you know that Google Sheet formulas are alphabetical and the parent company is called Alphabet. Weird right? It's like it was all formulated this way. On purpose.

How To Change the Default Font in Google Sheets

What you can do is format the theme to change the default Arial font.

YouTuber Talks About Sheets | Sheet Talking Episode 3 Prolific Oaktree

Sheet Talking is a series of casual conversations with Spreadsheet Professionals. This one with Prolific Oaktree.

How to Use Google Sheets for Advanced Project Management

Master Google Sheets for project management with these advanced tips. Check our free tutorials, tools, and templates for data management, task flow, and much more.

Track Anything in a Google Sheet!

Track anything you want with this Google Sheet. Set it up with the emoji of your choice and see your progress at a glance.

ChatGPT Clone in Google Sheets

Sam Altman has even admitted before ChatGPT existed, about 10 months before it existed in open AI’s API documentation. There was a chat example. We go through that example and then we use the interface of ChatGPT inside of Google Sheets.

Getting Started in Google Sheets Spreadsheet Management

Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.

Best Header Font Ever for Google Sheets

Turn your headers cool. Sweet sweet header font to make your headers better. Less pop and more ooooh ahhhhh.

How to Easily Add Company Logos to Your Google Sheets

I wanted to share this really cool little thing that I discovered from my friend, James Ivins, over on Twitter. He said that Google has a secret API that you can use to show any website's icon on your site and he had this URL he used.

Export PDF from a Google Sheet (WITH OPTIONS!)

Master exporting Google Sheets to PDF with this handy guide! Learn how to generate custom URLs, adjust format options, & much more with our free tool.

100 Side Hustle Ideas to Start With Google Sheets

Start it really small, update it every once in a while, and sell it on a platform that you don't necessarily have to create and keep running. Something like Gumroad, Lemon Squeezy, or even Etsy. You can even sell a Google Sheet via payment link.

Free Easter Egg Hunt in Google Sheets

Free easter egg hunt game. You can make a hunting game inside a Google Sheet. Download the Easter Egg Hunt sheet here: https://bettersheets.co/tutorials/how-to-make-an-easter-egg-hunt-in-a-google-sheet-by-bettersheets-co

Hate Google Sheets? You can enjoy Google Sheets. Really. You can! Trust me.

You don't enjoy Google but you don't have to stay that way. Enjoying or not enjoying Google Sheets, I think is partly due to the way that Google Sheets is. It looks just sparse. It's Arial font, blackish black and whitest white. Very stark contrasting spreadsheet.

Spreadsheet Opportunities

Learning to code in Google Sheets can unlock major opportunities. Promotions New Roles Side Hustles And for those who run/own their own business there are plenty of opportunities too! New Revenue Streams in selling your processes New Lead Magnets for new customers Customer Engagement / Retention

How To Hold a Giveaway Raffle in a Google Sheet

It’s the holiday Christmas season and I just thought it would be really cool to create a giveaway in a Google Sheet.

Atomic Sheets

What if it only took you two clicks to make your Sheets better? Would you do it? This is exactly what you get out of Atomic Sheets: Add elements to your sheet with just two clicks.

Create a Many to Many Database inside Google Sheets

Master Google Sheets & simplify work with this tutorial on creating a many-to-many database. No more manual entry! Learn, apply & save time.

Sheet Styles - A Free Google Sheet Add on by Better Sheets

Control design, optimize workflows, and enhance readability. Transform your Google Sheets experience with free add-on by Better Sheets.

Brutal Calendar Craigslist Edition 2023

Create a minimalist calendar inspired by early Craigslist with our free tutorial! Explore innovative Google Sheets designs and tools.

How to Make a Small Fortune With Google Sheets | Create a Headline Generator in a Google Sheet

We're going to create a headline generator. We love Google Sheets here. If you love Google Sheets as well, you might want to consider becoming a member of Better Sheets.

150 VCs Actively Investing by Lemon.io

Sheet was provided for free on Twitter by Lemon.io and here I converted it to look and feel like Lemon.io's awesome design on their website. Turning a Google sheet to dark mode is always fun.

Getting Started Coding in Apps Script

What you need to know to access Apps Script inside Google Sheets. Code in Google Scripts. Automate business processes and more.

What's Inside Better Sheets?

Learning Google Sheets can be daunting! There's a lot to learn! That's why I have a lot of tutorials, templates and tools. There's more to Google Sheets than just Tips and Tricks.

Facebook Ads Mockup Generator

Create mock-up Facebook ads with a unique character count formula. Master Google Sheets with free tools, tutorials, and templates!

Are you an A1 or B2 Kind of Sheet Guy?

When it comes to sheets you're either on Team A1 or Team B2, right? Meet Hugo Hamel. He uses Google Sheets every day. He sells a template for keeping track of finances. That's income and expenses. That's easy to manage even if you're not an accountant or a bookkeeper.

The Best Google Sheet Tutorial for Beginners on the IF() Formula

Dive into Google Sheets with our free beginner tutorials on the powerful =IF() formula. Practical applications, templates, and tools included!

Learn Google Sheets Apps Script

Learning Google Sheets coding and Apps Script can have several outcomes and results. Become more productive, more of an asset to your company. No matter if you work there or if you own the company.

Build a Business in Google Sheets: House Painting Tracker

House Painting Work Tracker is a Google Sheets that can help house painters keep track of their painting jobs, materials, and expenses. The business can be used by individual painters, painting companies, or contractors who want to monitor their painting work's progress and expenses.

Sheet Makeover - Google Ad Writer

Taking a google ad writing sheet and making it better.

Are Google Sheets sexy now? Dropdown Chips might do the trick!

Replace typing with clicking. Instantly color-code options. Discover a revolutionary way to manage your lists with Google Sheets new dropdown feature!

How hard is it to learn Google Sheets?

It's very complicated. It's a very complex subject, Google Sheets, because it's a tool that is incredibly diverse comprehensive. It can do almost anything.

Sheet Review! Better Band Bureau Better Schedule

Learn to optimize spreadsheets, design better dashboards, and ensure concise branding. Level up your Google Sheets skills with this in-depth tutorial and review.

Building a ChatGPT Clone in Google Sheets: A Step-by-Step Guide

TL;DR How to create a chat GPT clone in Google Sheets using OpenAI's API. The process involves styling the sheet and creating a chat interface. The video demonstrates how to use the API key, write prompts, and get responses using a variable called chat. It also shows

5 Advanced Formulas To Build a Simple Monthly Budget Template

Track your expenses, manage your finances, hoping to save money, plan for the future, and generally during the month you want to reduce stress. Use these advanced formulas to get more out of Google Sheets.

Five Frustrating Formulas and How to Conquer Them

Google Sheets formulas can be frustrating for a few reasons. First, you’re trying to remember what to use on the fly. Then you can't remember the name of a formula. If you do figure out the name, you can't remember the syntax. Then you don't know the proper way to write the data. FRUSTRATING!

Did Google Take A Feature Away From Users?

I think Google Sheets might have taken a feature away with dropdown menus with the new dropdown chip. It seems as though we're missing one of the key features that a lot of people used.

Manage Your Wedding Guest List with these 5 Advanced Google Sheets Formulas

Simplify wedding planning with Google Sheets! Learn to manage your guest list, send RSVPs, track meal preferences and allergies. Master powerful formulas.

Turn Your Apps Scripts into Native Formulas | Apps Script Custom Function Tutorial EASY

Create custom formulas using Google Apps Script. Clean up your sheets, make precise calculations, and boost your productivity now!

Becoming a Google Sheets Pro: What You Need to Know About Google Sheet Courses

Maximize productivity with a Google Sheets course. Better Sheets offers tutorials, templates, tools, and monthly updates based on 10 years of professional experience and feedback from 5,000 students. Free resources aren't enough.

5 Books To Launch A Business

Wondering how I launched my successful business? These 5 books were my secret weapons! From building a brand to mastering sales, they're the ultimate roadmap to success. Ready to launch your own business? Start here.

Escape Spreadsheet Hell

Learn new Google Sheets shortcuts while having fun in a FREE mini game. Download now and start your journey to becoming a spreadsheet master.

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

Write Better Tweet Hooks with Hot Hooks

Boost your tweet engagement with Hot Hooks, a powerful tool using OpenAI model for creating catchy hooks. Explore our tutorial on bettersheets now!

7 Best Beginner Tutorials Featuring the INDEX() Google Sheet Formula

Master Google Sheets with 7 beginner tutorials on using the INDEX formula. Turn data into results with free tools, templates, and tutorials!

Redesigning This Copywriting Tool | Spreadsheet Redesign

Changing the "feelings wheel" into a spreadsheet.

Easiest Mistakes to Make In Spreadsheets

The most fundamental mistake beginners make when working in spreadsheets. But once you know what this mistake is, We can recognize it and we can recognize when we're making this mistake. I'll show you some very simple changes that you can make to your spreadsheets as you're making this mistake.

Breaking Down a Billion Dollar Google Sheet

Did you know there are 1.5 billion Google Sheets users and that billionaires also use Google Sheets? There's a bunch of billionaires in this sheet. Jeff Bezos, Elon Musk, and Yuri Milner.

Automatic Weekly Backup of Google Sheets

How can we create backups of Google sheets every week or every day or every month?

Can ChatGPT Automate Spreadsheets?

Automate Google Sheets! Learn to create custom add-ons, decipher code, and automate daily tasks using Apps Scripts. Optimize your spreadsheets.

Think Like a Programmer | Develop The Mindset of an Apps Script Coder

•Don't memorize. Know where the information is •Read the documentation •Try things. Go for it! •Seek out errors.

Automate Google Sheets without Apps Script, without Zapier

I've been doing a lot in spreadsheet automation using Apps Script. But I wanted to go back to some formulas that I think feel like magic. They make me feel like a wizard without having to code.

Google Sheets Error: Unknown Range Name and How to Fix it

A user asked me about an error, which is the "Unknown Range Name." By the time you’ve read this tutorial, you’ll know how to fix this error. What is the Unknown Range Name error? It’s an error that you get when the value that was

Most Common Errors and How To Handle Them in Google Sheets

Most Common Errors and How To Handle Them in Google Sheets #N/A error #REF! error #NAME? error #DIV/0! Error #VALUE! Error #NUM! error #NULL! error

Organize Your Data! - Build a Kanban Board / Trello Board

Effortlessly organize tasks using Google Sheets! Learn impressive formulas, create Kanban/Trello boards, and optimize your life and workflow.

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and then you copy and paste it into your sheet and it has the wrong delimiter. How do you resolve that?

Make It Easier For Others To Use Your Google Sheets

In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.

Ken Asks Can We Add Star Ratings in Google Sheets?

Learn to use data validation, emojis, and various scripts for a captivating visual representation of data. Explore easy ways to add star ratings in Google Sheets.

This Week in Better Sheets - Feb 12th, 2023

Make your sheets better 1% every day. Google Sheets can be boring. It can get complicated. But it doesn’t have to be. Here at Better Sheets, we don’t just make them better. We make them more fun, too.

Sell Daily – Unleash the power of language with this game-changing Google Sheets template

Sell Daily – 366 words that sell. Get access to absolutely unique 366 words that will help you sell. No duplicates!

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Make your data tasks simpler & efficient. Discover the power of automation in Google Sheets with a comprehensive guide that covers everything from triggers to scripts.

How to Gain Confidence in Google Sheets

Boost your confidence, master formula usage and overcome errors in this step-by-step guide. Join us to demystify spreadsheets.

How can I count true and false?

Master the art of counting 'true' and 'false' in Google Sheets with this detailed guide. Uncover pitfalls to avoid & learn powerful functions.

Make More Money Selling Google Sheets

Transform Google Sheets into a profitable side hustle. Learn to create, enhance, and sell Google Sheets products.

Google Sheets Locales. What are they?

Hello, Better Sheet members and non-Better Sheet members! This tutorial is about every locale listed in Google Sheets. If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and

100 Business Ideas Using Google Sheets

What is 100 Business Ideas? This is a free Google Sheet containing business ideas. These ideas are ones that you can start by selling a Google Sheet of your own.

Upsides and Downsides of Google Sheets Conditional Formatting

Format your data based on certain conditions. Learn how to use Conditional formatting to quickly identify patterns and trends in your data. But there are downsides to Conditional formatting too.

Filter a Database in Google Sheets based on Dates, Checkboxes, and Dropdown selections!

In today’s tutorial, we’ll be answering the question from Mohamed. The question is “How do I filter a database in Google Sheets based on dates, checkboxes, and dropdown selections?”

Brutal Calendar - Craigslist Edition 2023

I designed a calendar that looks like early Craigslist. I'm calling it "Brutal Calendar, Craigslist edition 2023." The video version of this tutorial was first released for Better Sheets members. You can watch that here. Members can access, copy, and preview this sheet for free. Why

The story behind Sell Daily: How I built a Google Sheet template for powerful words

Here are 366 words to help you sell. These words can be used in tweets, emails, promotions, and even Facebook ads. Sell Daily is a list of words that jumpstarts your promotional muscles. This sheet and this set of words are meant to be used one a day.

The Best Alternative to Google Sheets is Google Sheets

If you find yourself frustrated with Google Sheets, it is likely due to a lack of knowledge and understanding of the software's features and functions.

How to Use Checkboxes for Approvals, and Change the Checkbox Text

Learn how to customize checkboxes for various uses, create rating systems, add dropdown menus, and more. Explore the creative possibilities of Google Sheets!

Beginners Make This Spreadsheet Mistake All The Time!

Today I'm going to explain the most fundamental mistake beginners make when working in spreadsheets. No matter what you use – Google Sheets, Microsoft Excel, Apple Numbers, or Libra Office – you might be making this mistake.

5 Magical Ways To Use the IF() Formula in Google Sheets

5 ways to use the IF function in Google Sheets ISBLANK() Checkbox AND() OR() IF(IF())

Why I Want A One Cell Google Sheet

I’ve been using 1-cell sheets for a while now. And I use 1 column sheets too. Or 2 column sheets. So here are the reasons I use it and can imagine you can use little, tiny, small sheets too.

Google Sheets Green Color Hex Code

Google Sheets Green Color Hex Code! Dive into #0F9D58, Google's vibrant shade of Green. The green color code you'll want to use in all your designs if you're google sheets adjacent.

Anything is Possible in Google Sheets, But Not Everything

Uncover automation techniques, learn to overcome challenges, and explore sharing features. Discover the limitless possibilities of Google Sheets !

Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script

Five increasingly difficult ways of explaining spreadsheets in Google Sheets: The basics of Google Sheets text Menu items in Google Sheets Math inside Google Sheets Using Formulas in Google Sheets Apps Script in Google Sheets

Google Sheets Introduces New Dropdown Chips Feature in 2022

Google Sheets introduced dropdown chips, a new feature that allows users to create and customize dropdown menus in their sheets. In this article, we will explain how to use dropdown chips.

You Can Build a Business with just a Google sheet!

Discover how to launch business ideas using Google Sheets with our FREE tutorials, templates, and tools. Unleash your potential today!

Email Yourself a Cell from a Google Sheet, Every Day

I'll show you how to email yourself one single cell data. That's one sheet, one cell, one email every single day.

How Do I Capitalize Each Word in Google Sheets?

You want to capitalize each word in your google sheets cells. Sometimes it's called Proper or Title Case or Sentence Case. We have lots of options but only one formula does it in Google Sheets. That is PROPER().

The Google Sheet Add-on That Can Save You From Headaches

See Google Sheets in a whole new light! The most eye-strain reducing add-on for Google Sheets, ever. Improve your productivity and increase your happiness in Google Sheets.

Extract URLs from Google Sheets

Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.

5 Simple Ways to Take Your Google Sheets to the Next Level, Right Now

Five Quick Things You Can do Right Now to Fix your Google Sheets Change your font Add more space Hide the gridlines Change font size Fix your Sheets from the glare

How to Make an Interactive To Do List In Google Sheets

We’re making an interactive to-do list and we’re going to make it come alive! And it won’t even take you five minutes to learn this cool trick. Read more below and find out how it works.

How do I insert emojis into Google Sheets?

Inserting emojis into Google Sheets is common, and fun, way to make Google Sheets more personal. You can use Emojis for bullets points, or headers, or to convey direction to a Google Sheets user.

Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users

If you know how to code, you'll learn in this step-by-step tutorial how to code in Google Sheets.

I Made an Escape Room in Google Sheets to Learn Shortcuts

I made an escape game, in a Google Sheet. It teaches 3 Google Sheets keyboard shortcuts that you can use to literally escape spreadsheet hell. 1. Discover how to navigate around a spreadsheet quickly with your keyboard. 2. Discover how to reveal underlying formulas hiding within the cells. 3. Learn

Spreadsheets Explained over 5 Levels of Difficulty

Master Google Sheets from simple text input to complex operations with our FREE tutorials, templates, and tools! Unleash the full power of spreadsheets now!

Roasting Google Sheets

Dive into Google Sheets with Expert Insights. Free Tutorials, Templates & Tools Await You. Enhance Your Skills Today!

Find New Additions to a Main List in Google Sheets

Learn to add new names to an existing list in Google Sheets. Discover clever, time-saving formulas that simplify your workflow.

Build A Business: PR Agency in a Google Sheet

Unlock the power of Google Sheets. Start a PR agency! Discover how to curate web content, track stats, code email service, and sell sheet access for profit.

Absolute Basics of Google Sheets

Learn from scratch: What are rows, columns, and cells in Google Sheets? Master basics, tips & tricks in 3 videos. Get started now!"

Figure Out Frequency of Numbers

Discover how to figure out the frequency of numbers, product IDs, text, emails and much more! Essential tips and tricks revealed.

Make $3,000 a Month with Google Sheets

How to make $3,000 a month. No coding, no consulting. We're gonna make a business and we're gonna do it all in Google sheets.

Making SaaS in A Google Sheet

Unlock 100 business ideas with our FREE tutorials and tools. Learn to sell spreadsheets, create a headline generator, and more using Google Sheets!

10 Ways to Promote Your Google Sheet

Discover 10 unique ways to sell and promote your Google Sheet! This blog offers free tools, templates, and tutorials to expand your network and boost your sales.

You Can Launch A Business with a Google Sheet

Discover how to launch a business using Google Sheets in this blog. Learn from practical examples. Kickstart your business now!

Hide Gridlines

Boost your sheet readability. Hide gridlines for clearer views and discover more tips in our free blog post. Learn and enhance your spreadsheet skills.

How to Use Alternating Colors to make a Summary Page

Learn how to use Alternating Colors, avoid formula parse errors, and design impressive Google Sheets.

Font Colors That Don't Make Your Eyes Bleed

This tip is to give your eyes a rest. If you work in sheets hours each day, the high contrast black and white grid starts to hurt.