Skip to main content

Notifications

Community site session details

Community site session details

Session Id : TTxsrPgfwCWwUpMAUgo004
Copilot Studio - General
Answered

can copilot read data from Excels?

Like (0) ShareShare
ReportReport
Posted on 24 Feb 2024 21:55:37 by 72

I have created a bot, and provided a sharepoint site as it knowledge base. When I asked questions related a table embedded in Power Point, the bot seems to be able to read data from there, when I asked questions related to an invoice status file in xlsx format, the chatbot also says it doesn't know the answer. How shall I store structured data in this case?

 

  • adilei Profile Picture
    on 01 Mar 2024 at 12:15:17
    Re: can copilot read data from Excels?

    Remy's LinkedIn post is awesome, but keep in mind that like Gen Answers, it relies on a search-based pattern. This is not the best pattern to support analytical questions. For example - "how many invoices are unpaid" is not a question that can be easily answered just by analyzing search results. 

  • Verified answer
    Jeanxyz Profile Picture
    72 on 01 Mar 2024 at 12:04:02
    Re: can copilot read data from Excels?

    Here is some demo which may solve the problem.

    (1) Chat with your data using ONLY the Power Platform | LinkedIn

  • Jeanxyz Profile Picture
    72 on 26 Feb 2024 at 09:23:10
    Re: can copilot read data from Excels?

    yes, I would like copilot to search xlsx by invoice ID provided by user. I realize later that if I load the xlsx file to the chatbot, the bot can retrieve information, but there are two problems: 1) the bot only answers correctly when user provides invoice id which is a unique key, also user has to ask very specific questions to get the answer, 2) the xlsx file doesn't get refreshed automatically in this case. So I'm now thinking about loading the xlsx file to Power APP (using one drive for business connector) and link Power App to copilot. Any help on this approach will be appreciated. 

  • adilei Profile Picture
    on 26 Feb 2024 at 05:24:53
    Re: can copilot read data from Excels?

    What would be the context for the copilot's action? Will users ask about a specific invoice? Search for unpaid invoices?

  • Jeanxyz Profile Picture
    72 on 25 Feb 2024 at 21:34:11
    Re: can copilot read data from Excels?

    I have an Excel file, which contains customer name, invoice ID, invoice date, due date, outstanding amount, related sales order id et. I would like chatbot to read the data in Excel, find the relevant line of data,  run LLM analysis and generate answers like: the invoice was sent out 2 months ago, it looks it's not paid yet, maybe you should sent a reminder to customer xxx. 

     

  • adilei Profile Picture
    on 25 Feb 2024 at 11:40:23
    Re: can copilot read data from Excels?

    Gen Answers over SharePoint does not currently support XSLX files (see below), but even if it did, its purpose is to generate answers over unstructured data sources, whereas (depending on the use case) an Excel spreadsheet is more like a database. Can you elaborate on the use case?

     

    adilei_0-1708861101129.png

    https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-boost-node#supported-content

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Copilot Studio - General

#1
Ekta Gupta Profile Picture

Ekta Gupta 4

#2
ricardodesouza Profile Picture

ricardodesouza 2

#2
L-1234567-0 Profile Picture

L-1234567-0 2

Overall leaderboard