# Excel Import Integration Deprecated

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](https://docs.treasuredata.com/smart/project-product-documentation/odbc-driver-for-presto) instead of following these instructions.

Using Excel with Treasure Data allows users to interactively explore huge amounts of data.

# Prerequisites

- Windows 7, 8.1, or later (Mac OS X is not supported)
- Excel 2010, or later


## Install ODBC Driver

Install Treasure Data [ODBC Driver](https://docs.treasuredata.com/smart/project-product-documentation/odbc-driver-for-presto), 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.

![](/assets/image-20191016-163829.58081513c65c12b19e83b825b706bed487c0e4f833a721a73002643e0e4c77e7.c098c3cc.png)

## Set up the Connection from Excel to Treasure Data

### Set up ODBC Connection

Open Excel and under the DATA section, click “From Other Sources”, and select “From Data Connection Wizard”.

![](/assets/image-20191016-163838.45a29bd7c452494bff8cc86cb356eee1438ea99b2ed8a5690f2b0c63db9f9d24.c098c3cc.png)

Then, select “ODBC DSN”.

![](/assets/image-20191016-163848.99252fdde232429c85f71ee1bd5ecaf28101982ee3f30a4030b64d51085281b2.c098c3cc.png)

And, select “TreasureData (on your own DSNNAME)”.

![](/assets/image-20191016-163906.581d46b9f721d8d4bd94f8026e0139dd374c73c2e4aaf0536388247f06ee857a.c098c3cc.png)

Then, you can select your tables from the list.

![](/assets/image-20191016-163915.55ff0d4102a47e34b34151ffd211b4c166c59d1deb62128db62872abec378a8f.c098c3cc.png)

Next, click Finish. An Import Data dialog pops up.

![](/assets/image-20191016-163922.fb9f704b8dfb57c18ed835d8882175c11a5a96e2ce7fb4b8385919ebe46992f4.c098c3cc.png)

### Import Data via ODBC Driver

When you import the data, you may choose a Table, a PivotTable Report, or a PivotChart

![](/assets/image-20191016-163930.73e4f7c0c196d4dfc75b4d53c5ca367e4614b24802cdf408bf645aead6285589.c098c3cc.png)

Set up the query to get data from Treasure Data via Properties.

![](/assets/image-20191016-163939.2476ee0fdc8fc4c5c6a40c741a0c26b56042d52c217b24ca0ec3c5f559afa684.c098c3cc.png)

The following picture shows data after selecting the PivotTable Report.

![](/assets/image-20191016-163949.4d9598d3ec155196d30c47ed8c591851664f8c1abf25170857c26ff073cdec58.c098c3cc.png)

You may modify your query within Connection Properties.

![](/assets/image-20191016-163958.707d75fd232044055d347f96f7c58a66cea626aeeaa6c2a3b63d8c9e674a45e0.c098c3cc.png)