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…
- 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
Kevin Stratvert 
Hello Kevin, I was looking for a tutorial on how to convert an excel with multiple tabs into pdf. There are videos on youtube, but my excel has many columns, vs. 2-3 columns the other tutorials show. Any advice for me? I really appreciate it.
LikeLike