How to Convert PDF Table to Excel
In Adobe Acrobat, the software used to create, manage and distribute Portable Document Format (PDF) files, you can directly convert a table to an Excel spreadsheet. You simply need to copy the rows and columns of a data table from a PDF document. Acrobat will preserve the table formatting and automatically open the file in Excel.
Things You'll Need
- Microsoft Excel
- Adobe Acrobat
Open a PDF document in Adobe Acrobat.
Click the "Select" tool (black arrow and I-beam icon) from the Select & Zoom toolbar at the top of the window.
Open the page that contains a table you want to convert.
Click and drag your cursor over the table while pressing "Alt" on your keyboard. This will copy all the rows and columns.
Right-click the selection.
Select "Open Table in Spreadsheet" to open the table in Excel. You also can choose to "Copy as Table," which will retain the formatting. If you choose this option, open Microsoft Excel. Click "Paste" in the "Clipboard" group on the "Home" tab. Select "Paste Special," and choose "XML Spreadsheet."
Click the "Microsoft Office Button" and select "Save as" to save the converted table in Excel.