How to Import a PDF to Excel – 2 Easy Methods

This is a sample dataset.

1- overview image of export pdf to Excel

Download Practice Workbook

You can download the practice workbook and the PDF file:


Method 1 – Exporting a PDF to Excel Using the Get Data Option

Step 1: Prepare the Dataset in PDF

The sample dataset contains of 8 rows and 4 columns (ID, Name, Region and Sales).

  • Save the file as Export PDF to Excel.pdf.

2- prepared dataset in pdf to export pdf data to Excel

Step 2: Export Data from PDF to Excel

  • Open your Excel workbook.
  • Then go to Data >> Get Data >> From File >> From PDF.

3- selecting from pdf option from data tab

  • In the Import Data window, select your file: Export PDF to Excel.pdf.
  • Click  Import. Make sure to choose All Files.

4- selecting the pdf file in the import data window

  • The Navigator window will open.
  • By default, Excel will convert the PDF file into a table named Page001.
  • Select Page001  to see a preview of the table.
  • Click Transform Data to edit the table.

5- selecting table Page 001 in the navigator window

Step 3: Format a PDF Data Table with the Power Query

  • The first row of the table is not necessary.

6- removing the row from the table that is not necessary

  • To remove it, select Reduce Rows >> Remove Rows >> Remove Top Rows.

7- selecting remove top rows option to remove unnecessary rows

  • In the Remove Top Rows window: Enter 1 in the Number of Rows.
  • Click OK.

8- entering number of rows that should be removed to export pdf to Excel

Step 4 – Load the Dataset in Excel

  • Select Close & Load.

9- selecting close and load option to load pdf data to Excel

  • The table will be displayed in the Excel sheet.
  • You can customize it.

10- exported pdf data table to Excel sheet


Method 2 – Exporting Data from PDF to Excel using Microsoft Word

  • Select the dataset in the PDF file and press ‘Ctrl+C’ to copy the data.

11- selecting dataset from pdf to export data from PDF to Excel through Microsoft Word

  • Open Microsoft Word and select a Blank document.

12- selecting blank document option in microsoft word

  • Right-click  and in Paste, choose Keep Source Formatting (K).

13- choosing Keep Source Formatting (K) option to paste data from pdf to microsoft word

  • The dataset in the pdf file will be displayed in the Word file.
  • Click the Move Pointer icon, and press ‘Ctrl+C’ to copy the table.

14- clicking move pointer icon and copying the dataset from word file

  • In the Excel worksheet, select any cell and press ‘Ctrl+V’ to paste the dataset.
  • Create a suitable dataset title and use the Font, Alignment, and Style group on the ribbon to format it.

15- exported data from PDF to Excel through Microsoft Word

Frequently Asked Questions

1. Will the exported Excel file keep the same formatting as the original PDF?

Depending on the conversion method and the PDF file’s complexity, the level of formatting preservation may vary. Simple tables and text formatting are more likely to be converted to Excel accurately. Complex layouts, images, and other formatting elements may not be precisely replicated in the Excel file.

2. Can I convert a scanned PDF to Excel?

Yes, you can convert a scanned PDF to Excel, but you’ll need optical character recognition (OCR) software. With an OCR software text can be recognized from scanned images and converted into editable text. Online and offline PDF converters include OCR capabilities.

3. Can I export multiple PDF files to Excel simultaneously?

Depending on the tool or method you use, you may be able to export multiple PDF files simultaneously. In some software applications, you can process files in batch mode or convert multiple files at once, while in others, you must convert files individually.

Import PDF to Excel: Knowledge Hub

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

Get FREE Advanced Excel Exercises with Solutions!
Nujat Tasnim
Nujat Tasnim

Nujat Tasnim, BSc in Computer Science and Engineering from American International University-Bangladesh, has a year-long tenure with ExcelDemy. Initially a Content Developer at SOFTEKO, she transitioned to the Software Team as Junior Software Quality Assurance Engineer. Currently serving as a Junior SQA Engineer at SOFTEKO, she excels in SDLC, STLC, and requirement analysis and possesses profound insights into OOP-related software development processes. Nujat is also proficient in design software like Photoshop and Illustrator, contributing diverse skills to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF