• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About

Microsoft Excel: How to Import Data from a PDF File

August 31, 2022 by Judy Sanhz Leave a Comment

Sooner or later, you’ll get a PDF file you’ll need to view in Microsoft Excel. The good news is that Excel has an integrated feature that allows you to do this. It’s a handy feature available for Office 365 subscribers and saves you from having to use a third-party app. Even if you’re in a hurry, it’ll be something you can do since you can do this in less than a minute.

Quickly Import Data from a PDF File to Excel

Once the Excel file is open, click on the Data tab at the top. When the options appear, click on the Get Data dropdown menu.

Datab Tab Excel

The Get Data option will give you various options but click on the From File, followed by the PDF option.

PDF Excel

Look for and select the PDF file you want to import, and click on the Import button at the bottom right. On the Navigator pane, you’ll see a list of all the pages your PDF has. When you click on a page, you can preview the content on the right side.

Navigation pane Excel

When you want to open the file on Excel and not only see a preview but also make sure to click on the Load button (Bottom right). But, if you click on the dropdown menu for the Load button, you can modify the load settings. You can do this by clicking on the Load To option.

Excel Load Settings

In the import data window, you can choose from different options such as:

  • Table
  • PivotTable Report
  • PivotChart
  • Only Create Connection

Import Data Windows Excel

You’ll see the Transform Data button to the right of the Load option. Here you can do various things such as add or remove columns, format the data, and more!

Transform Data Excel

To modify the data you imported to Excel, you can also access it from the Queries and Connections sidebar. You’ll need to click on the Data tab, followed by the Queries and Connections option.

Queries and Connections

Under Queries and Connections, you should see the page from your PDF. Place the cursor over it, and a window will appear to the side. Here, you can also do all sorts of things such as:

Excel Queries side window

  • Merge
  • Duplicate
  • Edit
  • Delete
  • Reference

Conclusion

Just because a file is in a PDF doesn’t mean you can make a few changes using Excel. You can choose from different ways of viewing your file to read it more manageable. How often do you have to view PDFs in Excel? Share your thoughts in the comments below, and don’t forget to share the article with others on social media.

You Might Also Like

  • PDF-previews-show-Index-Of
    File Explorer: PDF Preview Shows Index File Directory
  • Outlook 2010 Import option
    Outlook 2016: Backup/Export & Import Data
  • PowerPoint Header
    PowerPoint 365: How to Import Slides from Another…
  • How to Download, Sign and Email a PDF File
    How to Download, Sign and Email a PDF File
  • Word Logo Header
    How to Add a PDF to Microsoft Word
  • Microsoft Edge Crashes When Opening PDF
    Fix Microsoft Edge Crashes When Opening PDF

Filed Under: Office

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Send HD Pictures and Videos on WhatsApp
  • How to Share Files Using Google Nearby Share
  • Android Battery Will Not Charge Fix
  • Turning on Triple Touch Zoom on Android
  • How to Connect Outlook 2023 to Gmail
  • Netflix: Change Password
  • Step-by-Step Guide: How to Use WhatsApp on Your Computer
  • Android: Enable or Disable Background Data

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Data Link Layer
  • Data Type
  • Public Data Network (PDN)
  • Encapsulated Postscript (EPS) File
  • File Compression Utility
  • Microsoft Windows NT
  • Microsoft Internet Explorer
  • Microsoft Windows

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy