It's my pleasure to share a macro (written by myself) to export ebook annotations from Adobe Digital Editions to an Excel file. The macro reads the relevant information from the "annot" files and copy it to the file parsingANNOT.xlsm. It can be downloaded here (sorry, extensions xlsm can not be attached in this forum):
Thanks so much for writing this Macro! I simply cannot believe that Adobe still has not made this action as simple as a click of a button, or just format the .annot file as a "meant for human eyes" text file. People were having the same discussion in 2013!
Unfortunately, this Macro did not work on my Mac. The error message was:
Microsoft Visual Basic
Can't find project or library
I will try running it on a Windows computer tomorrow... I hope that will work better!