Share via

"How to develop a custom Data Connector for Excel to access external Data Sources?

Michał Tomczak 0 Reputation points
2025-03-28T14:41:02.95+00:00

We would like to create a custom connector for Excel, just like those ones for Salesforce:
User's image

I only found solutions about adding a new connector to PowerBI (https://learn.microsoft.com/en-us/power-query/install-sdk) but not to Excel. How to add a custom data source to Excel?

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
    2025-03-31T01:34:50.9533333+00:00

    Hi,

    I suggest you try to use From Data Connection Wizard option in Excel, this method will help you create ODBC connection in Excel for external data source:

    User's image If you cannot find the Legacy Wizards option, please go to File- Options- Data- check the Legacy connection options:

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.