Friday, September 11, 2009

QUERY Function for Google Spreadsheets

André “Ahab” sent in this news bit (URLs shortened):

Google Docs added a new powerful function to its spreadsheets: the QUERY function. This function allows SQL-like queries using the Qviz Gviz syntax (albeit a bit limited version: only directly referenced ranges can be used and column IDs always have to be column letters). Think of QUERY as a next version of the already very powerful Google Docs specific FILTER function.

If you wished Google Docs spreadsheets should be a bit more accessible like a database, this function is a wish come true. It does not turn your spreadsheet into a full database – you can’t use SQL like inserts, updates and deletes – but as a way to pull data fom one’s sheet of data QUERY is unsurpassed because of its build-in versatility.

See: www.google.com/support/forum/p/G... Look for the post of Google Docs Guide Christine at [September] 8, 2009 and following posts.

See also the Google Docs spreadsheet help on the Query function: docs.google.com/support/bi... and the [related] information on the Qviz Gviz Query Language syntax as used by the QUERY function: code.google.com/apis/visualiz...

[Thanks Ahab!]

QUERY Function for Google ... by Philipp Lenssen | Comments (3)

>> More posts

Advertisement