Chat with your Excel data

AI to analyze Excel data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Excel
You
How many rows came into the sales worksheet this month?
Excel
The sales worksheet holds 1,284 rows for the current month, up from 1,141 in the previous one.
Via Kondado MCP
You
Is the budget control above or below target this quarter?
Budget
The budget worksheet sits at 92% of target, and 3 of 8 cost centers are already above plan.
Via Kondado MCP
You
Which salesperson has the highest total in the Excel sheet?
Ranking
Marina Alves leads with $318,400, 21% ahead of the second place in the ranking.
Via Kondado MCP
You
How many orders in the operations sheet are still pending?
Operations
37 orders are still marked as pending, and 12 of them are past the 5-day SLA.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

Try out all the features for free for 14 days

AI to analyze Excel data with Claude and ChatGPT

With Kondado, any worksheet of your Excel file becomes a data source that Claude, ChatGPT or another MCP client can read in chat. You open the conversation, describe what you need in plain language and get the number back with the calculation already done, no formulas or pivot tables involved. Typical questions include how many rows of the sales control were filled this month, which budget line is furthest from its target, or how a KPI compares with the previous quarter.

Kondado exposes Excel data to Claude, ChatGPT and any other MCP client through an MCP server, turning a worksheet into 1 pipeline that the assistant queries in chat. Setup is GUI-based: add the Kondado MCP server in the client connection settings and authorize once via OAuth at app.kondado.com.br. The same Excel data also powers ready dashboards in Power BI and Looker Studio.

Marketing analysts, e-commerce managers and finance or operations teams use this to answer questions that used to require opening the file and filtering rows by hand. They ask which region missed its target last quarter, how many orders are still marked as pending in the operations control, or what the average ticket was over the last 30 days. The assistant answers from the replicated worksheet, so the conversation stays about the business question, not about the spreadsheet mechanics.

Try out all the features for free for 14 days

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Excel data by Kondado in minutes.

View Excel dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Excel data in natural language.

View MCP setup →

Try out all the features for free for 14 days

The pipeline listed below is what feeds every question you ask in chat about Excel. The Spreadsheet pipeline reads any worksheet of a file stored on OneDrive or SharePoint: the first filled row becomes the header and each title becomes a column, so fields such as date, salesperson, target, actual and status are ready to query. Ask which cost center drifted from plan and the assistant returns the column and the value behind the answer. Combine the worksheet with other pipelines in your Kondado workspace, or with a second Excel file, to cross-check a budget against real spend or a target list against actual results. Updates follow a configurable schedule, so each new replication run keeps the answers in chat aligned with the latest version of the file.

How to connect Excel to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT

Try out all the features for free for 14 days

AI vocabulary

Excel tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

1
Table
∞
Ad-hoc questions
Spreadsheet (worksheet)
Each row represents a row of the selected Excel worksheet, with the Excel row number and a text column for each header title from the first filled row, using a normalized name.
Full docs on the wiki → Connect Excel now →

Try out all the features for free for 14 days

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Excel on Kondado

Sign in to app.kondado.com.br, connect your Excel file from OneDrive or SharePoint and choose a Via Kondado destination, so the worksheet lands ready for AI access and for the dashboard templates.

2
Add the Kondado MCP server

In Claude Web or Desktop, or in ChatGPT, open the connection settings, add the Kondado MCP server and authorize once via OAuth. The setup is the same in both clients, with no CLI or code.

3
Ask in chat, open a dashboard

Ask your question in natural language about the Excel worksheet and read the answer in the conversation. For recurring visual monitoring, open a ready Power BI or Looker Studio dashboard template.

Try out all the features for free for 14 days

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Amazon Ads Amazon Ads
Apple App Store Apple App Store
Bing Bing
ChatGPT Ads ChatGPT Ads
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Stripe Stripe
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Sólides DP Sólides DP
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can Claude or ChatGPT answer about my Excel data? ▼
You can ask about totals, averages, counts and rankings on any column of the worksheet, such as total sales per salesperson, average ticket per month or how many rows carry a given status. The assistant reads the replicated worksheet and replies in natural language with the figure and the filter it applied. Follow-up questions work in the same thread, so you can narrow from a quarter down to a single week without rewriting the request.
How do I add Kondado to Claude Web or Claude Desktop? ▼
Open the connection settings in Claude, choose to add an MCP server and enter the Kondado server address. Claude then opens an authorization screen at app.kondado.com.br, where you confirm access to your Kondado workspace. The same flow exists in ChatGPT, and other MCP clients follow the same pattern: add the server, authorize once, start chatting.
How does the OAuth authorization work when I connect a client? ▼
You sign in to app.kondado.com.br during the authorization step and confirm which workspace the client can read. The client keeps that permission, so you do not repeat the process on every conversation. If you connect a second client later, you authorize it separately in the same screen.
Can the AI change values or write to my Excel file? ▼
No. The chat is read-only and analytical: the assistant queries the replicated worksheet and returns answers, but it does not edit cells, add rows or send anything back to the file. Every change to the spreadsheet stays in Excel, under your control.
How often is the Excel data in chat updated? ▼
Replication runs on a configurable schedule that you define in Kondado, ranging from hourly to daily depending on your plan and needs. Each run refreshes the worksheet data the MCP client reads. If you need an answer that reflects a change made minutes ago, start a new replication run in Kondado and ask again.
Which dashboard templates are available for Excel data? ▼
Kondado offers report templates for Power BI and Looker Studio that read the same replicated worksheet. They suit targets, budget tracking and operational controls that a team reviews on a recurring basis. You open the template, point it at your Kondado data and let the replication schedule keep the visuals current.
What is the difference between asking in chat and opening a ready dashboard? ▼
Chat is for ad-hoc questions: you describe what you need and get one answer at a time, which suits investigations and quick checks. A ready dashboard is for recurring visual monitoring, with the same indicators on screen every week for a team. Both read the same Excel data, so the numbers stay consistent between the conversation and the report.

Try out all the features for free for 14 days