Excel — How to import data from PDF
Do you ever have a PDF with information you want to analyze in Excel? Have you tried the copy & paste option and all your data uselessly ends up in the first column? Let’s try the Get Data method.
Open a blank excel file and go to the Data TAB.
Select Get Data > From File > From PDF.
Navigate to the saved location of your PDF — in this example we are using a bank statement.
Once you open the PDF — Excel opens the Navigator window where you review the data and formatting of import.
In this example — we have determined the data we need is on Table 006. Highlight what you want to add to Excel and click Load at bottom right.
Your selected data will appear in Excel as a Table ready for your sorting, filtering and analysis. Much better process than manually entering all the information yourself or editing a bad copy & paste.
