How to Bulk Convert PDF to Excel

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-whK5VdVJgd9yhcLqMXA?e=gSHkFj

⌚ 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Playlist with all my videos on PDF: https://youtube.com/playlist?list=PLlKpQrBME6xKpM8M7iy0fOz5l7XhvHTBS

🚩 Connect with me on social:
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

πŸ”” Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1

🎬 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

Posted by Contributor