How to Export to Excel
It is a common thing for users to organize numerical data into tables with Excel and then save it in the PDF format. But suppose you need to re-use that information? It is nearly impossible to edit PDF content.
To do so, you would have to export your PDF to editable Excel spreadsheets. Luckily, you can export content in a PDF to Microsoft Excel with Adobe Acrobat 9 Pro and Microsoft Excel 2007. Here are three easy methods.
To export to Excel:
Open your PDF in Adobe Acrobat 9 Pro.
Use the selection tool to select the table of data you want to export.
You can then try 3 options:- A) Right-click on your selection. Choose Open Table in Spreadsheet. This will bring your table or the entire document (if selected) right into Excel.
- B) Or you can choose Copy as Table. You can then paste the table into a spreadsheet.
- C) Another way to export data: choose Save as Table. This option will save your table in a Comma Separated Values file, which you can import into Excel.
To import into Excel:
- Have an Excel spreadsheet opened. Click on the Data tab and choose From Text. Select your CSV file. Click on Import. In the Text Import Wizard, select your file type and the starting point for importing your data. Click on Next.
- Select the type of delimiters in your data. Click on Next.
- In the next step, select the column and data format. Click on Advanced for more options.
- Clicking on Advanced will let you specify how Excel recognizes numeric data. Click on OK.
When in the main dialogue, click on Finish.
In the next dialogue box, specify where you want to place your data and click on OK.
