How To Use Google Spreadsheets IMPORTDATA Function

Using the CSV URL of your query results you can easily import query results directly into Google Spreadsheets, using the IMPORTDATA function. The CSV URL along with the API Key, can be found when clicking on the "Show API Key" button in the query menu:

In the dialog which opens, you will find a CSV URL similar to: https://app.redash.io/acme/api/queries/123/results.csv?api_key=secret, which you input to the IMPORTDATA function:

=IMPORTDATA("https://app.redash.io/acme/api/queries/123/results.csv?api_key=secret")

Still need help? Contact Us Contact Us