How to automatically extract data from a messy PDF table to Excel @chandoo_
How to automatically extract data from a messy PDF table to Excel  @chandoo_
Uploaded January 2024 | Updated November 2026, 5 hours ago
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/uploads/2024/01/Pageexample2.pdf

Completed Excel File with PowerQuery transformations + custom function ๐Ÿ‘‡
chandoo.org/wp/wp-content/uploads/2024/01/pdf-split-and-combine-demo.xlsx


โฑ 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 - youtu.be/UAFExySaSPY
Complete Master Class on Power Query (90 mins) - youtu.be/PiFAa_jjaEI

Combine PDFs with Power Query - youtu.be/5I0pnj_-LLA
Combine Sheets with Power Query - youtu.be/k_ugshJ4wIw
Combine Workbooks with Power Query - youtu.be/SGzegma9bdY

Multiple Find Replace with PQ - youtu.be/YWAMaas_1AU
Power Query - Automating 5 Data Tasks -
youtu.be/yJum0g4qM2c

Power Query Playlist - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2

Power Query Mini Course - chandoo.org/wp/power-query-power-course

~

Why did the PDF break up with his girlfriend?
Because she is not on the same page ๐Ÿ˜‚

#powerquery
How to automatically extract data from a messy PDF table to ExcelCool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘ŒSummarize Filtered Values in Excel - Formula TrickAwesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)The Ultimate Excel Dashboard: Visualize Data Like a ProLearn 80% of DAX in an Hour (with FREE sample file)Learn Excel COPILOT in just 15 minutes and Work Smarter ๐ŸคฏHow to make a Show / Hide SLICER PANEL in Power BI ๐Ÿ’กMake a beautiful and interactive To-Do List with Excel (Easy Tutorial ๐Ÿ‘Œ)Power BI Ecosystem - Explained in 25 minutesBecome an Excel PRO with this complete Dashboard Project ๐Ÿ“ˆYou dont need work email to use Power BI - Easy Fix ๐Ÿ˜Ž
Chandoo |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER