How to Convert a PDF to Excel in Minutes and Have It Update Itself!
In this video, I'll show you step-by-step how to convert any PDF file into a neat, ready-to-use Excel spreadsheet using Power Query. It's ideal for price lists, invoices, or bank statements.
⬇️ Download the example file here and follow the step-by-step instructions:
https://bit.ly/4sHjl9Z
👉 You will learn:
How to import one or more tables from a PDF
What to do when columns are incorrectly formatted (or there are extra fields)
How to automate the process so that it updates automatically every time a new version is released 😮
🔔 Subscribe and hit the bell icon to be notified of new channel updates
/ @planillaexcel
CHAPTERS
00:00 Intro
00:16 How to import PDF to Excel in just a few clicks
01:18 How to import multiple tables from a PDF
02:43 How to merge tables into one
03:37 How to transform columns and separators Decimal places
05:45 One-click file update
===============================================================
👪 Follow us on our social media:
►Facebook / planillaexcelcom
►Twitter / planillaexcel
► Instagram / planilla.excel
#ConvertPDFtoExcel #Excel365 #Automation