1. Querying specific rows of the spreadsheet

*** This page is deprecated. Please click here for the new version ***

Use the Google Visualization Query Language to show only a specific subset of your data in the table.

Here is a non-exhaustive list of the benefits of using a query:

  • Show only some columns

  • Change the column's order

    • Select rows using a condition

Note: Beware, for now, queries doesn't work if you use the Proxy feature.

Note 2: Column IDs in spreadsheets are always letters; the column heading text shown in the published spreadsheet are labels, not IDs. You must use the ID, not the label, in your query string. This also applies to Awesome Table queries.

Example

In this example we going to use a spreadsheet which list colors and their nuance. We want to display only red color and gradient of red color in the Awesome Table view. If you want to do this go to the Advanced parameters -> Query when you are in the settings panel, here you can write some queries like this: select * where C = "Red".

You can filter by text, dates, numbers,... Here are a few examples of queries:

select * where dayOfWeek(H) = 2

select * where L >= 50

select * where dateDiff(H, now()) > 0

select * where dateDiff(H, now()) > 0 or H is null

select * where I contains 'Script'

select * where dateDiff(H, now()) + 30 > 0

select L order by A desc limit 20

select L where dateDiff(A, now()) + 30 > 0 order by A desc

select L where (month(now()) = month(A)) AND (year(now()) = year(A)) order by A desc