PDF files are a popular form for sending data because the formatting will remain intact, regardless of which PDF-compatible program is used to open the file. However, the popularity of PDF forms has forced many people into the habit of sending files that would be better transmitted as a different file type, such as an XML table. An XML table can be opened and manipulated by Microsoft Excel, which allows Excel users to easily sort, reorganize and perform mathematical operations on the data contained within those PDF tables. While there are several conversion utilities capable of converting from PDF to Excel, Adobe Acrobat can do it in one step, without requiring you to purchase or download any programs.
Step 1: Right-click the PDF file that you want to convert for use in Excel, then click “Open With Acrobat.”
Step 2: Click “File” at the top of the window, then click “Save As.”
Step 3: Click the drop-down menu to the right of “Save as Type,” then click “Tables in Excel Spreadsheet.”
Step 4: Double-click the converted file to open it in Microsoft Excel.
If the file does not automatically open in Excel, then you can follow the instructions in our article about changing the default program used when opening an XML file.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.