Exporting Adobe PDF form data to Excel (CSV)

Tags PDF

If Adobe Acrobat Pro DC is installed on your computer, you can export the data from one or more Adobe PDF forms to use in Microsoft Excel. 

Open a PDF


Open a PDF in Adobe Acrobat Pro DC.

Click Prepare Form


Click the Prepare Form button. (or click Tools > Prepare Form). The form options drawer will open.

Click More


Click the More button.

Click Merge Data Files into Spreadsheet


Select Merge Data into Spreadsheet. The Export Data From Multiple Forms window will appear.

Click Add Files


Click Add Files. The File Open window will appear.

Open the desired PDF file(s).


Locate and select the desired PDF files [1]. You can select more than one. The PDF files do not need to be open in Adobe Acrobat Pro DC.

Click Open [2].

Click Export


Click Export. The Save file window will appear.

Save the CSV file


Select a folder to save the CSV file and click Save.

 View the CSV file

""
Click View File Now to open the CSV file in Excel. 

It is recommended to save the .CSV file as a .XLSX file for later use in Excel. 
""

Save the CSV file as an XLSX file

""
Click File > Save As and change the file type to .XLSX [1] and Save [2] the file for later use in Excel.