NOTE: I wrote this article for Acrobat 9. In Acrobat X, exporting to Excel is super simple and works great. Just choose File> Save As> Spreadsheet. It’s worth the upgrade for this feature alone! |
To open the XML-based file output generated using method 2 above, you’ll need either:
|
What are the other options? Copy as Table will copy the data to the clipboard. From there, you can paste it into Excel or another document. Save as Table will allow you to name the data and save it as a Comma Separated Value (CSV) file. Mac Users: Only Copy as Table and Save as Table are available. |
Save as Tables works better in Acrobat 9.1 Adobe greatly improved the capability to export to Excel using this method in Acrobat 9.1. Acrobat 9.0 sometimes exported XML tables that Excel could not open. Make sure you update. |
How do I open the file in Excel? Depending on your file associations, you may not be able to double-click the resulting XML file to open it in Excel. You’ll need to open Excel and choose File—> Open Where are all the pages? Each page in the PDF is converted to a different worksheet in the Excel file. Look at the tabs at the bottom of the screen. |