PDFs are useful for distributing and archiving data. Unfortunately, it is difficult to change data in a PDF table or chart. Sometimes, we may want to examine or sort the data in a PDF. Microsoft Excel has various tools for sorting and calculating data. As a result, copying data from a PDF to Excel may be advantageous. This article will demonstrate all possible effective ways to copy from PDF to Excel table.
Download Practice Workbook
You can download the workbook and practice with them.
2 Effective Approaches to Copy from PDF to Excel Table
There seem to be various reasons that someone would want to transfer files from a PDF file to a Workbook. We may use this to prevent individually typing the information from the PDF into each cell.
For describing the approaches to copying tables from PDF to Excel tables, we consider the following information on a PDF. So, the information is a company’s employee details. The Employee Name, Join Date, Resign Date, and Total Working Year for this company. Now, suppose we want some changes to that. But we have only the PDF file, and we all know that we can not edit any PDF file. For this, we need to take this table on pdf to excel.
1. Use Data Tab to Copy Table from PDF to Excel
The Data tool is a property for reorganizing and categorizing data in Excel, as well as converting daily data to monthly or seasonal data. This is the best solution for copying tables from pdf to excel. We have to follow some steps for this. Let’s see the procedures down.
- Firstly, go to the Data tab from the ribbon.
- Secondly, select Get Data, under the Get & Transform Data category.
- This will appear in a drop-down menu bar, from there go to From File.
- Next, click on From PDF.
- This will open up the Import Data dialog box.
- After that, go to the PDF file location, and select the PDF file.
- Then, click on Import.
- This may take some time to open the Navigator.
- Now, from the Navigator, select the table that you want to open up on the excel file.
- Further, click on the Load button.
- And, that’s it! The table that you want to copy, is now duplicated in the excel file.
- Here, if you want to make any changes, you can do that.
Read More: Copy Table from PDF to Excel with Formatting (2 Effective Ways)
- How to Export PDF Comments into an Excel Spreadsheet (3 Quick Tricks)
- Convert PDF to Excel without Software (3 Easy Methods)
- How to Extract Data from PDF to Excel (4 Suitable Ways)
- How to Extract Data from Multiple PDF Files to Excel (3 Suitable Ways)
2. Convert the PDF into a Word Document to Copy Table
Microsoft Word is a portable document editor that you can use on the move. Composing and editing are not limited to the workplace. We can copy a table from PDF to excel with the help of a word file. This may be a lengthy process and couldn’t give you the best result you wanted. But this will work. Let’s look at the procedures for this.
- In the first place, open your word document and go to the File tab from the ribbon.
- Then, select Open and click on This PC.
- This will take you to the computer directory.
- Instead of doing this, you can press Ctrl + O to open the computer directory.
- Now, go to the location where your PDF file is located.
- After that, select the PDF file and click on the Open button to open the file in the Word document window.
- A Microsoft Word message will appear. Click OK to proceed.
- By following the above steps, you can see the pdf file is now open in your Word document window.
- Further, select the table that you wish to copy by pressing Ctrl + C.
- Furthermore, open your Excel file and paste the table by pressing Ctrl + V on your keyboard.
- Finally, you will be able to see that the table is copied. It may not look that good. But it’s better than just normal copying directly from the PDF.
Read More: How to Convert PDF to Excel without Losing Formatting (2 Easy Ways)
The above methods will assist you to Copy from PDF to Excel Table. I hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!