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 Docs.google.com 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."