How to Import PDF Data into Excel Without Messing It Up

Since I rarely work with Microsoft Excel, it still feels somewhat unfamiliar. I can input data and generate charts, but that’s about it. To improve my skills, I’ve committed to mastering one new Excel trick each week.

This week, I discovered how to effectively transfer information from a PDF table into an Excel sheet. While it seems simple, it’s not always straightforward. My previous attempts to do this often resulted in messy formatting and errors.

Most people try copying and pasting directly from the PDF, but that often leads to disorganized data. A better approach is to utilize Excel’s built-in data import features. This method ensures the data is transferred cleanly and retains its original formatting with minimal effort.

Step-by-step Guide:

• Begin by opening your PDF document and locating the specific table containing the data. Note the position and index of the table. For this example, I’m using a review guide PDF for a laptop I evaluated.
• Next, launch Microsoft Excel and create a new workbook by navigating to File > New > Blank Workbook.
• From the top menu, select Data, then choose Get Data, followed by From File, and finally pick From PDF.
• Browse your files to find the PDF that contains the desired table. Select it and click Import.
• A list of tables within the PDF will appear—choose the one you need and click Load. The table will now appear in your Excel spreadsheet precisely as it was formatted in the PDF.

I hope you find this tip helpful for expanding your Excel skills. That wraps up this quick guide. If you’d like to receive more practical Excel tips like this twice a week, consider subscribing to the PCWorld Try This newsletter.