Combine Data from Multiple PDF Files into a Single Excel File

Are you struggling to combine data from multiple PDF files into a single file while maintaining formatting? In this video, I will guide you through a step-by-step tutorial on how to combine PDF files in bulk using Excel. The manual copying and pasting process often results in messy data formatting. Learn how to efficiently extract and combine data from multiple PDFs into a clean Excel sheet using Power Query.

===== ONLINE COURSES =====
✔️ M Language Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[MrSantoshKm]

Thank you so much for such a great video! I was looking for google to solve this problem but didn't find any good solution. I am happy to watch your video which solved my problem.

[IvanCortinas_ES]

Power Query Master. Deep explanations, going into detail of the matter. Outstanding explanation. Thanks Chandeep.

[StepByStepExcelTutorials]

This is super helpful! Especially for those working in an auditing background! great content!

[rajeshmajumdar]

Thank you so much! I get PO copies in PDF format ... There are different sections on the PO like Supplier address/buyer address, PO # section / PO issued date / Section for LE name of the Business unit from where the PO was issued, and then the Milestone description with the amount that needs to be billed once milestone is completed.
How can I put them on a table from different sections?

[abhishekshuklaknp]

Thanks for the awesome video.
Same as your example I have to just transpose each table before merging then.

[horatiurotar]

Thanks! Very useful and perfect presentation 👏👏👏

[danishnawaz]

Excellent Sir.. plz do more video on List Functions..

[eslamfahmy]

Thanks as usual. But can you provide us an example if we need to cancel some data from that PDF at the rows? Also, every page has the name and id for each employee and we need to add both of them into column

[KhajonsakLun]

Thank you very much for useful technics.

[karthikG-hb]

Can you create a video on CO pilot like chat gpt ( ex: get sales for X Year) in power BI

[AljažBrdnik]

Thank you brother. This was the only tutorial that worked for me

[sauravkragrawal]

Thanks Chandeep! Pls advise how to do the import such that each row of PDF becomes one cell in power query.

[warrenanderson]

Great Video... Question though...What if Power Query does not read the PDF in a workable format? I have an Invoice PDf that when I import into PQ, the columns get jumbled up & I am not able to clean the data for reconciliation. I have not used your method per this video yet, but I will. Any thoughts other than using 3rd Party Apps? Thank you!

[RogerStocker]

Great job! next step could be to add a step cleaning up the column names, if those are written al little different or having sometimes artificial white spaces.

[indomartblog]

How to import the date cleanly if each pdf has different page number and has additional table? Thank you.

[aledenigres]

Hello, Chandeep!
I have a question: doesn't the use of the Table.Combine function (at 6:07) have the same effect as using the Table.ColumnNames + Table.ExpandTableColumn (that you showed next)? It seems like the same result and it would be simpler, but I don't know if I am missing something here.
Thanks! Your videos are great!

[shenuforu]

Please make a video on how we can bring in multiple bank statements with different format to a single power bi report.

[vinodjindal]

Sandeep, Your videos are realy very deep, simple and practical sdetailing all steps from 0 to last. Can u show how to combine pdf files with password ptotected, which is known to user. One way is to open those files, print them as pdf and then store in the folder, which is cumbersome. whether there can be any short cut.

[Payton-Prescott]

This was super helpful, but I have recently also started to use extraktAI, it saves me a ton of time tbh 🔥 but either way a great video guys, keep up the good work!

[MarioZaldyVenturillo]

Wow, very informative content, you explained them very well.

Just curious, is this applicable if your pdf file is a scanned doc / form?

Thanks.