Dashboards in minutes

Connect Excel to Metabase: 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 Metabase

Kondado connects your Excel spreadsheets to Metabase so your team can explore numbers without opening a single file. You paste the address of the workbook stored on OneDrive or SharePoint, choose the worksheet you want, and Kondado reads the first filled row as the header to organize each title into its own column. The data then flows into Metabase, where you build charts, filters and dashboards from the same numbers your team already tracks. You decide how often the data refreshes, from every 5 minutes to once a day.

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 stored in OneDrive or SharePoint into a Metabase data source in a few minutes, with no code and no intermediate database. Your budget, targets and registries stay up to date on a schedule you choose, so every chart in Metabase reflects the latest version of your spreadsheet.

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 Metabase

Each item below is automatically replicated by Kondado from Excel into Metabase — 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

With the Spreadsheet pipeline, each row of your chosen worksheet becomes a row in Metabase, and each header title becomes a column. That means a budget worksheet, a sales target sheet or a monthly expense registry can all become charts you filter and compare. Marketing teams track campaign spend against planned budget, operations teams follow stock or delivery logs, and finance teams watch cost lines by month. Combine worksheets in one dashboard to spot gaps between what was planned and what actually happened, then share the view with the people who make the call.

Try out all the features for free for 14 days

How to create Excel dashboards in Metabase

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

1
Connect Excel as a data source

Add Excel on Kondado and paste the OneDrive or SharePoint address of the workbook, then select the worksheet you want to read.

2
Choose Metabase as your destination

Pick Metabase as the destination so each row of the worksheet arrives ready to explore, with no intermediate database in between. If your team also reports in Power BI or Looker Studio, the same worksheet can feed those dashboards too.

3
Build dashboards and set the refresh

Create charts, filters and dashboards in Metabase, then choose how often the data updates, from every 5 minutes to once a day.

Access Excel data in Metabase 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 Metabase automatically

How do I connect an Excel file to Metabase? ▼
Start by adding Excel as a data source on Kondado and paste the OneDrive or SharePoint address of the workbook. Choose the worksheet you want to read, then select Metabase as the destination. Kondado uses the first filled row as the header, so keep your column titles there.
How often can my Excel data refresh in Metabase? ▼
You choose the update frequency when you set up the connection, with options such as every 5 minutes, every 15 minutes, hourly or daily. Metabase then shows the data from the most recent update on the schedule you picked. If your numbers change once a week, a daily refresh is usually more than enough.
Which dashboards can I build from an Excel worksheet in Metabase? ▼
Common examples include a budget versus actual view, a monthly sales target tracker, a spend breakdown by category or a delivery log summary. Because each header becomes a column, you can filter by month, team or cost center and compare periods side by side. Many teams keep several worksheets in one dashboard to see the full picture.
Which KPIs can I track by visualizing Excel data in Metabase? ▼
Teams commonly track budget variance, cost per campaign, monthly revenue against target, average order value or on-time delivery rate. Once the worksheet columns arrive in Metabase, you can set targets and watch the gap month over month.
Do I need SQL to visualize Excel data in Metabase? ▼
No. Metabase lets you point, click and filter to build questions and charts from the columns Kondado sends. You can save each question to a dashboard and change the visual type without writing a query.
Can I share a Metabase dashboard built from Excel with my team? ▼
Yes. Metabase dashboards can be shared with colleagues, organized into collections or sent as scheduled emails, so the same numbers reach everyone. Since the data refreshes on your chosen schedule, the shared view stays current without anyone reopening the file.
Can I combine my Excel data with other sources in Metabase? ▼
Yes. Kondado connects 80+ sources, so you can bring other data alongside your Excel worksheets and build a single dashboard in Metabase. A marketing team, for example, can place campaign spend next to sales results and compare both in one chart.

Try out all the features for free for 14 days