In order to be able to use Excel’s PDF importer feature, you must first connect a PDF document to the Excel spreadsheet you are working on.įollowing are the steps that will guide Office 365 users on how to establish a connection between a PDF document and an Excel spreadsheet: How to use PDF Data Connector in Microsoft Excel Importing PDF data into Excel spreadsheets is part of Excel’s Get & Transform feature. This way, users select data they wish to import into an Excel spreadsheet. Similar to any other data source in Excel, Office 365 subscribers can now establish a connection between Excel and a PDF document. If you have any older version of Office, such as office 2010, head to the Microsoft Support page for more information.Importing data from PDF documents into Excel spreadsheets has become easier, courtesy of PDF Data Connector. Click “Save” to save the new PDF version. Click “Ok” to close the “Options…” window. “Selection”: convert a previously highlighted selection as PDF.“Active sheet(s)”: convert only the sheets with data as PDF.“Entire workbook”: convert the whole workbook as PDF.Under “Publish what”, choose to publish using the following options: In the “Save as type” dropdown, select “PDF”. In your workbook, head to File > Save As, or File > Save a copy. The following steps are compatible with the following versions: Microsoft 365, Office 2021, Office 2019, and Office 2016: Let’s take a look at how to save your Excel as PDF for both Windows and macOS. What’s more, you can easily convert your Excel to PDF without a converter. This method is best for those using the Excel desktop app.

It may be best to use “Save As” rather than “Save”, so you have your original format as well as the PDF version.

This is possibly the most common way to turn your Excel workbook into a PDF.

Copy data from pdf into excel