Build practical AI skills. Bring new possibilities to work.Explore training

{How to} use code interpreter on customer uploaded files in agent conversations in copilot studio

Hello Everyone,

Today I am going to share my thoughts on the use of the code interpreter on customer-uploaded files in agent conversations in copilot studio.

Let’s get started.

Your chatbot (agent) can take a user upload during a chat and automatically analyze it using code, then return results within the same conversation.

What actually happens behind the scenes

1.  User uploads a file

Examples:

Excel (.xlsx)

CSV (.csv)

Sometimes JSON or text files.


2. The agent receives the file

The file is passed into the conversation as:

System.Activity.Attachments

3. Code Interpreter kicks in

Copilot Studio:

Generate Python code automatically

Runs it in a secure environment

Uses it to:

  • Read the file
  • Analyse data 
  • Create outputs


4. The agent responds with results

The bot sends back:

  • Charts
  • Tablets
  • Insights
  • Summaries

Example flow:

Real example

User says:

“Analyze this sales spreadsheet”

What the agent does:

  • Reads the Excel file
  • Groups sales by month
  • Calculates totals
  • Generates a chart

Response:

“Revenue increased 18% in Q3. Here’s a breakdown…” + chart

Why this feature is useful

  • No manual coding needed
  • Works in real-time conversations
  • Turns your agent into a data analyst
  • Great for:
    • Customer uploads
    • Business reports
    • Data exploration

 In one sentence

It lets your Copilot Studio agent act like a Python-powered data analyst that can read and analyze files users upload during chat.

Important notes

  • Best with structured data (Excel, CSV)
  • Requires:
    • File upload enabled
    • Code Interpreter enabled
  • Has file size and type limits

That’s it for today.

I hope this helps.

Malla Reddy Gurram aka @UK365GUY