Warning The Presto ODBC driver is deprecated in June 2025. There are no plans to provide updates to the ODBC driver in the future; consider using the OSS Trino JDBC Driver.
Install the Presto ODBC Driver instead of following these instructions.
Using Excel with Treasure Data allows users to interactively explore huge amounts of data.
- Windows 7, 8.1, or later (Mac OS X is not supported)
- Excel 2010, or later
Install Treasure Data ODBC Driver, and register to your machine. We’ll assume that you have DSN (Data Source Name) as Treasure Data in the following sections.
For Excel, set td-presto as the database name.
Open Excel and under the DATA section, click “From Other Sources”, and select “From Data Connection Wizard”.
Then, select “ODBC DSN”.
And, select “TreasureData (on your own DSNNAME)”.
Then, you can select your tables from the list.
Next, click Finish. An Import Data dialog pops up.
When you import the data, you may choose a Table, a PivotTable Report, or a PivotChart
Set up the query to get data from Treasure Data via Properties.
The following picture shows data after selecting the PivotTable Report.
You may modify your query within Connection Properties.
