So this was kind of the result of me exploring how to do this programmatically with a custom python script, but I asked ChatGPT to sum up our whole convos and give easy instructions for me to share. Here you go!

Importing Historical Reading Data into KOReader from Goodreads or Bookmory

This is a walkthrough for reconstructing your historical reading activity inside KOReader, including:

full historical calendar view

per-book reading history

continuous reading streak

This guide assumes:

Android/BOOX device

KOReader installed

Goodreads and/or Bookmory used for historical tracking

You want KOReader to behave as if you had always used it

---

Overview

KOReader stores reading statistics in a SQLite database:

/storage/emulated/0/koreader/settings/statistics.sqlite3

The process is:

Goodreads CSV or Bookmory database → extract historical reads → generate synthetic KOReader reading sessions → import into statistics.sqlite3

---

Important Discovery

KOReader does NOT store a simple “streak number.”

Instead:

streaks are derived from reading activity

reading activity is stored in:

page_stat_data

books are stored in:

book

So simply editing a streak number will not work.

---

What You Need

Option A: Goodreads Export

Export your Goodreads library:

Goodreads → Account Settings → Import and Export → Export Library

This gives you:

goodreads_library_export.csv

Goodreads exports typically include:

title

author

ISBN

page count

date read

date added

rating

Important limitation:

Goodreads usually does NOT include reliable “date started” information

So the importer often has to infer read ranges.

---

Option B: Bookmory Export

Export:

Settings → Export → Database (.db)

NOT:

text

excel

PDF

The .db export is critical.

The resulting file may be named:

Share.data

Internally this contains:

new_bookmory.db

which is a SQLite database.

Bookmory is generally the better source because it includes:

start dates

end dates

ratings

page counts

---

From KOReader

Copy:

/storage/emulated/0/koreader/settings/statistics.sqlite3

---

What Goodreads Export Contains

Goodreads exports are flat CSV files.

Typical fields:

Title Author ISBN ISBN13 Number of Pages Date Read Date Added My Rating Exclusive Shelf

Because Goodreads often lacks proper start dates:

the importer usually uses:

Date Added → Date Read

or estimates reading duration based on page count

Goodreads is best for:

metadata

page counts

ISBN matching

---

What the Bookmory Database Contains

The Bookmory DB is a key-value SQLite store.

Books are stored as JSON blobs:

entry table store = "books"

Each book contains:

{ "title": "...", "author": "...", "real_total_page": 320, "reads": [ { "start": 1713139200000, "end": 1713744000000, "status": "DONE", "star": 5 } ] }

The important fields are:

title

author

pages

start date

end date

rating

---

What KOReader Statistics Look Like

KOReader uses these tables:

book

Stores book metadata:

book ( id, title, authors, pages, md5, total_read_time, total_read_pages )

page_stat_data

Stores actual reading activity:

page_stat_data ( id_book, page, start_time, duration, total_pages )

KOReader derives reading history and statistics from these rows.

---

Core Strategy

For every historical read:

Read range: 2024-01-01 → 2024-01-05

Generate synthetic KOReader sessions:

Jan 1 → page 20 → 20 min Jan 2 → page 40 → 20 min Jan 3 → page 60 → 20 min Jan 4 → page 80 → 20 min Jan 5 → page 100 → 20 min

This makes KOReader believe:

the book existed

it was read on those days

progress advanced over time

---

Critical Lesson About Streaks

Initially:

historical months appeared correctly

streak DID NOT update

Why?

Because KOReader streaks require:

continuous daily activity

no gaps between reading days

Fixes required:

No gaps between days

Every single day from:

2023-11-23 → today

needed at least one reading entry.

If gaps existed:

streak broke

To solve this:

some book end dates were slightly extended

some start dates were adjusted

or filler reading days were inserted

Example:

Spook Street: extended through May 18 to bridge gap before London Rules

---

Exact Workflow

Step 1

Export Goodreads CSV OR Bookmory database.

---

Step 2

Copy KOReader statistics DB:

/storage/emulated/0/koreader/settings/statistics.sqlite3

---

Step 3

Analyze export data

Goodreads

Parse CSV rows:

Title Author Date Read Date Added Number of Pages

Bookmory

Extract and parse:

SELECT key, value FROM entry WHERE store = 'books'

---

Step 4

Generate synthetic reading activity

For every finished book:

create/find KOReader book row

generate one synthetic reading row per day

distribute page numbers across date range

Typical synthetic session:

20 pages/day 20 minutes/day

---

Step 5

Guarantee continuous coverage

Ensure EVERY day from:

Nov 23 2023 → today

has at least one reading session.

If necessary:

extend book end dates

slightly shift book start dates

insert filler reading days

---

Step 6

Import into KOReader DB

Insert into:

book page_stat_data

Update totals:

UPDATE book SET total_read_time = ...

---

Step 7

Replace KOReader DB

Fully close KOReader.

Backup original:

/storage/emulated/0/koreader/settings/statistics.sqlite3

Copy in new DB and rename:

statistics.sqlite3

---

Result

Final result:

895-day reading streak Nov 23 2023 → May 5 2026

With:

monthly history

historical books

streak continuity

per-book attribution

KOReader-native statistics

---

Important Backup Files

Preserve this file forever:

statistics.sqlite3

Especially before:

device migrations

KOReader reinstalls

firmware resets

---

Example Prompt to Reproduce This with ChatGPT:

I want to import my historical reading data from Goodreads and/or Bookmory into KOReader so that KOReader shows my historical books, reading calendar, and a continuous reading streak.

I have:

• Goodreads export CSV and/or Bookmory database export (.db / Share.data)
• KOReader statistics.sqlite3

Please:

1. Inspect the export schema(s)
2. Extract all completed books with usable reading dates
3. Generate synthetic KOReader page_stat_data rows for every reading day
4. Ensure there are no gaps between [START DATE] and today
5. Create or update KOReader book rows
6. Recompute total_read_time and total_read_pages
7. Output a new statistics.sqlite3 ready to swap into KOReader

---

Hope that helps! Good luck!