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 11 Pro and Microsoft Excel 2013. Here are a few easy methods.
To Export A Data Selection to Excel Instantly:
- 1Open your PDF in Adobe Acrobat 11 Pro.
- 2Use the selection tool to select the table of data you want to export.
- 3Right-click on your selection. You can then try 3 options:
- You can select Copy. However, when using this option, note that pasting your content into Excel won’t retain the original formatting of the table. You will have to reformat the text into a table MS Excel.
- Or you can choose Copy with Formatting, which will allow you to paste the table into a spreadsheet.
- You can also choose Export Selection As…. This will bring your table or the entire document (if selected) right into Excel.
For exporting entire PDF files containing tabular data, you can save the file as a spreadsheet itself. To do this:
- 1Open the PDF file you wish to export to Excel.
- 2 Go to File > Save As Other… > Spreadsheet > Microsoft Excel Workbook.
- 3In the Save As dialog that appears, save your file with the name and in the location of your choice.
To Import CSV Data into Excel:
- 1Have an Excel spreadsheet opened. Click on the Data tab and. Go to Get External Data > From Text.
- 2Select your CSV file. Click on Import.
- 3In the Text Import Wizard, select your file type and the starting point for importing your data. Click on Next.
- 4Select the type of delimiters in your data. Click on Next.
- 5In 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.
- 6When in the main dialog, click on Finish.
- 7In the next dialog box, specify where you want to place your data and click on OK.
