How to Export Data from Fillable PDF to Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

The article will show you some effective steps to export data from fillable PDF to Excel. If you are an employer or a businessman, fillable PDFs can be useful to you as you can provide them to your future employee or customer for necessary information. Moreover, fillable PDFs have many other applications.

In this article, we will have a PDF form where a candidate can fill up some necessary information about him/her. We will represent this form in an Excel file.

export data from fillable pdf to excel

Step 1: Exporting Data from Fillable PDF to Excel 

The most effective way to export data from a fillable PDF file to an Excel file is to apply the Get Data wizard from the Data tab. This will turn the information of the PDF file into an Excel table. Let’s see the procedure below.


  • First, go to Data >> Get Data >> From File >> From PDF

  • The Import Data Window will appear. Select the PDF file that you want to import to your Excel File. In my case, the name of the file is Fillable_Form.
  • Click on Import. Make sure to select All Files.

export data from fillable pdf to excel

  • After that, you will see the Navigator window. Excel will convert the PDF file into a table and name the table Page001 by default. So select Page001 and you will see a preview of the table on the right side.
  • Now click on Transform Data if you want to edit the table. Otherwise, you may just click on Load which will bring you the table in a new sheet.

This operation will bring this data into a Power Query Editor.

Read More: How to Export PDF Comments into an Excel Spreadsheet

Step 2: Formatting Fillable PDF Data Table in Excel

Here, you can see that the first row of the table is not necessary. So I want to remove this row from this table. The necessary steps are given below.

export data from fillable pdf to excel


  • Select Reduce Rows >> Remove Rows >> Remove Top Rows.

  • Later, you will see a window asking you how many rows from the top you want to remove. In this case, I want to remove the 1st row so I wrote 1 in the Number of Rows section and clicked OK.

export data from fillable pdf to excel

  • After that, you will see the first row removed from the table. We want to present this table in an Excel sheet. So I selected Close & Load.

The execution of this operation will lead this data into an Excel sheet as a table. You can customize it according to your own convenience as some data or text may not appear in the Excel file.

export data from fillable pdf to excel

Thus you can export data from a fillable PDF file to an Excel File.

Read More: How to Extract Data from PDF to Excel

Things to Remember

If you have Adobe Acrobat Pro version, you can export data directly from it.

  • First, you need to open the fillable PDF file with Adobe Acrobat Pro.
  • Then select Tools >> Forms >> More Form Options >> Merge Data Files into Spreadsheets.
  • By doing this, you can export everything from your fillable PDF file to Excel spreadsheet.

Download Practice Workbook


Suffice to say, you can achieve the basic idea of how to export data from fillable PDF to Excel after reading this article. If you have any feedback regarding this article, please share your idea in the comment box. This will help me enrich my upcoming article.

Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Meraz Al Nahian
Meraz Al Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

  1. I get the following message when I try this:
    This document restricts some Adobe Acobat features to allow for extended features in Adobe Reader. To create a copy of the document that is not restricted (and has no extended features in Adobe Acrobat Reader), click Save a Copy.

    Yes I am opening in Acrobat (not reader)
    I learned that my fillable PDF should be Save as Other – Reader Extended PDF – Enable Form Fill-In and Save in Acrobat Reader.
    I posted on our website without doing the above and some and people submitted blank doc. I saved as instructed above and now I can see the forms filled, but I can’t merge them as instructed.

    • hi Chris, thanks for your response! A possible reason could be that you may not have the original or latest version of Adobe. If that’s the case, please install that. Hope this helps.

  2. Hi! I am wondering if the adobe pro method could be used to create an excel spreadsheet containing all new hire info. Here is what I am trying to do: I want to create an adobe fillable “new hire” package, email it to new hires (several hundred at once), collect all forms, merge all completed forms in 1 pdf, convert all the data from each individual forms in excel for quick data entry or system upload purposes. Could this work?

    • Hello Melissa, thanks for reaching out. To answer your question, yes, you can export data from that PDF file to Excel. Just for a reminder, when you do that, please follow the steps.
      1. Open the PDF file in Adobe Acrobat Pro.
      2. Then select Tools >> Forms >> More Form Options >> Merge Data Files into Spreadsheets.
      By doing this, you can export everything from your fillable PDF file to Excel Spreadsheet.

  3. Is there a way to get the info that was filled in the pdf into Excel? In the example you showed above, the Columns with the descriptors comes through (Full Name, Age, etc), but Column 2 with the personal info is still blank.

    • Reply Avatar photo
      Nazmul Hossain Shovon Dec 4, 2022 at 12:24 PM

      Hi Cory,
      You can follow the steps below for this:
      1. Fill up the information in the pdf file. Then go to File >> Save as Text. This will create a file in .txt format.
      2. Now open an Excel sheet. Go to the Data tab. Here in the top left corner, click on From Text/CSV and select the text file you just saved.
      3. Finally in the next window, click on Load and this should bring the filled-in information as well.
      Hope this helps!

Leave a reply

Advanced Excel Exercises with Solutions PDF