Showing results for 
Search instead for 
Did you mean: 
New Member

Power Automate to create AI builder to extract data from excel document and then output data into another external excel file


I am new to power automate and this is my first post about the topic to a forum. My apologies if do not phrase the use case correctly. I have a project that i think can be greatly advanced by power automate and ai builder but i am unsure of the feasability in which i presume to use it.


I have hundreds of excel files that have a form template structure on them. I would like to extract data from the fields (cells) within those excel files and save them to an external excel spreadsheet..  Is this possible?

Secondly, i would like to run the process like a batch on all the files. I assume the best options is to have al the files that need process to be saved in a prefetch folder.

I have found information that AI builder can read pdf files and accomplish what i want to do, however, i assume i have to convert my excel files to .pdf to take advantage of the ai builder; or am i over-complicating the process?

Please feel free to post any links to articles or videos that may aid in advancing my project and its undertaking.


Thank you for any direction or advisement going forward



Accepted Solutions

Thank you @plarrue . I will research the links you've given and go from there.


View solution in original post

Power Apps
Power Apps

Hi @westman ,


You may find this post helpful if you'd like to learn how to extract data from multiple Excel files 


The AI Builder product is also covered in this learning module 


Please refer to the AI Builder Overview page if you would like to learn more 


This Power Automate Cookbook shared by the community lets you import flows into your environment and test them 


Hope it helps!

Thank you @plarrue . I will research the links you've given and go from there.


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,843)