If you’re like most people, you probably have a PDF file that contains data you need to work with. But if you want to import the data into Microsoft Excel, there are a few things you need to know. First, the PDF must be in an open format such as PDF or DOC. Second, the data in the PDF must be organized into tables and fields. Finally, the data in the PDF must be entered into Microsoft Excel as text cells. To import the data from a PDF into Microsoft Excel, follow these steps:

  1. Open Microsoft Excel and create a new worksheet.
  2. In the worksheet’s header, click on the arrow next to “PDF.” This will take you to a menu where you can select which format your PDF will be in when it’s imported into Excel: PDF or DOC. If your PDF is in DOC format, select that option and then click on “OK.” If your PDF is inPDF format, however, you’ll need to select “Open With” before clicking on “OK.” 3. In the “PDF” field of the new worksheet, enter your name for the file (e.g., mypdf). 4. In the “Table” field of this new sheet, enter all of your table’s information (e.g., name of table and columns). 5. Click on “Create Table.” 6. In the table’s header, click on one of its cells (e.g., cell A1) and then type in all of your table’s information (e.g., name of table and columns). 7. Click on “Create Table.” 8. Repeat these steps for each table in your pdf file! 9. Click on “Close Sheet.” 10a If everything went well when you opened up Excel after importing your pdf file - if not please check out this article for more tips on importing data from pdfs into excel

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.

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.

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.

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.

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

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.

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.

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.