Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - General
Unanswered

How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

(1) ShareShare
ReportReport
Posted on by 8

Hello, I have a favor to ask the community. I have an Excel file that contains 2 columns. "Abkürzung" which means initial in German and "Bedeutung" which means meaning. My aim is that with the Microsoft Copilot Studio software, in Teams I can integrate the Excel file and then if a user wants to know the meaning of an initial, the software will look it up in the Excel file and come up with the meaning. This saves the bot creator a lot of time by not having to handwrite the initials and meanings. Is this clear to you, and if so, how do I know if it's possible?

Categories:
  • AlwinV225 Profile Picture
    8 on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    In fact, when I test it, it shows me directly in my channel on Teams, but when I want to activate my bot in my channel, it doesn't respond. Why is this?

  • AlwinV225 Profile Picture
    8 on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello @Jcook @theMac 

     

    I've already managed to work on my flow on Power Automate from Microsoft Teams. That's the first thing I've done, but the problem is that, according to the screenshot you can see, my flow works but when I test it by asking for initials, it doesn't return anything. Do you think you know why?

  • AlwinV225 Profile Picture
    8 on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello

    Regarding your message @Jcook, I've checked under AI feature and there's nothing that allows to load a file in Microsoft Copilot Studio from Teams unfortunately.

     

    @theMac, I had already tried with Power Automate with your idea but I got error messages. I'd have to review my model again to get it to work again. But with your link, it might work.

     

    Thank you both for your replies. I hope it works, but if it doesn't, I'll get back to you 😀

  • theMac Profile Picture
    on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Unless there have been recent developments, Copilot's AI does not work well with structured data in tables while it is much better with unstructured data (text in word, pdf with a lot of text, etc.).
    To do what you are asking, you can use copilot by calling up a flow of Power Automate, without bothering the AI: in Power Automate you will do the matching in the Excel file by providing the initials as input and it will return the corresponding string to copilot as output.
    Please note that in excel the data must be structured in a table with headers in the first row (it is not enough to have entered them in a simple excel sheet)
    See here:
    https://powerusers.microsoft.com/t5/General/Copilot-and-PowerAutomate-Excel-get-a-row-function/m-p/2667682#M9844

  • Jcook Profile Picture
    7,770 Most Valuable Professional on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hi @AlwinV225 

     

    Should be under AI features. Some UIs are different depending on region and settings.

  • AlwinV225 Profile Picture
    8 on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello @Jcook 

    Thank you for your message, but in the "Settings" sidebar of my chatbot in Microsoft Teams, there is only :

     

    • Details
    • AI integration tools
    • Channels
    • Engagement hub
    • Security
    • Skills
    • AI features

     

    There's no "Generative AI" in the settings, so no "Upload a document" (preview) and I searched for a while anyway.

     

    Is there a particular reason for this?

  • Jcook Profile Picture
    7,770 Most Valuable Professional on at
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hi @AlwinV225

    you can follow this guide from the docs:

    https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-documents#uploading-a-document

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Copilot Studio - General

#1
Pablo Roldan Profile Picture

Pablo Roldan 49

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 48

#3
stampcoin Profile Picture

stampcoin 10

Overall leaderboard