Extract Highlights and Annotations from Kobo Ebook Reader

Productivity Sauce
Kobo ebook readers are great, but they have one weak spot: there is no easy way to export annotations and highlights. The good news is that Kobo readers run Linux and they store all data (including highlights and annotations) in the KoboReader.sqlite SQLite database inside the hidden .Kobo directory. Better still, you don't have to wrangle the desired data from the database manually: you can use a Python script developed by Alberto Pettarin to do all the hard work for you. Copy the KoboReader.sqlite from your Kbo reader to the local machine, download the script, and make it executable using the chmod +x export_Kobo_notes.py command. To export all highlights and annotations to a text file in the comma-separated format, use the following command:
./export_Kobo_notes.py -f KoboReader.sqlite -o highlights.csv
The script allows you to perform a couple of other actions, too. The ./export_Kobo_notes.py -t -f KoboReader.sqlite command, for example, lists all book titles containing annotations and highlights, while the export_Kobo_notes.py -c -f KoboReader.sqlite -b 'Book Title Goes Here' -o output.csv command saves highlights and annotations from a specified book in a text file.
comments powered by DisqusIssue 270/2023
Buy this issue as a PDF
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
OpenMandriva Lx 23.03 Rolling Release is Now Available
OpenMandriva "ROME" is the latest point update for the rolling release Linux distribution and offers the latest updates for a number of important applications and tools.
-
CarbonOS: A New Linux Distro with a Focus on User Experience
CarbonOS is a brand new, built-from-scratch Linux distribution that uses the Gnome desktop and has a special feature that makes it appealing to all types of users.
-
Kubuntu Focus Announces XE Gen 2 Linux Laptop
Another Kubuntu-based laptop has arrived to be your next ultra-portable powerhouse with a Linux heart.
-
MNT Seeks Financial Backing for New Seven-Inch Linux Laptop
MNT Pocket Reform is a tiny laptop that is modular, upgradable, recyclable, reusable, and ships with Debian Linux.
-
Ubuntu Flatpak Remix Adds Flatpak Support Preinstalled
If you're looking for a version of Ubuntu that includes Flatpak support out of the box, there's one clear option.
-
Gnome 44 Release Candidate Now Available
The Gnome 44 release candidate has officially arrived and adds a few changes into the mix.
-
Flathub Vying to Become the Standard Linux App Store
If the Flathub team has any say in the matter, their product will become the default tool for installing Linux apps in 2023.
-
Debian 12 to Ship with KDE Plasma 5.27
The Debian development team has shifted to the latest version of KDE for their testing branch.
-
Planet Computers Launches ARM-based Linux Desktop PCs
The firm that originally released a line of mobile keyboards has taken a different direction and has developed a new line of out-of-the-box mini Linux desktop computers.
-
Ubuntu No Longer Shipping with Flatpak
In a move that probably won’t come as a shock to many, Ubuntu and all of its official spins will no longer ship with Flatpak installed.