WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Extract Data from PDF to Excel

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.

  • Step 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

  • Step 2: Select and copy the data presented in the table.

Extract data from pdf to excel Example 1-1

  • Step 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

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Extract data from pdf to excel Example 1-3

  • Step 4: Select the paste option as “text” and click on “OK.”

Extract data from pdf to excel Example 1-4

  • Step 5: 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.

  • Step 6: 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

It opens the “convert text to columns” wizard, as shown in the figure.

Extract data from pdf to excel Example 1-7

  • Step 7: 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

  • Step 8: Choose the Delimiters as “Space” and click on “Next.”

Extract data from pdf to excel Example 1-9

  • Step 9: After clicking next, the following wizard will be opened.

Extract data from pdf to excel Example 1-10

  • Step 10: 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

  • Step 11: 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.

Recommended Articles

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 –

  • Extract Number from String Excel
  • Auditing Tools in Excel
  • Excel Hacks
  • How to Export Excel into PDF?
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More