Excel with Treasure Data (Experimental)

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

Untitled-3
We have a new ODBC driver for working with Excel! Please reach out to support@treasure-data.com to get set-up. The following driver & instructions are no longer actively supported.

Table of Contents

Prerequisites

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

Install ODBC Driver

Please 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, please set td-presto as the database name.


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”.



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 will pop up.



Import Data via ODBC Driver

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



Set up the query to get data from TreasureData via Properties.



The following picture shows data after selecting PivotTable Report.



You may modify your query within Connection Properties.




Last modified: Jul 05 2016 04:05:57 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.