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.
The official ClickHouse ODBC driver must be installed before making a connection from Excel. For more information, see Clickhouse ODBC Driver Installation for Windows
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.