How to Export PDF Comments into an Excel Spreadsheet (3 Quick Tricks)

Often, we need to work with comments within a PDF file. We’ll show you 3 easy methods of how to export PDF comments into an Excel Spreadsheet. To demonstrate our methods, we’ve taken a PDF file and added comments to it.

 How to Export PDF Comments into an Excel Spreadsheet: 3 Ways

1. Using Foxit Reader to Export PDF Comments into an Excel Spreadsheet

For the first method, we’ll be using the Foxit Reader to export all comments.

Steps:

• Firstly, from the COMMENT tab >>> select Export.

The Save As dialog box will appear.

• Secondly, type a “File name:”.
• Finally, press Save.

Then, a dialog box will confirm we’ve saved it successfully.

• Press OK.

Now, we’ll open this file in Excel. To do that –

• Firstly, click on the File tab.

• Secondly, from Open >>> press Browse.

This will bring up the open dialog box.

Now, we’ll select our comment file.

• Firstly, select All Files from the dropdown menu.
• Secondly, click on our file. Which is Export_Comments_Foxit
• Finally, press Open.

We’ll see a warning message.

• Press Yes.

Thus, we’ll export PDF comments into Excel.

• After that, we’ll remove the blank rows.
• Finally, do some formatting to the cells.

This is what the final step should look like.

Read More: How to Extract Data from PDF to Excel

2. Export Selected PDF Comments into an Excel Spreadsheet Using Adobe Acrobat DC

In this section, we’ll use Adobe Acrobat DC to export selected comments from a PDF.

Steps:

• Firstly, select Comment from the right side of the PDF file.

• Secondly, select the comments that we’ll export.

• Thirdly, from Options >>> select “Export Selected to Data File…”.

The Export Comments dialog box will appear.

• Then, choose a filename.
• Finally, press Save.

Now, as shown in method 1, we’ll bring up the Open dialog box in Excel.

• Select the file which is Acrobat and press Open.

This will import the selected comments into the Excel file.

After, doing some formatting, our final step should look like this. Thus, we’ve shown you yet another method of exporting comments into an Excel Spreadsheet.

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

3. Utilizing PDF Studio to Export PDF Comments as CSV File

In this last method, we’re gonna use the PDF Studio to export PDF comments as a CSV file. Then, we’ll export this CSV file to our final Workbook.

Steps:

• Firstly, from the Comment tab >>> select the Export button.

• Secondly, select Comments (CSV) from the dropdown list.

• Thirdly, click on Save.

After clicking this, a CSV file will open with our comments.

• Finally, we’ll adjust the column widths and add other formatting features.

In conclusion, we’ve shown you the last method to export PDF comments.

Read More: How to Extract Data from Multiple PDF Files to Excel

Things to Remember

• We’re using Foxit Reader 7.3, Adobe Acrobat DC (2015.0), and PDF Studio 2021. If you’re using an earlier version, your interface may not match.
• You can follow methods 2 and 3 only if you have the paid version of that software.

Download Practice Workbook

Conclusion

We’ve shown you 3 easy methods of how to export PDF comments into an Excel Spreadsheet. If you face any problems, feel free to reach out to us via the comment section. Thanks for reading, keep excelling!

Related Articles

• How to Link PDF Form to Excel Database
• How to Convert PDF to Excel without Software
• How to Convert PDF to Excel without Losing Formatting
• How to Convert PDF to Excel Table
• How to Extract Specific Data from PDF to Excel Using VBA

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