Create a bookshelf tracker for Goodreads

Here’s a simple and effective Bookshelf Tracker for Goodreads. This is useful for keeping track of books across your shelves such as “Want to Read,” “Currently Reading,” and “Read,” along with details like rating, date read, review, and notes.

You can use this as a spreadsheet tracker (Google Sheets, Excel) or adapt it into a simple web app or Notion template.

📚 Goodreads Bookshelf Tracker

1. Columns Overview

2. Column Details

• Title: Full book title.

• Author: Book’s author(s).

• Status: One of the following: Want to Read, Currently Reading, Read, or custom like DNF (Did Not Finish).

• Date Started: Date when you started reading the book.

• Date Finished: Date when you finished reading (leave blank if still reading).

• My Rating (1–5): Personal star rating.

• Review: Brief review or summary of your thoughts.

• Genre: Fiction, Non-Fiction, Fantasy, Thriller, etc.

• Format: Physical, eBook, Audiobook.

• Notes: Anything notable (quotes, reading experience, part of a series, etc.).

🛠️ Extra Features (Optional)

A. Filter & Sort Options

• Filter by genre, rating, or status.

• Sort by finish date to track yearly reading goals.

B. Goodreads Sync Tips

If you use Goodreads:

• Export your Goodreads library from Account Settings > Export Library (CSV file).

• Import the file into Google Sheets or Excel to automatically populate the tracker.

• Keep the spreadsheet updated alongside Goodreads for personal metrics and deeper analysis.

✅ Sample Entry

🧩 Automation Tip

Use formulas or conditional formatting to:

• Highlight overdue reading goals.

• Track how many books per genre you’ve read.

• Set up progress bars for your yearly reading challenge.

Would you like this turned into a downloadable Google Sheet template or basic web app?