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-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