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:
==========================
Complete beginners tutorial for Power Query –
Quick and easy tips to clean up data in Excel –
👉Checkout my online course on Advanced Excel & Data analysis
===================================================
💻📗💥 …(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
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.
Converted Sucessfully! But there is an Issue. I have multiple Files and each File has dynamic Tables with Same Header when i converted those files the Results are much worse. Data is Scattered Like Quantity (from Multiple files and Multiple Pages) falls in Column C, G, H, and other Data to. Could you help me in this regard
☺
How do you combine multiple tables?
Sir it will work scan pdf file also.?
can this available in ms2013
How to get all pages of the pdf to Excel in one go?
Hi Chandoo,
Would appreciate if you can help. When i press combine and transform data for a folder(pdfs with mutiple sheets each) im not able to see an option like table 1-4 vs whats on your screen. why is this so? is it an additional add on? tq
Hi Chandoo, thanks for the video, is there a way to do the if you don't have 365 or power, just normal excel
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.
Hello, I've been listening to your excellent Youtube Power Query lessons. Very good sessions.
I have one problem I've been trying to overcome that maybe you can give me some pointers. I have 400 PDF's in a folder and I want to transform the PDF's into a table format and then append each PDF table in one spreadsheet. I've been able to transform the first PDF in the format I need but when I add new PDF files into the folder, the new PDF's the new translated tables appear as additional columns versus the additional rows that I need. Any advice? Thank you for your help.
How to open power bi desktop software in laptop bro ?
Hello man,
My single data table in pdf spanned across 65 pages. Power BI method worked very well and it gave me a single excel sheet to work with! But I was using Tableau and in tableau, it gave me 65 tables and there was not option to merge all of those. Can you suggest how to merge all these tables in a single sheet?
Hi Chandoo
I'm trying to Combine and transform pdf files from a folder.
It is giving me problems due to each file in my folder having column numbers differing?
From 3 columns to 8 columns depending on the month file.
Basically I'm wanting to upload my bank statements monthly using an automated pq.
I'm sure this must be a common problem but it does not appear well covered on youtube – unless I'm missing something.
Thanks
John
Wonderful tutorial! So easy to understand. I learned several new options. Thank you Chandoo!
Pdf option not showing in power query when select the file.
Thanks, Chandoo!
What you ll do if you have different table names in different PDF files
Thank you so much. How come my excel don't give composte table, i got a separated table for each page.
Super helpful!
how will
i get power query ?
Does it work with MS Excel 2019 version?
many thanks for such video..btw..what is the meaning of "chandoo.."…
very nice & useful..can we export PDFs to excel from power BI after editing…
The PDF option isn't available in my Excel and Power BI isn't available for Macs. Is there another option that I can use? Thank you for great videos!
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
WHICH MICROSOFT VERSION WE CAN HAVE THIS OPTION ( GET DATA FROM PDF FILE) . I DONT HAVE IN MY EXCEL OPTION WHICH VERSION IS EXCEL 2010. PLZ SUGGEST
Hi, May I know if the data I want is located on a different page for the pdf file (sample file in pg12, but some pdf only got 10 pages and it located in pg3) so it shows error, are there any solutions for this?
I have Office 2019. I cannot select pdf file. What do you propose? Thanks
How to work enable pdf option in Microsoft 2013 version
Hi Chandoo,
What if I want to combine all of tables in Pages 1,2,3 and 4 for all of PDfs. Thanks.
Thanks Chandoo. I did not realize I already had PDF to Excel. I need to do this quite often!