Q: How can I export the comments / annotations added to a PDF document into an excel spreadsheet? For example, I want to export all of the measurement annotations so that I can sort them in excel. 

A: PDF Studio (version 9 and higher) has the ability to export comments into multiple formats including XML which is compatible with Microsoft Excel. Below are instructions on how to export comments as an XML and viewing them in Excel. 

Exporting Comments as XML in PDF Studio

  1. Open the document that you wish to export the comments.
  2. There are two ways to export comments as an XML
    1. On the menu bar go to Comments->Export Comments->XML 
    2. Open the comments pane by clicking on the Comments button at the bottom left of PDF Studio. Then click on the down arrow to open the export menu and select Export to XML

  3. Select the location that you wish to save the XML file on your computer and then click Save.

Opening the XML file in Excel

  1. Open Microsoft Excel
  2. Go to File->Open and then locate the XML Comment export that you created and open the file.
  3. Select the option to open the file as an XML Table. Excel Open XML
  4. Your comments will then be sorted and organized in Excel and you can continue working with the excel sheet as you normally would.
Tagged: