Google Spreadsheet Query Language

I should’ve known, Google has a strong API for querying Google Spreadsheets like databases.  You can even do the queries right within a doc.  For instance, if I want to get all the “MR” rows from the TASI sheet in our timelog, I can create a new sheet and in cell A1 enter this formula:

=QUERY(‘TASI’!A1:F8000, “select A,B,C,D,E,F where B = ‘MR'”)

The query language is very robust and SQL-like:

This entry was posted in Blog, Google Apps / GMail. Bookmark the permalink.

Comments are closed.