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: [ Ссылка ]
- Learn the fundamentals of Excel in just 2 hours: [ Ссылка ]
⌚ 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: [ Ссылка ]
- Playlist with all my videos on PDF: [ Ссылка ]
🚩 Connect with me on social:
- LinkedIn: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
- TikTok: [ Ссылка ]
🔔 Subscribe to my YouTube channel
[ Ссылка ]
🎬 Want to watch again? Navigate back to my YouTube channel quickly
[ Ссылка ]
🛍 Support me with your Amazon purchases: [ Ссылка ]
⚖ 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
PDF to Excel Converter
Теги
kevin stratvertpdfexcelextract databulk extractpdf to excelimpohow to convert pdf to excelconvert pdf to excelconvertpdf to excel converterhow to change pdf to excelpower queryhow to convert pdf into excelpdf convert to excelhow to convert pdf file to excelconverting pdf to excelstratvertconvert pdf to excel without losing formattingimport pdf to excelimportpdf excelexcel pdfexporttransferopenconverterpdf file convert to excelfile