In this stepbystep tutorial, learn how to bulk extract data from multiple PDF files into an Excel spreadsheet. To extract data, we use Power Query functionality that is built into Microsoft Excel and this requires no third party addins.

Additional resources:
Sample PDF files if you want to follow along: https://1drv.ms/u/s!AmxrofZZlZwhK5Vd...
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

⌚ Timestamps
0:00 Introduction
0:32 Overview of sample files
1:51 Import one PDF into Excel
4:07 Refresh data
6:31 Bulk import PDF files into Excel
10:03 Power Query Editor
11:30 Transform data
12:15 Transpose
12:49 Use first row as headers
13:05 Add custom column
16:08 Remove row
16:41 Update column header
17:01 Applied steps
17:49 Review & transform aggregate data
19:07 Update data type
19:58 Remove column
20:14 Close & load
20:44 Bring in more data
21:56 Wrap up

Watch related playlists and videos
Playlist with all my videos on Excel:    • ❎ How to use Excel  
Playlist with all my videos on PDF:    • PDF  

Connect with me on social:
LinkedIn:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevinstratvert101912218227818  
TikTok:   / kevinstratvert  

Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...

Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

Support me with your Amazon purchases: https://amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same.

#stratvert