GQLx (BETA)

GQLx is a SQL-like query language for Google Doc's spreadsheets that allows you to access and update a spreadsheet using statements such as:

  • SELECT * FROM MySpreadsheet;
  • INSERT INTO MySpreadsheet VALUES('One','Two','Three');
  • UPDATE MySpreadsheet SET Desirable='Yes' WHERE Available='No';
  • DELETE FROM MySpreadsheet WHERE Available='No';

This release is available in several flavours:

  • an online Javascript console
  • a Java Swing application
  • a Java console application

From here - but only once you have read the WARNING below - you probably want to read the Getting Started guide and then play with the online console.

If you like what you see and feel like you want more then the downloads section has the full reference manual and also the standalone Java applications ... have fun !

WARNING

This is an almost-out-of-alpha release so please read the waivers and demurrers. To save you the trouble of clicking on the link, here's the gist:

  • use it entirely at your own risk
  • expect the unexpected
  • be gentle with it

In the event of a catastrophe you can always revert to a previous version so experimenting is unlikely to result in destruction of life as we know it.

However, it is probably not such a good idea to use it for your air traffic control or hadron collider spreadsheets.

DISCLAIMER

Despite the catchy name and the fact that it exists solely because Google Doc's spreadsheets do, this project is not in any way endorsed by Google.

It should also not be confused with GQL which is the Google App Engine query language used to access Google's BigTable.

LICENSING

GQLx is currently licensed under a GPL 2.0 license.