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

# Microsoft Excel

> Access your live data directly from within your favorite spreadsheet tool. This guide will take you through the steps for connecting Excel to your data.

<Info>
  Before you begin, [create a workspace](https://app.enhanza.com/register) and complete the onboarding.
</Info>

## Local driver or Power BI?

There are two alternative methods to connect Excel to your data.

| **Way to connect** | **Pros** 👍🏼                                                                | **Cons 👎🏼**                         |
| :----------------- | :--------------------------------------------------------------------------- | :------------------------------------ |
| **Local Driver**   | Don't require licens for Power BI.                                           | Need ODBC-driver. More complex setup. |
| **Power BI**       | More stable. Native within Microsoft tools. Refresh data from Excel for web. | Require licenses for Power BI.        |

<Tip>
  We encourage you to explore the possibilities with [Google Sheets,](/external-bi-tools/google-sheets) as an alternative to Microsoft Excel. Sheets is a more modern and fully cloud based tool. We will be happy to help you get started.
</Tip>

## Local driver

### Overview

These are the steps you take to access your data from Excel.

<Steps>
  <Step title="Prepare a Service Account">
    This will confirm that you should have access to your sensitive data.
  </Step>

  <Step title="Install Driver">
    The ODBC driver will create a connection between Excel and Enhanza.
  </Step>

  <Step title="Connect from Excel">
    Now can you can easily connect directly from within Excel.
  </Step>
</Steps>

<ServiceAccount />

### Install Driver

1. Download and install [ODBC drivers for Bigquery](https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers).

   <Note>
     Make sure to select the correct version (32-bit or 64-bit) based on the version of your Microsoft Office. [What version of Office am I using?](https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19#OSVersion=Windows)
   </Note>
2. Open the Windows software “ODBC Data Sources”
3. Go to tab “System DNS”, click “Add” and add these details:
   * *Data Source Name*: **Enhanza**
   * *Description*: [**app.enhanza.com**](http://app.enhanza.com)
   * *oAuth Mechanism*: Select “Service Account”
   * *Service Authentication*: The service account email that you generate above.
   * Click `Browse…` and locate the .json file that you created above.
   * *Catalog (Project)*: Select "**enhanza"**
   * *Dataset*: Select any. Doesn’t matter which.
   * Click `Test…` If success, click “OK” on all open dialogue windows.

### Connect from Excel

1. Open Excel. Go to `Data` > `Get Data` > `Other data sources` > `ODBC`
2. Select `Enhanza` and click `OK`

   <Note>
     At this stage, you can also choose to write a custom query to get the exact data you need. Enhanza Support team can you help you with that if needed.
   </Note>
3. In the next dialogue window (if appears), select tab `Default or Custom` and click `Connect`.
4. Now you have all you [connected data source](https://app.enhanza.com/data-sources) in Enhanza available.

## Power BI

Connecting Excel to existing datasets in Power BI is a smooth sailing.

1. [Connect Power BI to Enhanza](https://docs.enhanza.com/external-bi-tools/microsoft-power-bi)
2. Publish the local *.pbix* file to Power BI services
3. [Connect Excel to Power BI](https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel)