Office 365 Excel Users Can Now Import Table Data from PDF Files -- Redmondmag.com

Office 365 Excel Users Can Now Import Table Data from PDF Files

By Kurt Mackie
08/07/2020

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.

The ability to grab table data from PDF files seems like it should already have been there in Excel, but it's just rolling out now. Users with paid Office 365 subscriptions whose organizations opted to receive so-called "Current Channel" feature updates are starting to get access to the Excel PDF table import feature.

Microsoft recently revamped its Office 365 feature-update channel names. The Current Channel signifies that Office 365 feature updates will arrive on a monthly basis. It's these Current Channel users that will see the PDF table data import feature first, prior to a larger and more general rollout.

Technically, Microsoft built a "PDF data connector" for Excel, which lets end users import PDF table data using the Data tab in Excel. They select "From File" and then "From PDF" to import data.

After that's done, end users will see a so-called "Navigator window." It lets them select from a list of tables within the PDF document, identified by page number.

Users can select "one or multiple elements to import into Excel," the announcement explained. It's also possible to use the "Transform Data" function to clean the data first.

Microsoft's Power Query Editor provides a graphical user interface for prepping and transforming such data. This tool also can be used for importing PDF table data that span multiple pages.

Enabling PDF table imports had been "one of the top requests" of Excel users, Microsoft's announcement explained. Microsoft also has an optical character recognition import capability in Excel for grabbing data from photos, but it's just available now for the mobile app versions. Another capability Microsoft has been working on is to make Excel recognize data by topics, such as displaying nutritional information for food items.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.