How to Convert a PDF to Excel Using Adobe Professional

If you have a Portable Document Format (PDF) file you want to save as a spreadsheet, you can convert it to a Microsoft Excel file using Adobe Acrobat Professional. This is quite useful when you have a table of important data that you want to organize. Acrobat Professional allows you to convert existing tables from a PDF to Excel. However, for the process to work, the PDF data must have been created as a table. If the data was not formatted as a table, use a different method to successfully save multiple pages of a PDF to Excel.

...
You can convert a PDF file to Excel using Adobe Acrobat Professional.

Convert Table to Excel

Step

Open a PDF document in Adobe Acrobat Professional.

Step

Click the “Select” tool from the “Select & Zoom” toolbar.

Step

Click the “View” menu and select “Page Display, Single Page Continuous.” This will allow you to select tables that are more than one page long.

Step

Press “Alt” while you click and drag a rectangle around the row and columns you want to export.

Step

Right-click the highlighted selection. Select “Open Table in Spreadsheet.” This will create a CSV file in Microsoft Excel.

Step

Save the file as an XLS file in Microsoft Excel.

Convert Multiple PDF Pages to Excel

Step

Repeat steps 1 to 3 from the above section.

Step

Select the first page by highlighting from the top left to bottom right of the page. Put your cursor on a highlighted area on the page and right-click.

Step

Select “Open Table in Spreadsheet.” A CSV file will open in Excel.

Step

Repeat steps 2 and 3 for each page of the PDF.

Step

Open Excel and combine the CSV files into one worksheet. Save the file as XLS.