Google Sheets

Check out the Google Sheets getting started guide

Tips and Tricks

Quickly Copy Data to Multiple Row or Columns

By dragging the small dot in the bottom, right-hand corner of a highlighted cell across or down a range of cells, you can perform a number of different functions:

Copy a cell's data to a number of neighboring cells
Copy a cell's formula to neighboring cells
Create an ordered list of text data

Import Your Data from Excel or CSV Files

You can either import directly onto your current spreadsheet, create a new spreadsheet or replace a sheet (i.e. an individual tab) with imported data. The most common files you'll import are CSV files.

Copy and Paste Formatted Text from a Webpage

Often websites organize their information using tables. As a result, you can often copy and paste them into Sheets and retain the formatting.

Top Sheets Add-ons

Add-ons are an easy way to add powerful functionality to Google Sheets.

Here are some of our favorites (If you've got one you love, please share it!):

Power Tools - One-click solutions for daily tasks: split cells, remove duplicates, change case, find and clean up data, work with formulas & more.
GMath for Sheets - Create graphs (including plotting points) and write complex math directly in your Google Sheet. You can use these to create a Form!
Merge Sheets - Combine data from multiple sheets.
Remove Duplicates - Quickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results.