How to Convert PDF to Excel Using Adobe

By Marina Martin

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.

Things You'll Need

  • Adobe Acrobat paid version

Step 1

Open Adobe Acrobat.

Step 2

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 3

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 4

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

Step 5

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

Step 6

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

Step 7

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

Step 8

Open Microsoft Excel.

Step 9

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 10

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

Step 11

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

Step 12

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

Step 13

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