Excel gains support for data import from PDF tables; here’s how to use it

2 min. read

Published onAugust 12, 2020

published onAugust 12, 2020

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft Excel recently gained support for a new data import type which has been a long time in coming. Office 365 subscribers with the latest Office updates installed can now import data from tables in PDF files, removing the need for cumbersome intermediary steps.

The feature was announcedon the Microsoft Tech Community blogearlier this month. To start using data in a PDF, first open your Excel workbook and switch to the Data tab on the ribbon.

Click the “Get Data” button to the left of the ribbon and then choose the “From File” category. Next, select “From PDF” and select your PDF file in the filepicker which will appear.

After you’ve found the file, a window will appear displaying all the tables within your PDF document. Use the prompt to select the tables you’d like to import. You can choose to import tables individally or as a multiple selection.

Once you’re done, press “Load” to add the data to your Excel worksheet. Data can also be customised before import using the Power Query Editor (click the “Transform Data” button in the Navigator window). You can find further information on the feature in thePdf.Tables Power Query documentation.

Radu Tyrsina

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).

For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.

Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Radu Tyrsina

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Excel gains support for data import from PDF tables; here’s how to use it#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Excel gains support for data import from PDF tables; here’s how to use it