Integration with excel

i created an app i need and it export a spreadsheet for me based on the database

I wanted to know how can I do this

Hi @YagoRodrigues,

Welcome to the community :partying_face:

You mean connect your Excel workbook right? I think you can do that with the API : Sample URI For Excel Services REST API | Microsoft Learn

Not experienced but worth giving a shot.

If you don’t need to add the new records in to that excel sheet you can use the Import feature in Adalo to get the records that in the excel sheet! : Importing Records from a CSV File - Adalo Resources!

Thank you

If you’ve built an app that exports data to a spreadsheet, it sounds like you’re looking to integrate it with Excel in a way that can automatically create or update a spreadsheet based on your app’s database. The most straightforward way to achieve this is by using an API like the Excel Services REST API from Microsoft. It lets you interact with Excel files directly from your app, which means you can push data into a spreadsheet automatically without any manual steps.

Well, it’s worth noting that depending on how complex your data and app are, there might be some hiccups with syncing large datasets or managing real-time updates. I’d recommend looking into the API thoroughly to see if it fits your needs or if something simpler like exporting to a CSV could do the trick.
Also, if you’re just getting started with automation or data management, checking out some Excel-focused resources like excel.tv could help you get a better idea of how to optimize your process and avoid running into any issues down the road.