Saturday, October 29, 2022

How to Import Data From a PDF to Microsoft Excel


To import data from a PDF file to Excel, open Excel and go to the "Data" tab, then navigate to Get Data > From File > From PDF and select your PDF. Customize the import settings as necessary for your data, then click "OK."

If you have a PDF document such as a bank statement or financial report, you may want to pull this information into Microsoft Excel. With a built-in feature, you can easily import and automatically convert a PDF to Excel.

This convenient feature can save you from hunting down a PDF file converter. Not only that, but it allows you to pick and choose the data from the file you want to import. The entire process takes only a minute.

Note: Since the time this feature was implemented, August 2020, it has only been available to Office 365 subscribers.

Connect a PDF File to Excel

To get started, select the sheet you want to work with in Excel and go to the Data tab. Click the Get Data drop-down arrow on the left side of the ribbon. Move your cursor to From File and pick “From PDF.”

Locate your file in the browse window, select it, and click “Import.”

Next, you’ll see the Navigator pane. On the left are the tables and pages in your PDF file. You can search for one at the top or simply select an element and see a preview on the right side.

When you see the item you want to import, click “Load” at the bottom of the window.

Load the data

Once your data is imported from the PDF, you should see it in your sheet along with the Queries & Connections sidebar. This handy spot lets you adjust the connected data if you wish, and we’ll explain these options below.

Data loaded into Excel

Adjust the Load Settings

If you prefer to load the data in a specific format such as a pivot table or to a new worksheet, select the Load drop-down arrow and pick “Load to” instead.

Select Load To

Then choose your options in the Import Data window and click “OK.”

Choose an import option

RELATED: How to Use Pivot Tables to Analyze Excel Data

Transform the Data with Power Query

Another option for importing data from your PDF is to transform it using the Power Query Editor. In the Navigator window where you select the element to import, click “Transform Data” at the bottom instead of “Load.”

This will open the Power Query window where you can do things like choosing or adding more columns, transposing rows and columns, managing parameters, and formatting the data.

Power Query Editor

Adjust the Connected Data

If you want to adjust the data you imported, you can do so by opening the data from the Queries & Connections sidebar. You can then take actions such as editing it using the Power Query Editor, duplicating, merging, adding a reference, or deleting the connected data.

RELATED: How to Create Your Own Data Type in Microsoft Excel

As mentioned, you’ll see the Queries & Connections sidebar open when you import your PDF file. If you happen to close it, you can reopen it by going to the Data tab and clicking “Queries & Connections” in the ribbon.

Place your cursor over the connected data and you’ll see a window appear. At the bottom, you have actions for View in Worksheet, Edit, and Delete. If you click the three dots, you’ll see options like Duplicate, Reference, and Merge.

Edit the connected data in Excel

You can also manipulate the data within your sheet as you normally would. If you’re using a table, you can filter and sort. You can also select a different style, update the font, and apply additional formatting.

RELATED: How to Create and Use a Table in Microsoft Excel

For those times when the data you need to work with or analyze comes in the form of a PDF, remember that you can pull that PDF file right into Microsoft Excel.

If you’re looking to do the reverse, learn how easy it is to save an Excel sheet as a PDF file.

Source: https://www.howtogeek.com/770474/how-to-import-data-from-a-pdf-to-microsoft-excel/

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