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

2 min. read

Published on August 12, 2020

published on August 12, 2020

Readers help support Windows Report. We may get a commission if you buy through our links.

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 announced on the Microsoft Tech Community blog earlier 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 the Pdf.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.