Extract Data from PDF to Excel

How to Extract Data from PDF to Excel?

There are 3 different methods to extract data from PDF to Excel; they are mentioned below:

  1. Extract Data using Simple Copy and Paste Command
  2. Extract Data using Microsoft Word
  3. Extract Data using Adobe Reader Software

Now let us discuss each of the methods in detail –

#1 Extract PDF Data using Simple Copy and Paste Method

The following steps are followed to extract the data using simple commands copy and paste.

  1. Select the PDF file and open it in Adobe Acrobat Reader software, as shown in the figure.

    Extract data from pdf to excel Example 1

  2. Select and copy the data presented in the table.

    Extract data from pdf to excel Example 1-1

  3. Go to Excel and select the drop-down section of the “paste” and click on the “Paste Special.”

    Extract data from pdf to excel Example 1-2

  4. It opens the “paste special” dialog box, as shown in the figure.

    Extract data from pdf to excel Example 1-3

  5. Select the paste option as “text” and click on “OK.”

    Extract data from pdf to excel Example 1-4

  6. The data extracted into the Excel sheet is shown in the below-mentioned screenshot.

    Extract data from pdf to excel Example 1-5
    As shown in the figure, data is entered into only one column.

  7. Select the data and click on the “Text to column” option in excel in the “Data” tab.

    Extract data from pdf to excel Example 1-6

  8. Choose the file type as “Delimited” and click on the “Next” button, and it opens the following screenshot.

    Extract data from pdf to excel Example 1-8

  9. Choose the Delimiters as “Space” and click on “Next.”

    Extract data from pdf to excel Example 1-9

  10. After clicking next, the following wizard will be opened.

    Extract data from pdf to excel Example 1-10

  11. Click on “Finish” to close the wizard, and then the text is converted to columns, as shown in the figure.

    Extract data from pdf to excel Example 1-11

  12. Clean up the data to ensure that “blue LED value” into one cell, “green LED value” into one cell,” and “red LED value” into one cell.

    Extract data from pdf to excel Example 1-12

#2 Extract PDF Data to Excel Using Microsoft Word

The following steps are followed to extract the data using Microsoft word.

  • Step 1: Select the PDF file and open it in Adobe Acrobat Reader software.
Extract data from pdf to excel Example 2
  • Step 2: Select and copy the data presented in the table.
Extract data from pdf to excel Example 2-1
  • Step 3: Open Microsoft Word document and paste data into it, as shown in the figure.
Extract data from pdf to excel Example 2-2
  • Step 4: Again, copy the table and paste now it into an Excel sheet, and it will be displayed as.
Extract data from pdf to excel Example 2-3
Note: Pasting directly into Excel leads to display data in one column only.
  • Step 5: Arrange the table headers properly, as shown in the PDF file, by applying the merging and unmerging on cells.
Extract data from pdf to excel Example 2-4

#3 Extract PDF Data to Excel using Adobe Reader Software

The following steps are followed to extract the data using the Adobe reader

  • Step 1: Select the PDF file and open it in Adobe Acrobat Reader software, as shown in the figure.
Export pdf Example 2-5
  • Step 2: Go to the “File” menu and select the “convert to Excel, Word, or PowerPoint” option.
Export pdf Example 2-6

After clicking on the convert option, the following page will be displayed.

Export pdf Example 2-7
  • Step 3: Select the “convert to” drop-down menu and choose the “Microsoft Excel Document (*.xlsx) format.
export Example 2-8
  • Step 4: Then, click on the “Export to Excel” option.
Export pdf Example 2-9
  • Step 5: The exported data into Excel is displayed, as shown in the figure.
export pdf Example 2-10
  • Step 6: Apply cleaning to arrange the data properly into the rows and columns to change the design of the table.
Export pdf Example 2-4

Things to Remember

  • Extracting data from PDF to Excel is possible only when we are able to copy the data in a table in PDF file.
  • The data directly copy-pasted directly from the PDF to Excel will unwind into an only column or one cell. This requires clean-up activities to arrange the data properly.
  • To extract data using the Adobe Reader software, a user account is necessary with the adobe.com.

This has been a guide to Extract Data from PDF to Excel. Here we discuss how to extract data from pdf to excel using 3 methods, which include 1) Copy and Paste Option, 2) Microsoft word, and 3) Adobe Reader along with some examples. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>