How to "automatically" extract data from a messy PDF table to Excel

[@MUAISC]

Great and Yes to see how the entire tables is clubbed into one.

[@AlbertoCohen-b6d]

Always a pleasure learning from you, Chandoo! Yes, I would like to see all tables combined.

[@christian-marcgaka_sounouv4363]

YES, Even thougth I am use to watch your videos, You still blow my ming with your awesomeness... THANKS

[@moisestatis5418]

Thank you Chandoo and a BIG YES to the following videos.

[@JoseValenzuela-lo3wk]

Yes, I'm interested in seing the solution you come up with. Because I am working on a similar issue, but this involves a pdf document with over 900 pages. You're Awesome!!

[@the_creator99]

Yes! Need the video! Have been looking for it to combine multiple pdf tables into power query.

[@AnbarasuAnnamalai]

Yes, want more. Interesting.

[@RomantiCynic]

Another great video, Chandoo, thanks! Definitely, yes, interested in the bigger Power Query project!

[@samdeepak]

Yes, I'd love to see the next part of it.

[@outsideedge7999]

Yes please make a video on the entire PDF

[@lukev730]

Yes Chandoo… you are awesome

[@stevenreeve6139]

Another great video. Yes, I would like to see all tables in the entire document in one dataset.

[@veggiesfoodcourt9564]

Perfect suction. Thanks . Yes would like that video of combining Messi tables in pdfs

[@medher3593]

Amazing work Chandoo, YES, I would love to see how you solve the entire problem

[@lovelittlepea96]

Yes, please share your way of dealing with it. Thank you so much for sharing :D

[@ahmed007Jaber]

Yes Interesting always find tips about working with pdfs are worthwhile

[@chrism9037]

Excellent trick Chandoo!

[@irfanahmad-it2bp]

Awesome work and yes would love to see the next video.

[@georgemalinakis8522]

Yes Please Chandoo. Thanks being supported

[@kazimuhammadyakubali340]

yes we are eagerly to watch the next video of Power quarry

[@soccerlvr8221]

😂😂😂😂😂😂😂😂😂

[@charanreddys7190]

Today I learnt about creating and calling the function.. love you boss ❤

[@chandoo_]

Happy to help

[@aravindram953]

Yes and make a video for the entire pdf file.

[@sandeeppaib1985]

Great Chandoo.... Loved it

[@carocajiao]

Yes, I would love to see that. Thank you

[@MagudeswaranM-p4m]

Interesting topic, thanks for Sharing the information.

[@atulbhandvalkar2510]

Yes, I am interested in the more power query knowledge.

[@jc1866vzla]

Yes, please. Excellent video

[@sheevamchakraborty1257]

Yes, waiting for the upcoming video

[@Luciano_mp]

*Yes...* Thank you Chandoo!

[@abhinav10x]

Thanks alot..and Yes for next Learning about this.

[@SameerShaikh-1992]

Yes, Chandoo love to have that video

[@bchy78]

Yes plz, awaiting to watch the vdo...

[@vinodhramasubbu1600]

Yes, this is brilliant 🙌🏼

[@vanderse01]

great video and yes please provide another video to combine all pricelists

[@SandeepKumar-dm3lc]

Thanks a ton for this!!! YES, please

[@JavedAnsari-vba]

Thanks for sharing the knowledge Sir, yes I am interested to see how these tables can be combined

[@arulbhaskar919]

Yes, I want to see that also. Great!

[@rxepdmgm9523]

Yes, We would like to see that option. Great 👍🏻

[@sanjayjha1966]

yes, thanks for such a valuable vid.

[@rajeshmajumdar4999]

Yes, Thanks Chandoo!

[@trevorbbeairsto]

Thanks for this! Yes for more 👍

[@illiakhmaladze2071]

Definitely yes, Chandoo 😊

[@sagarkeshyal752]

yes sir please make a video of the advance of it

[@rDinx]

Yes please, this is similar to a project I am currently working on.

[@Nic_Holas]

great work, thanks for sharing

[@selvakumar-y2f]

Good and clear explanation 🎉

[@GauravRaj-nq6jl]

BIG YES Help Full Content

[@gerohazigabor]

Yes, it would be interesting to learn that. 😃

[@shoboyjr]

Yes, please. Excellent video

[@nicor1501]

that will be a 'YES' for me as well 🙂

[@shedizon5978]

Yes!and Thank you Sir!

[@sanjeevsoni6793]

Thanks Candoo, yes

[@maheshs6098]

Yes, interesting & useful....

[@mindyourown6320]

Yes! Thank you!

[@idhingra6360]

Yes, would like to know this technique.

[@mauryaparkara124]

Yes we want to see combined data set of the PDF

[@KartikSir_]

Yes from Heart of India,

[@Sekoleyte]

Yes of course sir ✌🏻 thanks in advance

[@santoshkiran5858]

Yes Very instrumental information ❤❤❤

[@Bhavik_Khatri]

Yes, like to new video. It feels like List.Transform and List.Combine PQ functions need to be utilise with your custom function.

[@saikrishnanimmagadda6469]

Yes, Chandoo!!

[@veryutils]

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.

[@tofikqureshi6507]

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

[@rajkumargerard5474]

Yes Sir I would like to see how and what steps you applied to achieve it..

[@Datalyticslab]

Yes sir, Interested

[@rxepdmgm9523]

Magnificent 👍🏻

[@aman_mashetty5185]

Yes!! Need a video

[@alanmonaghan9194]

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.

[@arbazahmad7177]

Great 👍 "Yes"

[@vishalasari26]

yes. Would love to see

[@sayakdasgupta1788]

Nice one, if possible then share the pdf file so that we can practice while watching your videos.

[@chandoo_]

I already did. Please check the video description.

[@how2excel999]

yes please, very good

[@barttitulaerexcelbart9400]

Yes, thank you.

[@taizoondean689]

Yes Sir Please create Video on PDF

[@zhuzhu9599]

Definitely... Yessss!

[@muhammadamjad8009]

yes. Make a video on this.

[@bodapudinikhil505]

Yes chandoo garu

[@pratikghate5370]

Yes please make the video

[@yohannesteshome2043]

Yes chandoo

[@umamaneiramelhor]

Big YES! 🎉

[@miguelcalejo1770]

Yes, of course.

[@laksdjf09]

YES - and thanks

[@alexk8343]

Yes, sir! :)

[@asterryan]

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 :)

[@karan007in]

Yes please make a video

[@bibekkoirala5294]

Nice one. Does it also work for another excel file as we have already made a function?

[@chandoo_]

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]

@@chandoo_ thank you! I will try it. Whenever you upload the next video plz show it also.

[@SanjaySharma-xu8so]

Yes please.

[@ramasubramanianh9347]

Yes definitely

[@SafoineBENAMOR]

I have problem now that power query divide the same column into two or three any solutions I manage 400 tables Also are there any solutions to make all tables with same titles so I can assemble them as one table ?

[@fahadamir6655]

Yes ofcourse.

[@sanviandshreejashow3331]

Awesome

[@stanTrX]

What about using powrer automate or AI tools?

[@saadbassy673]

Yes mister !

[@MrPraveenmahesh]

what excel version you use ? in excel 2016 i couldn't find get data > pdf feature.

[@chandoo_]

You need newer versions for this (or use Power BI Desktop, free).

[@alfalogic]

absolutely yes 🤑

[@maheshkumar-wn5vv]

Yes, from hyd telangana

[@lionvillelion]

Yes, please.

[@mohammadajmalfazli]

Yes, please.

[@alexrosen8762]

YES!

[@michaelbrown8821]

Yes^2