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

# Excel: Retrieve data from CDF

> Connect a Cognite Data Fusion project as a data source and use Excel to query, transform, and visualize CDF data.

<span translate="no">Microsoft Excel</span> fetches data using <span translate="no">Cognite</span>'s [<span translate="no">OData</span> services](/cdf/dashboards/references/odata/index). To authenticate to <span translate="no">CDF</span> in <span translate="no">Excel</span>, your <span translate="no">CDF</span> project must use <span translate="no">Microsoft Entra ID</span> as the identity provider (IdP). Before users can sign in with their organizational ID and retrieve data from <span translate="no">CDF</span>, an administrator must register and consent for your organization to use [<span translate="no">**Microsoft Power Query for Excel**</span>](/cdf/dashboards/guides/powerbi/admin) app registration.

Follow these steps to use a <span translate="no">CDF</span> project as a data source in <span translate="no">Excel</span>:

<Steps>
  <Step title="Open OData Feed connection">
    In <span translate="no">**Excel**</span>, select <span class="ui-element">Data</span> > <span class="ui-element">Get data</span> > <span class="ui-element">From Other Sources</span> > <span class="ui-element">From OData Feed</span>.
  </Step>

  <Step title="Enter the OData Feed URL">
    Enter the <span class="ui-element">URL</span> for the <span class="ui-element">OData Feed</span> you want to connect to. If you are a guest user in the <span translate="no">Entra ID</span> directory, you may also have to add the <span translate="no">Entra</span> tenant ID as a query variable, for example, `oDataUrl?tenantID=MyEntraIDTenant.onmicrosoft.com`.

    <Frame>
      <img src="https://apps-cdn.cogniteapp.com/@cognite/docs-portal-images/1.0.0/images/cdf/dashboards/powerbi/update2024/Excel1_v1.png" alt="Authentication " width="80%" />
    </Frame>
  </Step>

  <Step title="Sign in with your organizational account">
    In the <span class="ui-element">Authentication</span> dialog, select <span class="ui-element">Organizational account</span> and then <span class="ui-element">Sign in</span> with your organizational ID.

    <Frame>
      <img src="https://apps-cdn.cogniteapp.com/@cognite/docs-portal-images/1.0.0/images/cdf/dashboards/powerbi/update2024/Excel2_v1.png" alt="Authentication " width="80%" />
    </Frame>
  </Step>

  <Step title="Connect to the data source">
    Select <span class="ui-element">Connect</span>.
  </Step>

  <Step title="Select the data to transform">
    Select a table, for instance, <span class="ui-element">Time series</span>, and then select <span class="ui-element">Transform Data</span>.

    <Info>
      A table can contain hundreds of thousands of entries. Don't select <span class="ui-element">Load</span> unless you want to load all entries.
    </Info>

    <Frame>
      <img src="https://apps-cdn.cogniteapp.com/@cognite/docs-portal-images/1.0.0/images/cdf/dashboards/powerbi/update2024/Excel3_v1.png" alt="Authentication " width="80%" />
    </Frame>
  </Step>

  <Step title="Transform the data">
    Transform the data with the <span translate="no">Power Query Editor</span>.
  </Step>
</Steps>
