Turn Your Excel Spreadsheets into Power Apps in Minutes with AI 

Thanks so much! I'm feeling much better :)

It's my pleasure

Thanks! At the moment it can only handle a single Excel sheet at a time but there are work-arounds to get all sheets added in. I can add that to my list of videos to make :)

Sure, this video should help: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3HJMF6Q4tiA.html

@@AprilDunnam Thank you very much, it’s a pleasure to watch your videos!

Great question. Not with this functionality. The intention with this Excel to App is to get you off of Excel and into Dataverse. However, there's something called Virtual Tables that will do what you're wanting. I have a video that does an overview of how it works here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vMEKnAtpPL4.html Essentially you connect to your data (Excel, SharePoint, etc) and it creates a virtual instance of it in Dataverse that you can then build Apps on top of that is automatically synced both ways. So if you update your Excel it will update in Dataverse and if you make changes in Dataverse it's updated in Excel

Excel is a useful tool for small-scale data manipulation and analysis, a real database like PostgreSQL provides better data integrity, scalability, concurrency, security, analysis capabilities, collaboration, and integration options. It is a more suitable choice when dealing with larger datasets, multiple users, complex data relationships, and business-critical applications. Nor Excel, nor SharePoint are not databases. Microsoft Dataverse, is a cloud-based data storage and management service provided by Microsoft as part of the Power Platform. It is primarily designed to serve as a data platform for building business applications within the Microsoft ecosystem. So basically Microsoft goal is to suck you in and be dependent on Microsoft. Being depending on Microsoft service is a bit painful when there are issues with Microsoft API, for example some connectors can have service downgrade and you can't do anything about it just wait for third party to fix it. However, if you want to have great opportunity to structure your data you can host yourself Linux VM and host yourself PostgreSQL (free) via portainer+dockers and re-create excel logic to database and...start moving to web development. What that will help, you will move out from old solutions such as excel and move to real database where real power comes in. You will be able to pick any front-end solution and this type of experience will be much much better since canvas app and model-driven app have it's own limitations. You can also use power apps as front-end with these type of back-end solutions, but having strong core (database) is a big step forward than using excel. Power Apps are OK for simple tasks, but as usually solutions are tend to grow and scale which I prefer moving to selecting tech stack and deploying solutions. It's only sounds hard, but it's not :)

I think yes there is a option for Google sheets is App Sheets

​@@AprilDunnamGreat video April. Thanks for sharing. I saw your video on Virtual Tables but apparently connectors are available for SQL or SharePoint only. Am I wrong?

@@LukasSoftwareDeveloper thanks for the explanation, it makes sense. Using excel to manipulate data would defeat the purpose of converting it to an app

Thanks!

Transforming an Excel worksheet into a Power App brings improvements in user experience, mobile access, data validation, integration, automation, collaboration, scalability, and customization. By transforming Excel into a database and utilizing that database with a Power App, you can achieve improved data integrity, scalability, concurrency, security, querying capabilities, integration options, consistency, and simplified app development. This combination offers a more efficient and robust solution for managing and interacting with your data. So if you want to use your excel as data-source it will be OK for some time, but think about transferring data to real database (SQL, portgeSQL, etc.). There are good reasons why databases were invented and why researchers spent a lot of time developing them. As per my opinion - I'm more against having excel as data-source/database, if you need scalability, performance, smell of new technology and solutions, move to database rather than using old fashion excel.

There’s a lot of benefits. Excel isn’t a database so by using this feature you can move your data over to a proper database and take advantage of the many features that alone offers like a robust security model, integrations, etc. You get the added benefit of having an app on top of that data to easily add new items and search and filter the data.

Thanks for sharing your thoughts! It's important to provide feedback so that companies like Microsoft can improve their products and make them more user-friendly.