Google Sheets

Google Sheets Updates

Google Sheets mention · June 12, 2019

How DonorsChoose.org Uses Zapier to Streamline Meetings and Email Campaigns

"Zapier saves me at least two hours for every mass email we send."Danielle Curtis, Senior Donor Relationships Associate, DonorsChoose.org When you're overseeing weekly and monthly team meetings and managing email outreach to hundreds of people, it's inevitable that something will slip through the cracks. You're...read more
Google Sheets mention · May 17, 2019

How an eCommerce Store Uses Bonjoro & Zapier to Connect with Customers

"Considering we're a small team, we've probably saved one hour each day using Zapier and Bonjoro. "Andreas Lodahl, eCommerce Manager, Munk Store When you run an eCommerce business, you're caught between two worlds: the faceless mega-brands like Amazon and the brick and mortars where customers can get...read more
Google Sheets mention · April 25, 2019

If the Pomodoro Technique Doesn't Work for You, Try Flowtime

Finding the perfect productivity system is like finding the perfect recipe. Sometimes, a recipe with a really high rating tastes terrible. Sometimes, you find a comment that suggests adjustments, and those adjustments take it from mediocre to outstanding. And sometimes, you only use the recipe as a guide, modifying it...read more
Google Sheets mention · April 15, 2019

Why You Hate Every To Do App (And How to Find Something That Works)

How many abandoned to do lists do you have? I'm talking about apps you've installed, added some tasks to, then promptly forgot to actually use. Abandoned bullet journals and sticky notes you never look at also count. You tried to implement a system. It didn't work. And...read more
Google Sheets mention · April 12, 2019

How Gyms Use Front and Zapier to Communicate with their Members

Whether it's CrossFit, barre, Orangetheory, Camp Gladiator, martial arts, yoga, or anything in between, group exercise has exploded in the last decade. And with the advent of ClassPass, it's easier than ever for anyone to try something new. So how can a gym owner retain new members when...read more
Google Sheets mention · April 8, 2019

Organize Your Life with the Agile Method

A to do list can help you keep track of the tasks you need to complete. But when it comes to actually completing those tasks—that's a different story. It's hard to decide which tasks to take on first, and it's tempting to start with whatever's...read more
Google Sheets mention · March 14, 2019

How a VP of Tech Saved his Company $15,000 with Automation

"With Zapier, we believe we've saved thirty developer days, which equates to at least $15,000."Dan Savino, VP of Technology at SelectQuote Insurance Services A seamless customer experience makes a profound impact for a user. It lends trust and authority to a brand, which easily translates to customer...read more
Google Sheets mention · March 8, 2019

How Three Entrepreneurs Use Automation to Run Efficient Businesses

In 2018, American Express's annual State of Women-Owned Businesses report estimated that women started roughly 1,821 businesses every day. Compare that to the numbers from 2012-2017 (~952), and you see an increase of nearly 100%. In fact, 40% of all businesses are now owned by a woman, and...read more
Vicky Volvovski
Written by Vicky VolvovskiLast updated March 22, 2018

Before we had spreadsheet software, people spent hours calculating budgets or their company’s future earnings on paper. If they wanted to change a single number, they’d better have a big eraser. This, of course, was extremely manual and error-prone. In 1979, the first spreadsheet software was born. Then came Microsoft Excel, which became the gold standard in business tools. In 2007, Google launched Sheets and brought the spreadsheet into our browsers.

You can, of course, use Sheets for traditional number-crunching. If you’re trying to figure out the budget for your upcoming family vacation, Sheets will do the job. But it can also do so much more, like create beautiful and informative charts and graphs automatically, organize information captured in forms, or act as a CRM for your business.

If you’re familiar with Excel, you’ll understand Sheets quickly. The app uses much of the same terminology (cells, columns, rows, ranges, and so on), and also supports formulas. Google Sheets Formulas can be used to calculate numbers, manipulate data, and more. Want to know the average amount you’ve spent on groceries over the past three years? Use the AVERAGE function to find the answer quickly. Or maybe you’ve got one spreadsheet with product price and another spreadsheet with product inventory levels—you need to combine the two datasets based on a key identifier like product name, and don’t want to waste time looking up, copying, and pasting the information. You can use the VLOOKUP function to find information in one spreadsheet and put it in the right row in another.

In addition to the standard formulas, Sheets also has many unique functions that leverage Google’s other tools and only work because it's an online spreadsheet app. For example, you can use the GOOGLETRANSLATE function to translate text from one language to another. Or IMPORTFEED to import an RSS or ATOM feed right into your spreadsheet.

Or, you can let Google Sheets make sense of your data for you. Open the Explore tab in the lower right corner to see answers Google Sheets has found from your data and suggested graphs it thinks organize the data well. Make sure it's comparing the correct values—but often, the graphs and tips it recommends can be a helpful way to learn from your spreadsheet info.

If you need something beyond the available functions, you can use the Google Apps Script to build custom macros, or “add-ons,” that do whatever you want. With a little JavaScript, your add-on can highlight or automatically delete duplicate rows in a spreadsheet (all done within Sheets) or it can add contacts from a sheet to Google Contacts (creating automation between multiple Google Apps). Once you've built your add-on, you can publish it to the Google Sheets add-on store—or, check it first, as there may already be an add-on with the feature you want.

Perhaps Sheets' best feature is that it’s online—you don’t need to download any software to use it. All the data in your spreadsheets is saved automatically, so you never lose changes. You can download spreadsheets in Excel or PDF formats before shipping it to someone else. You can even download a Chrome add-on to open, edit, and save Excel files without needing to do any conversion. It also has apps for iOS and Android, so you can get work done anywhere.

If you need to collaborate or share information with a family member or coworker, all you need is their email. You can give view-only or editing permissions to your collaborators, and see their updates and changes in real time—no more sending documents back and forth and losing the most up-to-date version. You can even make a publish spreadsheet to let anyone help. When working on a spreadsheet together, you can add comments to specific cells or chat right within the document. All communication stays in the spreadsheet and never gets lost. Google Sheets saves every version of every change made so you can undo edits or archive versions of your document to see how things changed over time.

If you’re looking for a more productive way to crunch numbers, manipulate data, visualize information in charts and graphs, and efficiently collaborate with others, Sheets will work for you. It's a new take on the original spreadsheet that can help you work from anywhere, faster.


Learn more about Google Sheets with our guides to Google Sheets' advanced features:

Originally published November 9, 2015; updated March 22, 2018 with new screenshots and features including Explore pane.

Have any feedback on this overview, or something we should change? Let us know!

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn More