Google Sheets Archives

How to Create and Use a Dropdown List in Google Sheets

June 10, 2021May 27, 2021

By default, entries into unlocked cells in Google Sheets care freeform. You and any editors you share a Sheet with can type or paste any numbers, letters or symbols into an unlocked cell.

Even images can be entered into Google Sheets cells.

This is one of the aspects of spreadsheets that makes them different from database applications — a lack of rigor.

But it is possible to enforce the entry of only certain values in Google Sheets cells with by creating an in-cell dropdown list.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

How to Use Google Sheets as a Free RSS Reader

May 7, 2021September 26, 2020

Google Sheets can be used as a free RSS (and Atom) reader.

The Sheets IMPORTFEED function allows you to create a self-updating repository of blog & news article content that you can easily share with your social media followers.

In this post, we’ll explain how this works. We will also provide you with a link to a sample Google Sheet that you can copy and adapt to the RSS feeds that most interest you, your customers and your social media followers.

We’ll show you how to create Google Sheets formulas for one-click social sharing of blog posts and articles on Twitter, LinkedIn and Facebook.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

How To Remove Duplicates In Google Sheets

May 26, 2021February 19, 2020

There are a number of cases in which you may want to remove duplicates from a list of records using Google Sheets.

For example, you may want to remove duplicate records before importing a list of leads into a CRM system such as Salesforce—or into a marketing automation system like ActiveCampaign.

Despite all of Google’s human and artificial intelligence capabilities, Sheets does not have a very sophisticated deduplication logic… yet.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

Bitcoin vs Gold in Google Sheets

May 19, 2021January 30, 2019

Updated: January 16, 2021

Google Sheets, available as part of both consumer Gmail and organization-wide Google Workspace, allows users to easily create trend charts based on any source that can be connected to a Google Sheet.

The GOOGLEFINANCE function for Bitcoin was not working for a time, but seems to be working again now. You can “set and forget” the function—cells will auto-populate or auto-update at regular intervals.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

6 Business Data Sources To Feed Into Google Sheets

May 7, 2021September 9, 2018

There are a variety of add-ons and built-in functions for seamlessly and automatically pulling business data into Google Sheets from external sources.

Once business data is in Sheets, it can be manipulated an analyzed in a number of ways.

Here are six functions and add-ons for importing information into Google Sheets. All six are free of charge.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

Google Sheets and Microsoft Excel: Moving Data Between The Two

May 7, 2021April 20, 2018

Let’s begin with a distinction between Google Sheets & Microsoft Excel:

– Microsoft Excel is a spreadsheet application that is a part of Microsoft Office 365.

– Google Sheets a spreadsheet app that is available with free consumer Gmail and also with Google Workspace (formerly G Suite).

Some people use only one or the other. Other people use both.

If a Google user who does not have Excel installed receives an Excel spreadsheet via email, the user can preview the spreadsheet within Gmail and then convert the spreadsheet to Google Sheets.

There are several ways to move spreadsheets and spreadsheet data between Google Sheets and Microsoft Excel. Here are examples of Google Excel information exchange.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

GOOGLEFINANCE Function In Google Sheets

May 7, 2021September 13, 2017

The GOOGLEFINANCE function is part of Google Sheets. Google Sheets is available in both consumer Gmail and organization-wide Google Workspace. The function allows users to create trend charts and comparisons for any assets that have a valid Google Finance ticker symbol.

Here are several examples of how the GOOGLEFINANCE function can be used in Google Sheets to compare the performance of stocks and indexes against one another.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

Embed a “Live” Google Sheets Pricing Table in a Proposal Doc

May 7, 2021June 11, 2017

For salespeople who regularly send out long form proposals that contain pricing tables, there has always been a conundrum.

That is, a pricing table within in a document can’t be dynamically updated as easily as a spreadsheet table. The word processing capabilities within a spreadsheet are limited.

Often, a proposal’s pricing table is revised several times before the final version of a proposal is sent to the prospect or customer. This can require manual effort. Either the new bottom line in the document table needs to be hand calculated when line items are changed — or the spreadsheet table must be re-copied/pasted a into the document.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

What is Google Sheets and How Does it Work?

May 7, 2021January 1, 2017

Google Sheets is one of the productivity applications that’s included with free consumer Gmail and with Google Workspace [for business].

It is a cloud based spreadsheet application. No desktop software is needed to create and edit spreadsheets. Spreadsheets are stored in the cloud, on a virtual drive called Google Drive.

Google Sheets can be used for everything from basic calculations to sophisticated data analysis.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

Google Analytics Reports in Google Sheets – Using Filters

November 14, 2020August 6, 2016

One of many benefits to using Google Workspace is that Google Workspace users with access to their organization’s Google Analytics account can easily share specific slices of Google Analytics data with their co-workers.

The Google Analytics Add-on for Google Sheets lets a Sheets user who has a Google Analytics login create a variety of comparative visualizations within Google Sheets.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→

Publishing Pivot Table Charts to Your Website With Google Sheets

May 7, 2021June 23, 2015

We used SurveyMonkey Audience to collect data about what CRM systems were deployed at organizations across the U.S. The main question we asked in the survey was “What is your organization’s primary CRM system?”

After the survey finished its run, SurveyMonkey provided us with a CSV file of the survey results from approximately 750 respondents. The first thing we did was to upload the CSV file to Google Drive and then open the file with Google Sheets. Once we had the data in Google Sheets, we were able to easily create pivot tables and associated charts.

[Read more…]

Google Workspace makes it easier to run your business and get work done.

Google Workspace Free Trial Info→