Importing data from PDF to Excel using Power Query
Now you can use Power Query’s amazing data functionality to not just convert PDF to Excel, but import the PDF data with a connection the original PDF file. This way you can refresh the imported data in Excel to get the latest data from your PDF document. In addition to this, you can also clean the imported PDF data.
Credit to Leila Gharani