Automate data extraction from pdf file

Like (1) Share

Report

Posted on 25 Oct 2024 13:50:16 by MB-25101343-0

Hello
I have about a hundred PDF files from which I need to extract data and add them manually to an Excel file. I would like to know if it is possible to automate this with AI so that as soon as I add a PDF file the data is automatically extracted and added to the Excel file.

Categories:

AI Builder

All responses (5)

Answers (0)

trice602 13,763 Super User 2025 Season 1 on 23 Feb 2025 at 20:49:46

Like (0)

Report

Automate data extraction from pdf file

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯
trice602 13,763 Super User 2025 Season 1 on 23 Feb 2025 at 20:49:16

Like (0)

Report

Automate data extraction from pdf file

Hey there!

I am following up on this post automate data extraction from pdf file in this category ai builder from 10/25/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 3 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯
Suggested answer

takolota1 4,859 Super User 2025 Season 1 on 25 Oct 2024 at 16:22:04

Like (1)

Report

Automate data extraction from pdf file

If your PDFs have different formats then you may use GPT to extract the data like this template: https://community.powerplatform.com/galleries/gallery-posts/?postid=31e67eea-3f73-47b4-95b7-fe4a7b646389
Chriddle 7,680 Super User 2025 Season 1 on 25 Oct 2024 at 16:13:51

Like (1)

Report

Automate data extraction from pdf file

Check connector "Recognize text in an image or a PDF document"
Suggested answer

trice602 13,763 Super User 2025 Season 1 on 25 Oct 2024 at 15:30:45

Like (0)

Report

Automate data extraction from pdf file

Hi,

Yes it is possible. I don't use AI builder though, I am using Power Automate for Desktop and reading the content of each PDF then using the capture values and adding a row to Excel.

Works great (provided that the PDFs are all the same format).

To automate this you can use this trigger so when a new PDF is added to a folder you select, it will run your Power Automate for Desktop flow, extract the values, add to an Excel table. I have a handful of these running, work like magic and very dependable.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Community site session details

Automate data extraction from pdf file

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Automate data extraction from pdf file

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates