Wednesday, June 29, 2022

How to export PDF files from Acrobat to Excel, and Excel to Acrobat

You have just a few choices when working with PDFs and Microsoft Excel compared to everything you can do with PDFs in Microsoft Word. You cannot import PDFs from Adobe Acrobat directly into Excel 2016. However, you can export PDFs from Excel to Acrobat, and you can export from Acrobat to Excel. We'll show you how.
1- Export from Excel to Acrobat
2- Export from Acrobat to Excel

Export from Excel to Acrobat

1. To export from Excel to Acrobat, open an Excel spreadsheet.
2. Then choose File > Export, and click the Create PDF/XPS button.

xl15 file export create pdf


JD Sartain / IDG Worldwide
File export create pdf
3. The Publish As PDF screen appears and displays the Excel filename, followed by the Acrobat extension PDF in the File Name field box, followed by the PDF extension in the Save As Type field box (Products.pdf).
4. Click the Publish button and the system jumps to Adobe Acrobat. showing your Excel spreadsheet as an Acrobat PDF file.





xl16 publish and jump to acrobat JD Sartain / IDG Worldwide
Publish and jump to Acrobat
5. Choose File > Save As, then browse to the applicable folder (if necessary).
6. On the Save As screen, confirm the File Name (or change it), select Adobe PDF files (*.pdf) for the Save As Type, then click the Save button. Conversion complete!





xl17 save as adobe pdf JD Sartain / IDG Worldwide
Save As Adobe pdf

Export from Acrobat to Excel

1. To export the PDF from Acrobat to Excel, open the PDF file.





2. Select Export To > Spreadsheet > Microsoft Excel Workbook.
3. On the Save As screen, Acrobat enters the Export File Name for you followed by the Excel extension xlsx.
4. Ensure the Save As Type says: Excel Workbook (*.xlsx).
5. Click the Save button and the conversion is complete!





xl18 convert the pdf back to an excel wprksheet JD Sartain / IDG Worldwide
Convert the pdf back to an Excel worksheet

To comment on this article and other PCWorld content, visit our Facebook page or our Twitter feed.
JD Sartain is a technology journalist from Boston. She writes the Max Productivity column for PCWorld, a monthly column for CIO, and regular feature articles for Network World.


Source: https://www.pcworld.com/article/3314749/software/how-to-export-pdf-files-from-acrobat-to-excel-and-excel-to-acrobat.html?idg_eid=8458d72e614c68751de48f5c175520f4&email_SHA1_lc=f7e21d5e818ec725d3ee897e41e5054f614367ba&cid=pcw_nlt_pcw_powertips_html_2018-10-23&utm_source=Sailthru&utm_medium=email&utm_campaign=PCWorld%20Power%20Tips%202018-10-23&utm_term=pcw_powertips_html