Using Notion to track my books
May 29, 2022
Since 2015, I've maintained various projects for tracking my reading habits. The first iteration used Trello, Node.js, & Parse. The second iteration was focused on visualization improvements using Angular & d3. The third iteration moved away from a custom UI to using a 3rd party visualization tool called Metabase; the backend also changed from Node.js to Django. The fourth iteration introduced an iOS app. And now, we're finally at today, where everything—book info, basic stats, & even the notes—are all in one place... Notion.
Notion for organization
Simply put, Notion is a document organizing tool & it has really enabled me to centralize all my books information in one place. This is done by using a Notion database, which is a collection of pages with additional properties. Properties can be text, dates, as well as formulas. For example,
Days to Finish is a formula that's computed from two others properties,
Date Started &
It's also possible to create custom views. For example, here's a simple kanban board that's identical to Trello:
Yet another supported view is the gallery view. In this case, the finished books are grouped by year, similar to the iOS app:
Since each database row is a page, this is where notes for a specific book are captured:
Importing data into Notion
While Notion does provide a way to import data directly from Trello, it doesn't include all the information like activity timestamps. This information was parsed out separately & stored in a database that powered my latter projects. To get all the desired information, both from Trello & the database, a very simple Python script was created to combine the two sources of data & export them into a CSV. The CSV file was then imported into Notion.
As for the actual notes themselves... unfortunately, this was a manual job. They were originally typed up in Apple Notes; to move them into Notion was a copy & paste job. It actually wasn't too painful & was also a nice way to review the notes I had written up.
So what's next?
The previous projects will remain online (at least for the time being), but will not be maintained. This doesn't end my coding journey with books though... my focus will now shift to building other things!