Accurately Convert PDF to Excel IN EXCEL [Point and Click Steps)
Want to accurately extract PDF data to Excel without using external tools? No more time consuming and error prone copying and pasting!
This video shows you how to use the Power Query PDF connector native in Excel to not only connect to the PDF but also clean and shape the data, and enrich the data for further analysis.
We'll learn some cool Power Query techniques ✔
We also cover how to make a connection to a table that spans multiple pages.
Read the article here: https://datacycleanalytics.com/how-to...
📍📍Key Moments:
00:00
00:25 Excel PDF Connector and availability
01:07 Make connection to PDF file
03:06 Transform the PDF data in Power Query
06:52 Append multiple tables
07:25 Two approaches to unpivot columns
10:01 How to load the clean data to Excel
11:09 Enrich the data: Custom columns and merge tables
14:33 Analyze the data with Pivot tables
15:35 Define a range for the PDF connection
18:25 BONUS: Alternative free solution
#msexcel #powerquery #pdf
//WATCH NEXT
Convert PDF using Power BI:
📌Note on Availability / Missing PDF Connector
PDF Connector is available for Office/Microsoft 365 subscribers on Windows/PC only. At the point of writing this, the same is not available for Mac users.
If you have Office/Microsoft 365 and you still cannot locate it, you may need to try:
1. Run an update of your Office product. Even with an update, please be aware features are released gradually depending on what channel you’re on. Click this link to find out how to get the latest updates:
https://support.microsoft.com/en-us/o...
2. Update your .Net Framework. The PDF connector requires .Net Framework 4.5 or higher). You can download it here https://dotnet.microsoft.com/en-us/do...
This Microsoft documentation tabulates the availability of various data connectors in Power Query in Excel:
https://support.microsoft.com/en-us/o...
💡Polish up your Excel charting and data visualization skills. Get this FREE eBook:
https://datacycleanalytics.com/boardr...
⭐⭐⭐⭐Take your data storytelling and charting skills to the next level with this top rated 5 hours of video chart course: https://courses.datacycleanalytics.co...
//WORK WITH WILLIAM
👉For business inquires only, please use this email: [email protected]
_____________
//SUBSCRIBE:
/ @williamthedataprof
//COME SAY HI!:
Facebook: / billwilliamsk
LinkedIn [personal]: / william-kiarie-baab977a
LinkedIn [company]: / data-cycle-analytics-ltd