Step-by-Step Guide to Using Analytics in a Google Spreadsheet

By Oudi Antebi  |  Posted 2009-02-12 Print this article Print

Step-by-step guide to using analytics in a Google spreadsheet

The following are four steps you need to follow in order to use Google Spreadsheets for data analysis.

Step No. 1: Choose your spreadsheet

If you are already using Google Spreadsheets, you are one step way from getting started with using it for analytics. If you use other spreadsheet applications, just log in to your account (if you don't have one, it is very easy to create it) and select "upload." Then, select your spreadsheet from your desktop.

Step No. 2: Ensure your data is formatted correctly for analysis

To use a spreadsheet for analytics, it's important to have a very simple layout. In other words, be sure to have a first row that contains the headers for each column. Below the first row, be sure to clearly list all the pertinent information and data. For example, under the "Product" header (see screenshot below), you should have a long list of product names or SKU numbers. Then, under the "Date" header, you should have dates and so forth.

Step No. 3: Insert the analytics component

In Google Spreadsheets, select "Insert" and then "Gadgets." Gadgets are the way Google delivers advanced functionality in their spreadsheet and other applications. On the left side of the new window that comes up, chose "Tables." Now you will see "Analytics for Google spreadsheet." Click on "Add to spreadsheet."

Oudi Antebi is Vice President of Marketing and Strategy for Panorama, a Business Intelligence software provider. A specialist in BI marketing and product development, Oudi is responsible for Panorama's long-term business strategy. Oudi can be reached at

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel