How to convert PDF file to Excel File or CSV File using Power Automate Desktop

(0) Share

Report

Posted on by NathanAlvares24

1,714 Moderator

Hi guys,

I have a question regarding on how to convert pdf files to excel file or csv file. Here is an example of what one of my pdfs look like:

As seen from above image, there is a table. I had used the action "Extract tables from pdf", but it results in gibberish data. So I wanted to know if there was a way to get the information of which I barred out from this image. Like PO #, PO Date and even the whole table.

I know that there is AI Builder to solve this, but that uses Premium. I wanted to utilize the full capacity of non-premium features of PAD.

Tags but open to anyone's suggestions: @Deenuji , @Agnius , @UshaJyothi20 , @Nived_Nambiar , @WillSG , @eetuRobo

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @NathanAlvares24

You can use read pdf text with OCR and you can get the whole data

And also you can use regex and parse text activity and get all the required values....

If all the PDFs are same format then please check the table data output try to sort it out how you are getting the output and what you need.....

If you want any further clarification please share sample pdf so that I can give a try...

Hope this helps

Usha

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@NathanAlvares24

If we opt for regex, I anticipate it might be a challenging process, especially if your PDFs have varying formats.

I would like to provide more informed advice after analyzing two or three PDF files. If it's not sensitive information, could you please share them privately or attach them here for review?

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @NathanAlvares24

As @Deenuji said, we need to see how each pdf file looks like , like format of invoices are same or not.

If format is same, then we can try with option for regex or string manipulation to capture the required details from pdf file.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No