Feed your copilots with Excel data in Copilot Studio πŸ” πŸ“ˆ

Want to know how to extend Microsoft Copilot and build your own Copilots with the data in your Excel spreadsheets? Well stick around friends because in this super quick and simple post, I’ll show you how to take those rows and rows of cell… READ MORE [https://lewisdoes.dev/blog/feed-your-copilot
clear mannequin on blue background
Photo by Tara Winstead on Pexels.com
In: Low Code Lewis Content πŸš€

Want to know how to extend Microsoft Copilot and build your own Copilots with the data in your Excel spreadsheets? Well stick around friends because in this super quick and simple post, I’ll show you how to take those rows and rows of cell based data and have your Copilot take all of that into account when having a conversation with you!

What is Copilot Studio?

So for some background… Copilot Studio is a new product from Microsoft that allows you to customize Copilot for Microsoft 365 and build your own standalone copilots using natural language or a graphical interface. Copilots are intelligent assistants that can help you with various tasks, such as writing code, creating content, or answering questions.

Uploading an Excel Spreadsheet

Okay so now let’s take a look at what I can do in Copilot Studio to have my copilot answer questions about my Excel data. On the generative AI tab I have an area where I can upload documents.

So I’m simply going to upload this Excel file of data for classes in my school and their average grades.

Now check it out, I’ve got my Excel file uploaded.

Testing it out!

Now check this out… I can ask the copilot questions about my Excel data that I’ve uploaded! πŸš€

Written by
Lewis Baybutt
Microsoft Business Applications MVP β€’ Power Platform Consultant β€’ Blogger β€’ Community Contributor β€’ #CommunityRocks β€’ #SharingIsCaring
Great! You’ve successfully signed up.
Welcome back! You've successfully signed in.
You've successfully subscribed to LewisDoesDev.
Your link has expired.
Success! Check your email for magic link to sign-in.
Success! Your billing info has been updated.
Your billing was not updated.