No-code pipeline · Excel → MySQL

Send data from Excel to MySQL

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

From Excel to MySQL: managed, scheduled, no code.
Creating a pipeline that sends data from Excel to MySQL databases takes only a few minutes with Kondado. And the whole integration from Excel to MySQL is managed and executed by our platform. With Kondado, you can focus on extracting value from Excel data and combining it with other data in your MySQL database

Send Excel Data to MySQL on a Schedule

To send Excel data to MySQL, connect your Excel file from OneDrive or SharePoint in Kondado, paste the file address, and choose the worksheet you want to replicate. Kondado reads the first filled row as the header, turns each title into a column, and maps every worksheet row to a row in your MySQL database on the schedule you select.

Kondado replicates the selected Excel worksheet to MySQL on a configurable schedule, from every 5 minutes to daily, so your database stays current for reporting and analysis. The Spreadsheet (worksheet) pipeline keeps the Excel row number and creates a normalized text column for each header from the first filled row, giving analysts a consistent structure for custom dashboards and SQL queries.

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

The Spreadsheet (worksheet) pipeline brings each selected worksheet into MySQL as rows and columns, so the Spreadsheet (worksheet) pipeline for a Budget worksheet can feed cost analysis, the Spreadsheet (worksheet) pipeline for a Sales registry worksheet can support revenue reporting, and the Spreadsheet (worksheet) pipeline for a Targets worksheet can keep performance tracking aligned. Once the data is in MySQL, your team can join it with order data, calculate variances, and publish custom dashboards in Power BI or Looker Studio. Analysts can also combine Excel data with datasets sent to PostgreSQL or BigQuery for cross-source reporting.

Try out all the features for free for 14 days

Replicated to MySQL

Excel data available for MySQL

Tables Kondado writes into your MySQL, on a schedule you control.

1
available pipeline
MySQL
Destination

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 send Excel data to MySQL

Sync data automatically — no code, no manual exports.

1
Connect Excel from OneDrive or SharePoint

Open the Excel source page, paste the OneDrive or SharePoint file address, and choose the worksheet you want to replicate.

2
Configure MySQL destination details

Add your MySQL host, database name, user, and password, then confirm the destination settings so Kondado can write the worksheet rows into MySQL.

3
Select worksheet and set schedule

Choose the Spreadsheet (worksheet) pipeline, confirm the columns from the first filled row, and set the update schedule from every 5 minutes to daily. Publish the resulting MySQL data to Power BI or Looker Studio for custom reporting.

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

Send data from Excel to other destinations

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)

Answers about sending Excel data to MySQL automatically

How does Kondado send an Excel worksheet to MySQL? ▼
Start on the Excel source page, paste the OneDrive or SharePoint file address, and select the worksheet you need. Kondado writes the selected rows into your MySQL destination, and you can update the worksheet choice or schedule from the pipeline settings as reporting needs change.
Which Excel data can I replicate to MySQL? ▼
You can replicate any worksheet from an Excel file stored on OneDrive or SharePoint, including budget sheets, sales registries, targets, controls, and operational logs. If a workbook has multiple worksheets, create a separate Spreadsheet (worksheet) pipeline for each one you need in MySQL.
How often does Kondado update MySQL from Excel? ▼
Updates run on a configurable schedule, with options such as every 5 minutes, every 15 minutes, hourly, or daily. Choose the frequency that matches how often the Excel file changes and how quickly your MySQL reports need to refresh.
What format does Excel data have in MySQL? ▼
The Spreadsheet (worksheet) pipeline creates a MySQL structure with the Excel row number plus one text column for each header from the first filled row, using normalized column names. Values arrive as text, so you can cast them in MySQL queries when you need numeric dates, amounts, or percentages. This keeps the original worksheet layout predictable for SQL analysis and custom reporting.
Can I combine Excel data with other sources in MySQL? ▼
Yes. Once Excel rows are in MySQL, you can join them with data from other pipelines, such as datasets sent to PostgreSQL or BigQuery, and then publish the combined view to Power BI or Looker Studio for custom dashboards.
Can I send multiple Excel worksheets to MySQL? ▼
Yes. Each worksheet you select becomes its own Spreadsheet (worksheet) pipeline, so you can send a Budget worksheet, a Sales registry worksheet, and a Targets worksheet to MySQL separately. This makes it easier to manage schedules and column sets for different reporting areas.

Try out all the features for free for 14 days

Try out all the features for free for 14 days