Add Extra Output Features to PDF-XChange Editor Annotations Exported to Excel

Job ID: 34334260

Budget: $30 – $250 USD

PDF-XChange Editor has a nice feature that outputs highlights and comments.

Whenever you make a highlight or an annotation, you can additionally add a unique Subject Line.

So, for example, you could highlight some text in green, then add the word “Evidence” to the highlight as a user-defined Subject Line.

The system then adds green over the text on the page, COPIES that highlighted text into memory, and combines it with a Subject Line Evidence.

When you export your annotations to Excel, all highlighted texts are returned and combined with their Subject Lines.

That’s great as, once you’ve read a very long document and found, say, 25 instances of lines related to what you want to call Evidence, you can see in the export ALL of those specific lines of text each combined with the subject line “Evidence”. Great for research purposes.

You can even CREATE persistent highlight formats with user-defined Subject Lines, for example “Reword” or “Mechanics”.

This is VERY useful, too because, if you’re slogging through a long document in a specific technical field, you’re going to have lots of times where you’re seeing the same subjects again and again. So, you can single-click reuse these custom highlights without having to manually enter the Subject Line in for each “Mechanics” highlight you make.

EXPORTINGTO EXCEL

Running PDF-XChange Editor’s built-in export to Excel, all the comments are retuned there, and the highlighted text gets copied, too! So, we get the text from the document AND, via the custom Subject Line, the user’s own comments on it. Something like

(Subject Line) Actual Innovations

(Highlighted text) the resolution of any one direct force AD into two oblique forces

PDF-XChange Editor’s existing built-in export does offer some output options, but the result is too unmanageable.

Here’s the problem – once the export is run it’s all just a blob of entries in Excel. A long, long, LONG list.
What I’m hoping to do is to modify the Excel output so that it distributes all highlights in a human-friendly, sorted-by-chapter format.

The revised output design can either be a FURTHER Excel file - that is stay in Excel - or use another platform as long as it can display the data in the needed way and be searchable.

Design is outlined and illustrated in detail in attachments.
Related categories: Visual Basic Excel PDF