Excel (Windows)

How to connect your tukan query to Excel in Windows?

Getting the connection URL

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.


Connecting Excel

Open an Excel spreadhseet, and perform the following instructions:

  1. Select the Data tab.

  2. On the upper-left side of the panel, select the option Get data (from web).

  3. A pop-up will appear with an input text box. Paste your connection string into the box and select OK.

  4. Finally, validate the preview and load it into your spreadsheet.

Connecting your tukan query to an Excel spreadsheet (Windows).

That's it. Your query should appear within a few seconds on your spreadsheet 🥳.


What's next?

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.

Last updated

Was this helpful?