Convert PDF to Excel with Acrobat

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.”

Open file in Acrobat

 

Step 2: Click “File” at the top of the window, then click “Save As.”

Select "Save As" from the "File" menu

 

Step 3: Click the drop-down menu to the right of “Save as Type,” then click “Tables in Excel Spreadsheet.”

Save PDF as "Tables for Excel"

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.