How to Convert PDF to Excel without using Conversion Software – 3 Methods

To transform the following PDF into an Excel file:

Dataset in PDF-Convert PDF to Excel without Software

 


Method 1 – Using the Manual Copy Paste Method to Convert the PDF to Excel

Step 1:

  • Open the PDF file.
  • Press CTRL+A or use the Mouse Cursor to select the whole content.

Copy and Paste-Convert PDF to Excel without Software

Step 2:

  • Open a blank Excel Worksheet.
  • Right-click any cell.
  • Select Paste Special.

Context Menu

Step 3:

  • Select Paste as Text.
  • Click OK.

Paste Special

The content is pasted without keeping the format:

Outcome

You can use CTRL+V  in Steps 2 and 3.

Read More: How to Export Data from Fillable PDF to Excel


Method 2 – Using Microsoft Word to Convert a PDF file to Excel

Step 1:

  • Open Microsoft Word.
  • Go to File > Open. You can also right-click the PDF > Choose Open With > Select Microsoft Word.

Word-Convert PDF to Excel without Software

Step 2:

  • Select the PDF file.
  • Click Open.

Device directory

Step 3:

  • The following warning message is displayed.
  • Click OK.

Warning

 

Word file

Step 4:

  • Press CTRL+A or use the Mouse Cursor to select the entire content.
  • Press CTRL+C or right-click and choose Copy.

Copy

Step 5:

  • Open a blank Excel Worksheet.
  • Press CTRL+V or right-click and choose Paste.

Outcome

 

Read More: How to Convert PDF to Excel Table


Method 3 – Using the Get Data Command to Convert a PDF file to Excel 

Step 1:

  • Go to Data > Click Get Data (in Get & Transform Data) > Choose From File > Select From PDF.

Get Data-Convert PDF to Excel without Software

Step 2:

  • Select the PDF file to import into Excel.
  • Click Import.

Device directory

Step 3:

  • In the Navigator window, choose any available Page in Display Options.
  • You can select multiple items by enabling Select multiple items. Excel shows a preview.
  • Click Transform Data.

Navigator window

As the PDF contains one page only, the Navigator window displays only one page on the preview. Select multiple items to preview multiple Pages.

Step 4:

  • In the Power Query Editor window, go to Home > Click Close & Load > Select Close & Load.

Load and Close-Convert PDF to Excel without Software

Step 5:

  • Excel loads the content in table format as shown below:

Outcome-Convert PDF to Excel without Software

 

Read More: How to Convert PDF to Excel without Losing Formatting


Download Excel Workbook

Download the Workbook.


Further Readings

<< Go Back to Import PDF to Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo