Excel (Windows)
How to connect your tukan query to Excel in Windows?
Last updated
How to connect your tukan query to Excel in Windows?
Last updated
Once you've created your query, head over to the queries module, and click on the export button for the query you wish to connect.
Next, select the Excel tab and click the Copy link button to copy the query's "connection string" to your clipboard.
This "connection string" is what will allow Excel to connect directly to our database and ensure you always have the latest data available in your spreadsheet.
Please note that this is only done the first time you connect a query. Once you've established the connection, you only need to refresh the feed to get the latest data...
Open an Excel spreadhseet, and perform the following instructions:
Select the Data tab.
On the upper-left side of the panel, select the option Get data (from web).
A pop-up will appear with an input text box. Paste your connection string into the box and select OK.
Finally, validate the preview and load it into your spreadsheet.
Playing around with the data.
The process we followed imports your data as a Table in Excel. In case you modify your query, or wish to extract the latest data; simply hit refresh on the Table module.
That's it. Your query should appear within a few seconds on your spreadsheet .