No-code pipeline · Excel → Amazon S3

Send data from Excel to Amazon S3

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 Amazon S3: managed, scheduled, no code.
Creating a pipeline that sends data from Excel to Amazon S3 data lakes takes only a few minutes with Kondado. And the whole integration from Excel to Amazon S3 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 Amazon S3 data lake

How to Send Excel Data to Amazon S3

Sending Excel data to Amazon S3 with Kondado starts by connecting your workbook from OneDrive or SharePoint. Paste the file address, choose the worksheet, and Kondado reads the first filled row as the header and each title as a column. Next, configure your Amazon S3 destination and select the Spreadsheet (worksheet) pipeline. Set a schedule that matches your reporting rhythm, from every 5 minutes to daily, and Kondado writes the selected worksheet data to Amazon S3 as structured files.

Kondado replicates Excel worksheet data to Amazon S3 on a user-configured schedule. The Spreadsheet (worksheet) pipeline captures each row from the selected Excel worksheet, including the Excel row number and a text column for every header title from the first filled row, with normalized column names. You can then use the files in Amazon S3 with tools such as Athena, Presto, or Dremio for analysis, reporting, and data virtualization.

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 replicates each row of the selected Excel worksheet, including the Excel row number and a text column for every header title from the first filled row. Your Amazon S3 files therefore carry the worksheet structure directly, so budget lines, targets, and registries arrive with their original row context. Use the data in Amazon S3 to feed Athena queries, build custom dashboards in Power BI, or combine it with other datasets for planning and audit reviews. The Excel worksheet pipeline keeps those files refreshed on your configured schedule.

Try out all the features for free for 14 days

Replicated to Amazon S3

Excel data available for Amazon S3

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

1
available pipeline
Amazon S3
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 Amazon S3

Sync data automatically — no code, no manual exports.

1
Connect Excel on Kondado

Add your OneDrive or SharePoint file address in the Excel data source, then choose the worksheet you want to replicate.

2
Configure Amazon S3 destination

Set your Amazon S3 destination details so Kondado can write the Spreadsheet (worksheet) pipeline output to the bucket and path you select.

3
Select data and set schedule

Pick the Spreadsheet (worksheet) pipeline, confirm the columns and rows to replicate, and choose a schedule such as every 15 minutes or daily. You can then use the Amazon S3 files in 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 Amazon S3 automatically

How does Kondado read an Excel worksheet from OneDrive or SharePoint? ▼
You paste the shared file address into the Excel data source setup and choose the worksheet to replicate. Kondado reads the first filled row as the header, then maps each title to a column in the Spreadsheet (worksheet) pipeline. The file stays in OneDrive or SharePoint, and Kondado uses the address you provide to retrieve the worksheet data on your schedule.
What exactly gets replicated from my Excel worksheet to Amazon S3? ▼
The Spreadsheet (worksheet) pipeline writes one record per selected worksheet row, including the original Excel row number and a text column for each header title. Column names are normalized, so headers with spaces or special characters become consistent field names in the output. This preserves row context for budgets, targets, registries, and similar controls.
How often can Kondado update the Excel data in Amazon S3? ▼
You set the update schedule when you configure the pipeline, with options such as every 5 minutes, every 15 minutes, hourly, or daily. Kondado then runs the replication on that configurable schedule and writes the latest worksheet data to Amazon S3. You can adjust the frequency as your reporting needs change.
What format does the Excel data take inside Amazon S3? ▼
Kondado writes the selected worksheet data to Amazon S3 as files that preserve the row and column structure from the pipeline. Each row includes the Excel row number plus one text column for every normalized header. You can then query or process those files with tools such as Athena, Presto, or Dremio.
Can I combine Excel data in Amazon S3 with data from other sources? ▼
Yes. You can route additional data to Amazon S3 from other data sources, or send Excel data to BigQuery and PostgreSQL when you need a different destination. Many teams join the Amazon S3 files with other datasets in Athena, then publish custom dashboards in Looker Studio or Power BI.
Can I build custom dashboards from Excel data stored in Amazon S3? ▼
Yes. Once the worksheet data lands in Amazon S3, you can query it with Athena or another engine and connect the results to Power BI or Looker Studio. This lets you create custom dashboards for budgets, targets, and operational registries from the same Amazon S3 files. You control the metrics, filters, and layout for each report.
What happens if my Excel worksheet headers change? ▼
The pipeline uses the first filled row as the header each time it reads the worksheet. If you rename, add, or remove a header, the normalized column names in the Amazon S3 output follow the new header row on the next scheduled update. Review your downstream queries or dashboards after a header change so they continue to reference the correct fields.
Can I replicate more than one Excel worksheet? ▼
Each Spreadsheet (worksheet) pipeline targets one selected worksheet from an Excel file. To replicate multiple worksheets, create a separate pipeline for each worksheet and point it to the same or a different Amazon S3 destination. You can then manage schedules independently for each worksheet.

Try out all the features for free for 14 days

Try out all the features for free for 14 days