Convert PDF to Excel
Saving an Excel spreadsheet as a PDF is very easy, as the menu navigation in Microsoft Office is now very intuitive. But how is it actually the other way around? How can you convert a PDF to Excel to work with it again? And what are the limitations? We want to take a closer look at this topic today and explain which options are available to you and what you have to do without in the end.
No formulas when importing a PDF into Excel
When you import a PDF to Excel, you will notice that there are no more formulas in it. This is due to the way Microsoft Excel saves the PDF. Only data that the program “sees” is taken over. This can also mean that in small cells, which cannot display all data, only the visible part is taken over. Therefore, it is often important to create the PDF correctly in advance, otherwise the data cannot be imported cleanly again.
- Switch to the “Data” tab
- Select “Get Data”, “From file” and “From PDF”
- Search for the file on your computer and click Open
- In the navigator you can now select the corresponding tables or complete pages you want to import. If you want to import more than one page, check the box “Select multiple elements”
- Then click on “Load”
The PDF import is certainly a function that is not needed on a daily basis. Nevertheless, it makes sense to deal with the possibility and to understand on which settings it depends. We hope that you can now use PDF in Excel and wish you continued success in the spreadsheet jungle!
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!