In this step-by-step 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 add-ins.

👋 Additional resources:
- Sample PDF files if you want to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whK5Vd...
- 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:   / kevin-stratvert-101912218227818  
- 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