---
schema_version: "1"
id: 19e3fb7c144f1682e37d94f17c6b3b04c184377a2e97af99a36d5c669fa26421
title: Create External Credentials for the Microsoft 365 Excel Online Connector (Beta)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/excelonline/c360-a-excelonline-cred.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-excelonline-cred.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 3086f13e6fdfd9408e7daeb6819fe98fd80fe7e10f9a9cfe425ffddf4a28e168
products:
  - Data 360 Integration Guide
  - Data 360 Developer Documentation
---
# Create External Credentials for the Microsoft 365 Excel Online Connector (Beta)

To ingest data from Microsoft 365 Excel Online to Data 360, set up an external credential for Microsoft 365 Excel Online.

Before you begin:

- Create an [OAuth based authentication](https://help.salesforce.com/s/articleView?id=data.c360_a_setup_oauth_openid.htm&type=5) for OpenId or for [Microsoft](https://help.salesforce.com/s/articleView?id=data.c360_a_setup_oauth_microsoft.htm&type=5) in Setup, before completing these steps.

1.  From Setup, in the Quick Find box, enter `Named Credentials`. Then select **Named Credentials** (1).

    ![namedcredential definition](https://developer.salesforce.com/media/NamedCred_13Aug2024.png)

2.  On the External Credentials tab (2), click **New**.

    1.  Enter a label and name for your external credential. The name can’t contain spaces. You can use underscores.

    2.  For Authentication Protocol, select **OAuth 2.0**.

    3.  For Authentication Flow Type, select **Browser Flow**.

    4.  For Authentication Provider, select the provider you created.

    5.  Click **Save**.

3.  Add principal to external credentials

    1.  In the external credentials that you created, under Principals, click **New**.

    2.  Enter the parameter name. You can include spaces.

    3.  For Identity Type, select **Named Principal**.

    4.  Set the Sequence Number to `1`.

    5.  Click **Save**.

4.  Authenticate your external credentials.

    1.  Under Principals, from the Actions dropdown menu, select **Authenticate.**

    2.  Follow the authentication flow and confirm access permissions.

    3.  To connect Data Cloud to Microsoft 365 Excel Online, click **Allow**.

        After you authenticate, the status changes to Configured.

5.  Define the named credential.

    1.  In the Named Credentials Tab, click **New**. Then enter a label and name. The name can't contain spaces, but you can use underscores.

    2.  For the URL, enter `https://www.365excelonline.microsoft.com`.

    3.  For external credentials, select the credential that you created.

    4.  Click **Save**.

6.  Enable external credentials access.

    1.  From Setup, in the Quick Find box, enter `Profiles`. Then select it.

    2.  Click **System Administrator**.

    3.  On the Enable External Credential Principal Access tab, click **Edit**.

    4.  Add the external credentials principal that you created to the Enabled External Credentials Principals column.

    5.  Click **Save**.

## Next Step

- [Set Up a Microsoft 365 Excel Online Connection (Beta)](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-set-up-excelonline-connection.md)