> ## Documentation Index
> Fetch the complete documentation index at: https://help.peliqan.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Excel (ODBC)

You can use MS Query or Power Query in Excel to connect to the Peliqan data warehouse.

Note: MS Query and Power Query (with DB connection) are only available in Excel on Windows, not Mac.

<Note>
  As an alternative, you can also use the Peliqan[Excel add-in](/excel-add-in)
</Note>

# Enable ODBC in Excel (Legacy)

In Excel > File > Options > Data: enable legacy data import wizards, see screenshot below:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/excel_options_legacy_data.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=40682f4d7c5b9240111781f8460cf99d" alt="excel options legacy data.png" width="1022" height="835" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/excel_options_legacy_data.png" />

# Install Postgres ODBC driver on Windows

Download the Postgres ODBC driver:

[https://odbc.postgresql.org/](https://odbc.postgresql.org/)

Choose the [64 bit version (X64)](https://ftp.postgresql.org/pub/odbc/releases/REL-17_00_0006/psqlodbc_x64.msi) for recent computers.

# Add a DSN

Open ODBC Database Administrator on Windows (64 bit version if you are using a recent computer). Add a User DSN, choose PostgreSQL Unicode:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/dsn_postgres.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=0943cc9a560b3e72779c6511edc5cd18" alt="dsn postgres.png" width="561" height="426" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/dsn_postgres.png" />

Add the connection details of your Peliqan data warehouse:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/dsn.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=f4856c5b496e82b81f3ebc333ddab069" alt="dsn.png" width="653" height="359" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/dsn.png" />

Use “allow” for SSL Mode.

# Add a connection in Excel

In Excel, go to Data > Get Data > From Other Sources > ODBC > Select your DSN.

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/Schermafbeelding_2025-10-01_111834.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=aa5994d875fd04fbb0d08a1f3dcaea67" alt="Schermafbeelding 2025-10-01 111834.png" width="554" height="589" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/Schermafbeelding_2025-10-01_111834.png" />

Next, select tables and/or queries from Peliqan to load in Excel.

\<aside><br />💡

If you want to work with queries written in Peliqan, make sure to set the option “Create as view” in Peliqan for that query, so that it is visible in the data warehouse and hence in Excel.

\</aside>

The selected tables will be loaded in Excel and can be refreshed at any time:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/data_in_excel.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=7476d8c35ae8088283c1133d692e104c" alt="data in excel.png" width="1412" height="810" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/data_in_excel.png" />

You can also use Power Query in Excel.

In Excel go to Power Query > New Source > Other Sources > ODBC > Select your DSN.

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Excel%20(ODBC)/power_query.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=64f1f6eca5fa012779368d54d0822333" alt="power query.png" width="1534" height="435" data-path="images/Connect your BI, DB tool or iPaaS/Excel (ODBC)/power_query.png" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.