Data connector

Send Excel data to AI, reports, spreadsheets and ETL

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 files hold the operational detail many teams rely on every day: budget vs actual sheets, sales targets by region, campaign calendars, expense registries, inventory counts and project trackers. With Kondado, you can read any worksheet from an Excel file stored in OneDrive or SharePoint by pasting the file address. The first filled row becomes the header, and each title becomes a column in the pipeline output. This makes spreadsheet data available for analysis outside Excel without rebuilding the file.

Try out all the features for free for 14 days

For this Excel data source, Kondado provides 1 pipeline and 0 fields: Spreadsheet (worksheet). Each row in the pipeline represents a row from the selected worksheet, includes the Excel row number, and creates one text column for each header title found in the first filled row using a normalized name.

Marketing teams use worksheet rows to track campaign spend and channel performance, data analysts compare budget versus actuals across departments, and operations teams monitor inventory counts, reorder points and project milestones. By sending worksheet data to a dashboard or database, these roles can build recurring views of target attainment, cost variance, sales coverage and weekly status updates. Analysts can also combine Excel rows with data from other sources to enrich financial and operational reporting.

The Kondado platform takes care of refreshing Excel data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Excel data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

Below is the Excel pipeline available in Kondado for reading worksheet data. The Spreadsheet (worksheet) pipeline reads budget vs actual sheets, campaign trackers, sales target sheets, inventory counts and expense registries, gaining insights into cost variance, channel performance, target attainment, stock levels and spend by category. Combine worksheet data with other pipelines in the same destination to compare plans against execution, reconcile departmental budgets or track operational KPIs across teams. With updates on a configurable schedule, from every 5 minutes to daily, your Excel-based KPIs stay current in custom dashboards, spreadsheets and database tables. This gives marketing, analytics and operations teams a shared view of spreadsheet plans and results. You can also blend worksheet rows with CRM, finance or inventory pipelines to enrich the analysis.

Connector schema

Available Excel data

1
available pipeline

Available integrations

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.

Try out all the features for free for 14 days

How to visualize Excel data in 3 steps

Connect Excel to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

1
Add Excel with Microsoft 365 OAuth

In Kondado, add Excel as a data source and authenticate with OAuth for Microsoft 365 to access OneDrive or SharePoint files. Paste the file address and select the worksheet you want to read.

2
Choose worksheet pipeline and destination

Select the Spreadsheet (worksheet) pipeline and send it to a destination such as Google Sheets, BigQuery, PostgreSQL, Power BI or Looker Studio.

3
Visualize in dashboards, sheets, databases

Build custom dashboards in Power BI or Looker Studio, analyze rows in Google Sheets, or query replicated tables in BigQuery or PostgreSQL.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use Excel data

Choose a tool to visualize your Excel data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Excel to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What types of Excel files can I read through Kondado? ▼
Kondado reads worksheets from Excel files stored in OneDrive or SharePoint after you authenticate with Microsoft 365 OAuth. You paste the file address, choose the worksheet, and the first filled row becomes the header row for the pipeline. This works for budget files, campaign trackers, target sheets, inventory logs and expense registries that follow a header-based layout.
How do I connect Excel to Kondado? ▼
Add Excel as a data source in Kondado and complete the Microsoft 365 OAuth flow to authorize access to OneDrive or SharePoint. Then paste the Excel file address and select the worksheet you want to read. Kondado creates the Spreadsheet (worksheet) pipeline using the first filled row as column titles, with no code required.
How often can Kondado update data from Excel? ▼
You can set each Excel pipeline to update on a configurable schedule, from every 5 minutes to once daily. Choose a frequency that matches how often your worksheet changes, such as hourly for operational trackers or daily for budget and planning files. This keeps downstream dashboards and database tables aligned with your reporting rhythm.
Can I build Power BI or Looker Studio dashboards from Excel data? ▼
Yes, send the Spreadsheet (worksheet) pipeline to Power BI or Looker Studio to build custom dashboards for budget variance, target attainment, campaign performance and inventory levels. You can also route the same data to Google Sheets for spreadsheet-based analysis. Teams often combine these views with other pipelines to compare spreadsheet plans against operational results.
Can I send Excel worksheet data to BigQuery or PostgreSQL? ▼
Yes, replicate Excel worksheet rows to BigQuery or PostgreSQL for SQL analysis and joins with other business data. You can also send the pipeline to MySQL, Redshift, SQL Server or Amazon S3 if those destinations fit your stack. The Excel row number is included so analysts can trace records back to the source worksheet.
What analyses can I run with Excel worksheet rows in Kondado? ▼
Use worksheet rows to compare budget versus actuals, track sales target attainment by region, monitor campaign spend by channel, review inventory reorder points or reconcile expense categories. Combine the Excel pipeline with other data sources in BigQuery or Looker Studio to enrich financial and operational analysis. Custom dashboards can refresh on your configured schedule so teams review current spreadsheet data outside Excel.
Does Kondado support Excel files shared in SharePoint and OneDrive? ▼
Yes, the Excel data source uses Microsoft 365 OAuth to access files stored in OneDrive or SharePoint. Paste the shared file address and select the worksheet you need, and Kondado reads the first filled row as headers. This lets teams analyze shared planning files, departmental trackers and campaign calendars without moving the original workbook.

Try out all the features for free for 14 days