Exporting highlights

MoreEbooks · 06-13-2022, 09:55 AM

I make heavy use of the 'highlight' feature on my Kindle and recently discovered that calibre can download these annotations and export them to a text file. Is there a similar way to export the highlighting I do within calibre itself? The only way to see them seems to be in calibre's own reader - they do not even show up if I print the document. Maybe buried in the database somewhere...

kovidgoyal · 06-13-2022, 10:58 AM

There's an export button right on the highlights panel in the viewer. And you can export them from the tool in calinbre used to browse annotations for all books as well. https://manual.calibre-ebook.com/vie...hlighting-text

MoreEbooks · 06-13-2022, 01:30 PM

Ah, that gets me almost there - I can get a JSON file of all the annotations. However, it looks to be a dump of just the 'annotations' table in the database and lacks the actual book titles that are over in the 'books' table. The 'title' field in a 'bookmark' annotation is not the book title, but the selected text. Maybe this is a bug. I see that if I request the output in markdown format, the book title is included.

For now, I will write a short lua program to query the database directly doing the JOIN between the two tables.

kovidgoyal · 06-13-2022, 10:23 PM

The JSON includes information about annotations, not the rest of the book metadata, you get that separately and there is no reason to write a program to query the database for it. You can simply use the calibredb command line tool.

06-13-2022, 09:55 AM	#1
MoreEbooks Member Posts: 11 Karma: 10 Join Date: Jun 2022 Device: Kindle 10th gen	Exporting highlights I make heavy use of the 'highlight' feature on my Kindle and recently discovered that calibre can download these annotations and export them to a text file. Is there a similar way to export the highlighting I do within calibre itself? The only way to see them seems to be in calibre's own reader - they do not even show up if I print the document. Maybe buried in the database somewhere...

06-13-2022, 01:30 PM	#3
MoreEbooks Member Posts: 11 Karma: 10 Join Date: Jun 2022 Device: Kindle 10th gen	Ah, that gets me almost there - I can get a JSON file of all the annotations. However, it looks to be a dump of just the 'annotations' table in the database and lacks the actual book titles that are over in the 'books' table. The 'title' field in a 'bookmark' annotation is not the book title, but the selected text. Maybe this is a bug. I see that if I request the output in markdown format, the book title is included. For now, I will write a short lua program to query the database directly doing the JOIN between the two tables. Last edited by MoreEbooks; 06-13-2022 at 01:33 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting Notes / Highlights	RamonR	Kobo Reader	15	04-02-2023 07:45 AM
Exporting highlights into text	ilyasson	Onyx Boox	4	04-18-2019 10:15 AM
Exporting highlights from an epub?	archz2	Android Devices	1	11-03-2018 02:08 PM
PRS-T1 rooting for better exporting of highlights??	glukkon	Sony Reader Dev Corner	2	04-09-2012 05:25 PM
Exporting notes/highlights	thetaoofrecovery	Kindle Fire	2	03-03-2012 11:32 AM

06-13-2022, 10:58 AM	#2
kovidgoyal creator of calibre Posts: 45,343 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	There's an export button right on the highlights panel in the viewer. And you can export them from the tool in calinbre used to browse annotations for all books as well. https://manual.calibre-ebook.com/vie...hlighting-text

06-13-2022, 10:23 PM	#4
kovidgoyal creator of calibre Posts: 45,343 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	The JSON includes information about annotations, not the rest of the book metadata, you get that separately and there is no reason to write a program to query the database for it. You can simply use the calibredb command line tool.

Advert