How to "automatically" extract data from a messy PDF table to Excel
Ғылым және технология
Ever had a gnarly PDF that you need to extract data and reshape? Today let me share an advanced Power Query trick with you. You can use this to reshape (split & combine) PDF tables. Later on in the video, I explain how to build a CUSTOM FUNCTION in Power Query so you can automate the task next time. Don't miss the ending!
📁Sample files:
Try it yourself on the PDF 👇
chandoo.org/wp/wp-content/upl...
Completed Excel File with PowerQuery transformations + custom function 👇
chandoo.org/wp/wp-content/upl...
⏱ IN THIS VIDEO:
0:00 - The PDF Table Problem
0:47 - Getting the data from PDF
1:40 - Power Query Parkour Time 🪑🏃♂️
4:16 - Creating a PQ Custom Function to split and combine tables
7:00 - Invoking the function on your PDFs
8:42 - But there is more...
👩💻 MORE VIDEOS ON POWER QUERY
Learn Power Query in 15 minutes - • Learn Power Query & Au...
Complete Master Class on Power Query (90 mins) - • Power Query Tutorial -...
Combine PDFs with Power Query - • How to Combine PDFs to...
Combine Sheets with Power Query - • AWESOME Excel trick to...
Combine Workbooks with Power Query - • Powerful trick to comb...
Multiple Find Replace with PQ - • Multiple Find / Replac...
Power Query - Automating 5 Data Tasks -
• FREE Power Query Mater...
Power Query Playlist - • Power Query How-to & Tips
Power Query Mini Course - chandoo.org/wp/power-query-po...
~
Why did the PDF break up with his girlfriend?
Because she is not on the same page 😂
#powerquery
Пікірлер: 202
Great and Yes to see how the entire tables is clubbed into one.
Thank you Chandoo and a BIG YES to the following videos.
Yes! Need the video! Have been looking for it to combine multiple pdf tables into power query.
Another great video, Chandoo, thanks! Definitely, yes, interested in the bigger Power Query project!
Yes, please share your way of dealing with it. Thank you so much for sharing :D
Thanks for sharing the knowledge Sir, yes I am interested to see how these tables can be combined
Another great video. Yes, I would like to see all tables in the entire document in one dataset.
Amazing work Chandoo, YES, I would love to see how you solve the entire problem
Yes Interesting always find tips about working with pdfs are worthwhile
Yes, I'd love to see the next part of it.
Today I learnt about creating and calling the function.. love you boss ❤
@chandoo_
5 ай бұрын
Happy to help
Yes, want more. Interesting.
Excellent trick Chandoo!
Yes, this is brilliant 🙌🏼
Thanks a ton for this!!! YES, please
Yes Chandoo… you are awesome
Interesting topic, thanks for Sharing the information.
Awesome work and yes would love to see the next video.
Yes, I want to see that also. Great!
Yes Please Chandoo. Thanks being supported
Yes, I would love to see that. Thank you
Thanks alot..and Yes for next Learning about this.
Yes, We would like to see that option. Great 👍🏻
Yes please make a video on the entire PDF
Yes. I'm trying to do this with PDF forma bank statements, but it is getting a bit complicated due to some columns not aligning with the rest and various other stray data.
yes, thanks for such a valuable vid.
Yes, please. Excellent video
yes we are eagerly to watch the next video of Power quarry
@soccerlvr8221
2 ай бұрын
😂😂😂😂😂😂😂😂😂
*Yes...* Thank you Chandoo!
great video and yes please provide another video to combine all pricelists
Yes, Chandoo love to have that video
Thanks for this! Yes for more 👍
Good and clear explanation 🎉
Yes, interesting & useful....
Yes, Thanks Chandoo!
Yes, it would be interesting to learn that. 😃
Great Chandoo.... Loved it
Thanks Candoo, yes
Yes Sir I would like to see how and what steps you applied to achieve it..
Yes, waiting for the upcoming video
Yes! Thank you!
Yes plz, awaiting to watch the vdo...
Yes please, this is similar to a project I am currently working on.
great work, thanks for sharing
Yes!and Thank you Sir!
Yes, would like to know this technique.
Yes, Chandoo!!
Yes Very instrumental information ❤❤❤
Yes and make a video for the entire pdf file.
Definitely yes, Chandoo 😊
BIG YES Help Full Content
yes. Would love to see
yes sir please make a video of the advance of it
Big YES! 🎉
Yes, thank you.
Yes of course sir ✌🏻 thanks in advance
Yes, of course.
Yes!! Need a video
Yes from Heart of India,
YES - and thanks
Definitely... Yessss!
that will be a 'YES' for me as well 🙂
yes please, very good
Magnificent 👍🏻
Yes we want to see combined data set of the PDF
Hello Sir Pls help me I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help
Great 👍 "Yes"
Yes chandoo garu
Yes, like to new video. It feels like List.Transform and List.Combine PQ functions need to be utilise with your custom function.
Yes chandoo
Yes, sir! :)
hi, pleasant day. i hope the video for the whole pdf conversion is finish. may i know the link? thank you very much in advance :)
Nice one, if possible then share the pdf file so that we can practice while watching your videos.
@chandoo_
5 ай бұрын
I already did. Please check the video description.
Yes definitely
I really enjoyed your informative video! I recommend giving the VeryPDF PDF to Excel Converter a try. This Windows software can automatically convert PDF files into Excel spreadsheets, allowing you to combine multiple PDFs without losing formatting.
yes. Make a video on this.
What about using powrer automate or AI tools?
Yes please make the video
Yes ofcourse.
Nice one. Does it also work for another excel file as we have already made a function?
@chandoo_
5 ай бұрын
You will need to add the function to other files (just copy the code from Advanced Editor), create a new blank query and paste the code in Advanced Editor.
@bibekkoirala5294
5 ай бұрын
@@chandoo_ thank you! I will try it. Whenever you upload the next video plz show it also.
YES!
Yes mister !
Yes Sir Please create Video on PDF
absolutely yes 🤑
Yes!
Yes
Yes, please.
Yes please make a video
yes
YES
Yes.
YES! YES!! YES!!!
Yes please.
Yes❤
yes!
Yes anna
👍 Yes
👌👌
Yes^2
Yes, from hyd telangana