ClickHouse ODBC Connection for Microsoft Excel
Users who have completed the process in installing the official ClickHouse ODBC driver for Microsoft Windows can connect Microsoft Excel to a ClickHouse database.
Prerequisites
The official ClickHouse ODBC driver must be installed before making a connection from Excel. For more information, see Clickhouse ODBC Driver Installation for Windows
Connection Steps
To connect Microsoft Excel to a ClickHouse server through the ClickHouse ODBC driver, follow these steps:
-
Launch Microsoft Excel.
-
Open a new or existing Workbook.
-
Select Data -> Get Data -> From Other Sources -> From ODBC.
-
Select the ODBC connection created, then OK.
-
Provide the username and password for the connect, then select Connect.
-
If successful, the ClickHouse server with the databases and tables granted to the user will be displayed.
Feedback
Was this page helpful?
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.