There are a couple of ways and hacks available online on how to import data from a PDF into an Excel spreadsheet. If you have an Adobe Acrobat license the journey is easier. If you don’t have one check the simple tutorial below to learn how you can easily import a table from a PDF file into excel without bringing the rest of the content and messing up your data.
1 – Click on "Data" on the top of the taskbar and then the option "Get Data".
2 – Once you have clicked on "Get Data", you will see the menu to import the data. Select the first option "From File" and then "From PDF".
3 – You will be prompted to select the file that you wish to import. Once you have selected the PDF file a pop-up window will identify all the pages of the document, navigate to the page where the table you wish to import is located and select it. A preview of the table will be displayed on the right side. If you are happy with it, click "Load" to import into Excel.
4 – Your table will be imported into the Excel spreadsheet. You may need to adjust the column’s names, etc.
Watch the video below from Microsoft to see the whole action
Master your Excel Skills at New Horizons Ireland
Being Microsoft Office skilled can be handy on a daily basis, it can save your time and make your activities more productive. At New Horizons Ireland we frequently run a wide range of Microsoft Office classes either on our premises or online. Check out below our classes.
We also provide a wide range of technical courses, such as Microsoft Azure, Windows Server, CompTIA, Cisco, and more.