Dashboards in minutes

Connect Excel to Cortex: Dashboards in Minutes

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

Connect Excel to Cortex

Kondado connects your Excel files to Cortex so your spreadsheets become visual dashboards. Paste the address of a file stored on OneDrive or SharePoint, choose the worksheet, and Kondado reads the first filled row as the header, turning each title into a column. Cortex then receives that data on the schedule you choose, such as every 5 minutes, hourly, or daily. No code, no intermediate databases, no complex setup. Business users can follow results without opening the spreadsheet, and charts, cards, and trend lines stay aligned with the file your team maintains.

1
available pipeline
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

Kondado turns any worksheet from your Excel files into a Cortex dashboard in a few clicks: paste the file address, pick the worksheet, set the update frequency, and your team sees budgets, targets, and registries as charts instead of rows.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Excel data available in Cortex

Each item below is automatically replicated by Kondado from Excel into Cortex — no schema setup, no manual mapping.

1
available pipeline
∞
Auto-refresh

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

The Spreadsheet (worksheet) pipeline brings each row of the selected worksheet into Cortex, with the Excel row number plus a text column for every header found in the first filled row. That means a monthly budget, a sales targets sheet, or a campaign registry can each power its own dashboard. Marketing teams track planned versus spent by channel, operations teams follow inventory levels and delivery counts, and finance teams watch budget lines against actuals. Charts, cards, and trend lines turn those rows into decisions your team can act on.

Try out all the features for free for 14 days

How to create Excel dashboards in Cortex

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Excel as a data source

Add Excel as a data source in Kondado and paste the address of the file stored on OneDrive or SharePoint. Pick the worksheet, and the first filled row becomes the header for your columns.

2
Select Cortex as destination

Choose Cortex as the destination for your Spreadsheet (worksheet) pipeline. Kondado sends the worksheet data straight to Cortex, with no intermediate databases and no complex setup.

3
Build dashboards and set refresh

Create charts and cards in Cortex from the columns you need, then set the update frequency in Kondado, from every 5 minutes to daily. Your dashboards stay current on the schedule you choose.

Access Excel data in Cortex and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Excel data in other BI tools

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

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

Frequently Asked Questions (FAQ)

Answers about visualizing Excel data in Cortex automatically

How do I connect an Excel file to Cortex on Kondado? ▼
Add Excel as a data source in Kondado and paste the address of the file stored on OneDrive or SharePoint. Choose the worksheet you want to follow, and Kondado reads the first filled row as the header, so each title becomes a column. Then select Cortex as the destination and publish your first dashboard.
How often does the data in Cortex update? ▼
You set the frequency yourself: every 5 minutes, every 15 minutes, hourly, daily, or another interval that fits your routine. Kondado then refreshes the data in Cortex on that schedule, so your charts follow the latest version of the worksheet. For monthly budget reviews, a daily update is often enough, while operational tracking usually calls for shorter intervals.
Which KPIs can I track with Excel data in Cortex? ▼
It depends on the worksheet, but teams commonly follow budget versus actual spend, sales targets against results, campaign costs, inventory levels, and monthly revenue. Because each header becomes a column, any numeric column in your sheet can become a chart, card, or trend line in Cortex.
Can I build dashboards without technical skills? ▼
Yes. Cortex works with drag-and-drop charts, and Kondado handles the data connection for you, with no code and no intermediate databases. You pick the worksheet, and the columns appear ready to use in your charts, so marketing, operations, and finance teams build their own views.
Can I start from a ready-made dashboard for my Excel data? ▼
Dashboards in Cortex are built around your own worksheet, so you decide which columns become charts, which totals appear as cards, and how the page is organized. Kondado keeps the data flowing on your schedule, and you shape the view around the questions your team asks.
Can I share a Cortex dashboard with my team? ▼
Yes, dashboards in Cortex can be shared with colleagues so everyone follows the same numbers. Combine a shared view with a scheduled update and your team sees consistent figures for budgets, targets, or registries without trading spreadsheet versions.
Can I combine Excel data with other sources in the same dashboard? ▼
Yes. Kondado connects 80+ data sources, so you can create pipelines from several sources and visualize them together in Cortex. If a different destination fits the team better, you can also send data to Google Sheets, BigQuery, or Power BI.
What happens when the Excel file gets new rows? ▼
Each update reads the worksheet again, so new rows and edited values appear in Cortex on the next scheduled refresh. The first filled row stays as the header, and each row keeps its Excel row number, which helps you trace a chart point back to the sheet.

Try out all the features for free for 14 days