Sooner or later, youll get a PDF file youll need to view in Microsoft Excel.

The good news is that Excel has an integrated feature that allows you to do this.

When the options appear, choose the Get Data dropdown menu.

Excel

On the Navigator pane, youll see a list of all the pages your PDF has.

When you tap on a page, you could preview the content on the right side.

you’ve got the option to do this by clicking on the Load To option.

Datab Tab Excel

Here you could do various things such as add or remove columns, format the data, and more!

Youll need to hit the Data tab, followed by the Queries and Connections option.

Under Queries and Connections, you should see the page from your PDF.

PDF Excel

Place the cursor over it, and a window will appear to the side.

Here, it’s possible for you to also do all sorts of things such as:

Conclusion

Navigation pane Excel

Excel Load Settings

Import Data Windows Excel

Transform Data Excel

Queries and Connections

Excel Queries side window