How to Combine PDFs to Excel easily (one or many files)

You can use Excel's Power Query to easily convert PDF to Excel tables. No extra software or add-ins required.

In this video, I will show you how to convert one PDF to Excel or combine data from multiple files to a single Excel table.

📜👇 For sample credit card statements (to practice) and more visit
=======================================================

⏱ Timestamps:
==============
0:00 - Intro
0:44 - Getting data from one PDF to Excel
2:20 - Fixing problems with PDF import
4:03 - Getting data from an entire folder of PDFs to Excel
6:22 - What to do if you can't use PDF option in Excel

Learn more about Power Query:
==========================

👉Checkout my online course on Advanced Excel & Data analysis
===================================================

[mymatemartin]

Chandoo, can do ... anything.

Absolutely amazing Chandoo. I'm so impressed with the advanced features you demonstrate and the very clear and professional quality of your tutorials.

[RobertAfrick]

Just when I thought I knew everything about Excel...Chandoo comes through again with another great, easy to use, helpful video. Chandoo...keep them coming, my mind is open!

[nolatari]

I haven't even seen the video and I already liked it because I know it will be something great

[wendygurl]

Thank you for sharing your video! I just tried to combine multiple PDFs in PowerQuery- it's working great and will save us a lot of time. Thank you so much :)

[John-qeky]

Love your videos as I learn useful tips that may be "known" already by experts but not beginners. This PDF tip will save me a lot of time.

[thomas_didymus]

Thanks Chandoo. I did not realize I already had PDF to Excel. I need to do this quite often!

[beachlimer]

Chandoo this is amazing thank you - I love your advanced excel tips

[Will.Tru]

Thanks again and again, Chandoo, for all the help. Love the t-shirt

[raghvendrasingh]

Chandoo sir you are gem at excel and visualisation tools... Love you sir❤❤

[wayneedmondson]

Hi Chandoo. Great example! Thanks for showing how to do this. Will put it to good use immediately :)) Thumbs up!!

[samvtiger]

thank u sir, i have seen many videos related to "get data" but solve my problem after view this videos.

[harveenbajwa]

Yo Chandoo, you beautiful evil genius you!!

[ondosiregar]

Hi Chandoo, please make a power query videos with very messy data. Your data sample is too simple for some of us case. Thank you Chandoo

[MehediHasan-hkmk]

I am just falling in love with your videos.

[beckybradshaw]

Wonderful tutorial! So easy to understand. I learned several new options. Thank you Chandoo!

[alijaved]

Hey chandoo you the best teacher of excel I have come across so far. Having issues with a particular pdf file. When I import via pdf. The navigator is stating this table is empty

[shahbazali]

it is amazing sir, your every video force me to learn something new...thank you so much... one small question... how can we get data from multiple tables when source of data is folder.. mean a folder contain multiple pdf file and from that files we want to extract multiple tables.

[amitshah]

Awesome tips for conversions of files in excel. Sir one more request is pls make detailed video on power query / power pivot and power bi course. Thank you in advance. Keep learning and keep sharing thank you so much sir

[canirmalchoudhary]

For some I simply use copy paste with other cleaning tricks. But for structured PDF files, this option is really good.

[joseagundis]

Very good, thanks for sharing. Regards Chandoo to New Zeland