How to Sort

To sort columns of data from the API, we suggest using the "filter views" Google Sheet feature.

Please check the following video for a complete example:

To summarize, the steps are:

  • Populate data columns with DataCommons Sheets API
  • Turn on filter views (Data > Filter views).
  • Click the reverse triangle on each column to sort by that column (and exclude header row).