1. Use built-in Excel actions this this the easiest way
Open your Excel file in Power Automate Desktop and use actions like Read from Excel or Write to Excel. If you format your data as a table, it will work like a simple database.
2. Use SQL connection advanced option
If you want database-like queries, connect Excel using an OLEDB connection and run SQL queries like SELECT * FROM Sheet1. This makes Excel behave more like a database.
Steps:
Use Open SQL connection action
Connection string example:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\YourFile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;";
If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.