Many times you will get tasked with converting a pdf file to an Excel file. Since pdf is such a popular format, this may happen quite a bit. While Excel let’s you save an Excel file as a PDF, it doesn’t let you open a PDF as an Excel. so that is why it needs to be converted.
To do this you need to use an external software. One great one I found is the Able 2 Extract Software.
This software will convert pdf to Excel, word, Powerpoint, Publisher, Html and more. It also will do a batch update where you can upload mulitple pdf’s and get them converted easily.
I am going to go through quickly how to do it.
After opening up the software, click on Open on the left side and pick your Pdf file.
Now you should see your pdf file in the main part of the software. Click on the All button at the top to select the whole Pdf document. It should then hilight all your data.
Then click on the Excel button and it will give you a wizard.
In this wizard, choose Convert and it will convert it to Excel. It will ask you where you want to save it.
And then once you save it, it will bring up the file in Excel. All set to go.
The whole process only took me maybe a minute.
And there is a free trial to check it out. I only recommend products that I use and that I feel are good and this one is good if you have to do a lot of converting Pdf files to Excel.