Google Sheets

How to Use Google Sheets: 10 Tutorials

Read content specific to Google Sheets. Discover how to get started, browse popular zaps, solve common problems, and more.

Google Sheets is a powerful online spreadsheet, but what if your data currently lives in another app like Microsoft Excel or in a different format like CSV or TXT? Here's how to import your data into Google Sheets. We'll start with manually uploading a file, then show you...read more
Maybe you need to plug your data into desktop software without Google Sheets integration. Maybe you need to share your data with someone who doesn't use Google Sheets. Or maybe you just want an offline copy of your spreadsheet for future reference. Whatever the reason, sometimes you're going...read more
Charts and graphs are so helpful because they turn abstract numbers into something that can be understood at a glance. Google Sheets makes it easy to create charts or graphs out of numbers in your spreadsheet. Begin by highlighting the data you want to include. (Don't worry if you...read more
Adding columns and rows in Google Sheets is a two-click process. Open your spreadsheet, and follow along below to see how it's done. How to Add columns in Google Sheets Step 1: Click anywhere in the column that's next to where you want your new column. Step 2...read more
Spreadsheets house massive amounts of data. You can use pivot tables to summarize that data, but what if you want to gain some insight just by glancing at your sheet? Conditional formatting in Google Sheets will give you that insight. Conditional formatting—which allows you to highlight cells that meet...read more
Let's say you have a list of email addresses that you collected through a form on your website. You want to know how many email addresses you received, but you're worried that someone may have filled out the form twice, which would inflate your numbers. When you're...read more
Spreadsheets offer powerful analysis capabilities, but sometimes it feels like they're missing that extra layer of insight. When there's a massive amount of data, it's tough to summarize or draw conclusions from a basic tabular spreadsheet view. Enter: the pivot table. Most Excel power users employ pivot...read more
Google Calendar events keep you and your team organized and on track. But creating events on Google Calendar can be tedious when you do it repeatedly. Not to mention, manually entering dates and times can make for human error and inaccurate calendars. Instead, you can use Google Sheets and workflow...read more
Humans are great at processing images, making connections between words and concepts, and remembering obscure trivia. But we're bad—really bad—at mentally processing and storing accurate, easy-to-use data sets. We invented Data Tables—more commonly known today as spreadsheets—to organize arrays of information that our brains can...read more

Getting Started with Zapier