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.
Things You'll Need
- Adobe Acrobat Professional
- Microsoft Excel
Convert Table to Excel
Open a PDF document in Adobe Acrobat Professional.
Click the "Select" tool from the "Select & Zoom" toolbar.
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.
Press "Alt" while you click and drag a rectangle around the row and columns you want to export.
Right-click the highlighted selection. Select "Open Table in Spreadsheet." This will create a CSV file in Microsoft Excel.
Save the file as an XLS file in Microsoft Excel.
Convert Multiple PDF Pages to Excel
Repeat steps 1 to 3 from the above section.
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.
Select "Open Table in Spreadsheet." A CSV file will open in Excel.
Repeat steps 2 and 3 for each page of the PDF.
Open Excel and combine the CSV files into one worksheet. Save the file as XLS.