Google Sheets

Tips & Tricks for using Google Sheets

GOOGLEFINANCE
GOOGLEFINANCE fetches current or historical securities information from Google Finance. Sample Usage GOOGLEFINANCE("GOOG","marketcap&...
Mon, 23 May, 2016 at 6:06 PM
GOOGLETRANSLATE
GOOGLETRANSLATE translates text from one language into another. Sample Usage GOOGLETRANSLATE("Hello World","en","es") ...
Mon, 23 May, 2016 at 6:06 PM
IMAGE
IMAGE inserts an image into a cell. Sample Usage IMAGE("https://www.google.com/images/srpr/logo3w.png") IMAGE(A2,2) IMAGE(A2,4,120,2...
Mon, 23 May, 2016 at 6:07 PM
IMPORTDATA
IMPORTDATA imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Sample Usage IMPORTDATA("http://www.ce...
Wed, 10 Dec, 2014 at 8:36 PM
IMPORTFEED
IMPORTFEED imports a RSS or ATOM feed. Sample Usage IMPORTFEED("http://news.google.com/?output=atom") IMPORTFEED(A2,B2,C2,D2) Syntax IMP...
Wed, 10 Dec, 2014 at 8:38 PM
IMPORTHTML
IMPORTHTML imports data from a table or list within an HTML page. Sample Usage IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India"...
Wed, 10 Dec, 2014 at 8:41 PM
IMPORTRANGE
IMPORTRANGE imports a range of cells from a specified spreadsheet. Sample Usage IMPORTRANGE("abcd123abcd123", "sheet1!A1:C10") IMP...
Wed, 10 Dec, 2014 at 8:43 PM
IMPORTXML
IMPORTXML imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Sample Usage IMPORTXML("...
Wed, 10 Dec, 2014 at 8:46 PM
QUERY
QUERY runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FAL...
Wed, 10 Dec, 2014 at 8:49 PM
SPARKLINE
Charts in Google Sheets are really useful when you want to visualize data sets with context and descriptions along with them. But if you just want a quick l...
Wed, 10 Dec, 2014 at 8:51 PM