How to Convert PDF Table to Excel

Part 2. Copy Table from PDF to Excel

1. Copy Table from PDF to Excel with Microsoft Word

If you want to use Microsoft Word on your computer to copy tables from PDF to Excel, check out the steps that you have to follow.

Step 1. Open the table on PDF file and copy it by clicking on Select and then clicking and dragging the cursor for highlighting the entire table, when you are done, press CTRL + C.

Step 2. Now, open a Word document and paste the text you have copied by pressing CTRL + V. To convert this PDF data to the table by highlighting it, you have to choose-Table > Convert > Text to Table. You will notice a dialogue box popping up and under the option Separate Text, you need to select other and then click on the little box present next to it. Make sure that you delete what is already there. A table is going to appear that is going to be highlighted. When it is still lighted, copy it by pressing CTRL + C.

Part 3. Paste it into Excel. Open a blank Excel document and you will find the first cell highlighted. Click on it and paste the table that you have copied from Word. For doing this, you just need to press CTRL + V. Now you can adjust the columns and rows to make the table look good.

2. Copy and Paste PDF Table to Excel(Easy Way)

Step 1. Launch PDFelement on your computer and upload the PDF file containing the table to be copied to Excel. Once uploaded, go to "Edit" on the top toolbar, select the PDF file content you want to appear on the Excel table. Double-click this content and select the "Copy" option.

Step 2. Paste the content into Excel directly. Open the Excel file on Microsoft Excel and paste the copied content to the right field. Once through, click the "Save" button to save the changes.

Part 3. Extract Table from PDF to Excel

PDFelement can also extract table from PDF to Excel. Here is how it works.

Step 1. Open a PDF File

Locate and click the "Open File" button to access the file explorer window. Select the PDF file you want to copy to Excel and click "Open" to import it to the program.

Step 2. Extract Table from PDF

When the PDF file is uploaded, click on the "Form" > "More" > "Extract Data" option. A new dialogue window will appear. You can should click "Extract data from form fields in PDF" and click "Apply" .

Step 3. Export Table to Excel

The program will extract table from PDF form into a CSV file. Open the CSV file in Excel for editing.

Part 4. Import Table from PDF to Excel

It is a method that is only going to work for Office 365 users. To import Table from PDF to Excel using the steps given below;

Step 1. Open Excel and click on the 'Data' tab and then click on 'Get Data'. Now, you have to select 'From File' and then click on 'Form PDF'.

Step 2. Choose the PDF that contains the data tables and then choose 'Import'. Microsoft will identify the tables in the PDF document.

Step 3. Click on each table for locating the right one you would like to copy. If you want, you can transform the data just by editing a few cells. However, it is easier once you copy the data into the Excel sheet.

Step 4. Click on Load for doing this. The table from the PDF will be copied and you can edit it as per your requirements.

FAQ: How to Turn PDF Table to Excel using Python

To do this, you are going to require two Python libraries: Pandas and Tabula-py.

For installing them, go over to the terminal or shell and write down the codes given below;

pip install tabula-py

pip install pandas

In case you are using Google Colab, just install the libraries directly on it. All you have to do is add the exclamation mark in the front. So, this will be;

!pip install tabula-py

!pip install pandas

You can turn a single or batch PDF table into Excel with the help of Python.