How to Convert PDF to Excel Using Adobe

Adobe, the original creators of the Portable Document Format file (PDF), makes two different versions of software for interacting with PDFs: Adobe Acrobat Reader, a free tool for Macs and PCs to open/view PDFs, and Adobe Acrobat, a paid program that you can use to create, edit, and save PDF files. Adobe Acrobat can convert an existing PDF file into an Excel spreadsheet to help you more easily manipulate data stored in PDF format.

Businesswoman using laptop computer
credit: Jupiterimages/Pixland/Getty Images

Step

Open Adobe Acrobat.

Step

Go to “File” -> “Open” and navigate to the folder where the PDF you wish to convert is saved. Highlight the filename and click “Open.”

Step

Click “Shift” + “V” to launch the "Table/Formatted Text Select Tool." (Alternatively, you can select this from the "Text" button on the menu, which looks like the letter T next to a small dashed box.)

Step

Click and drag a box around the table you would like to export.

Step

Right-click inside the box you just created. A menu should appear. Confirm there is a check mark next to the word “Table.”

Step

Select “Save As” from this menu. Enter a filename and navigate to a folder you’ll be able to locate easily.

Step

Select “ANSI Text (*.txt)” from the “Save as Type” drop-down menu. Click “Save.”

Step

Open Microsoft Excel.

Step

Go to “File” -> “Open.” Choose “All Files” from the “Files of Type” drop-down menu. Highlight the *.txt file you created earlier and click “Open.”

Step

Click the radio button next to “Delimited” in the first screen of the "Text Import Wizard" that appears, then click “Next.”

Step

Check the box next to “Tab” and click “Next.”

Step

Click “Finish” on the final screen. Your new Excel document should open.

Step

Go to “File” -> “Save” and save your new Excel workbook.