Lifestyle

·

Google Sheets Book Tracker: How to Build a Reading Log That Updates Itself

Google Sheets Book Tracker: How to Build a Reading Log That Updates Itself

Google Sheets Book Tracker: How to Build a Reading Log That Updates Itself

Google Sheets book tracker: a reading log that updates itself

A notes app full of half-finished book lists isn't a reading log. If you want to remember what you read, what you thought of it and what's next, a spreadsheet is one of the best tools there is. It's free, it's private and it can turn a simple list of books into real reading stats.

Quick answer: A Google Sheets book tracker is a spreadsheet with one row per book and columns for title, author, genre, format, status, dates, pages and rating. Formulas then turn those rows into progress, yearly totals and charts. The Book Tracker does this across 14 connected tabs, including a reading dashboard, shelves, reviews, a wishlist and a TBR list, for a one-time $9.

Why track books in Google Sheets?

Reading apps are good for discovering books, but they decide what you can track. A spreadsheet lets you log exactly what matters to you: the trope you loved, where the book came from, the mood it left you in, or how many pages you read on a Sunday.

It’s also yours. Your reading history doesn’t disappear if an app changes its features, and you can open it on any device with a free Google account.

What a good book tracker should include

Most free reading logs stop at title, author and date finished. That’s a start, but these are the details that make a tracker worth keeping:

  • One row per book with title, author, genre, format and source.

  • A status column with fixed options: To be read, Reading, Finished, Wishlist and Did not finish.

  • Start and finish dates, so the sheet can count reading days for you.

  • Pages and current page, to show progress as a percentage.

  • A rating and a short review, written while the book is fresh.

  • A dashboard with your yearly goal, books finished, pages read and favorite genres.

  • A wishlist and TBR list that stay connected to the main tracker.

How to build a simple reading log in Google Sheets

  1. Create your headers. In row 1 add Title, Author, Genre, Format, Status, Start, Finish, Pages, Current page, Rating and Notes.

  2. Add dropdowns. Select the Status column, open Data > Data validation, choose Dropdown and add your statuses. Do the same for Genre and Format.

  3. Count reading days. In a new column use =IF(G2="","",G2-F2+1) to count the days between start and finish.

  4. Show progress. For books you’re reading, =IFERROR(I2/H2,"") gives a percentage. Format it as a percent.

  5. Turn ratings into stars. =REPT("★",J2) shows a 1 to 5 rating as stars.

  6. Count finished books. On a summary tab, =COUNTIF(Tracker!E:E,"Finished") gives your total.

  7. Total pages read. =SUMIF(Tracker!E:E,"Finished",Tracker!H:H) adds up pages from finished books.

That gives you a working log in under 20 minutes. Charts for genres and ratings come next, through Insert > Chart on your summary tab.

Book Tracker spreadsheet in Google Sheets shown on a laptop

Inside the Book Tracker template

If you’d rather skip the formulas, the Book Tracker is a Google Sheet with 14 tabs that fill in on their own as you add books.

Your reading life on one page

The main dashboard shows a yearly goal ring, 12 live stats, a rating chart and a reading status donut. Currently Reading shows each book you’re in the middle of with its progress, and My Shelf displays every book as a spine on a bookshelf that you can fill by year or by genre.

Track and review every book

The tracker is one row per book. You type the title once and pick genre, trope, mood, pace, format and source from dropdowns. Set a book to finished, reading, to be read, wishlist or DNF and every other tab updates. A review page shows any book’s cover, stars, summary, favorite quote, favorite moment and your full review.

Plan what’s next

A wishlist tracks books you want to buy with priority, price, release date and a buy link, plus the total cost. Coming soon covers count down to release day, and the TBR list shows pages, estimated reading hours and where each book came from.

Calendar, series and more

A reading calendar logs every session, a series tracker keeps books in reading order with an average rating, and a quotes dashboard serves a new quote of the day. There’s also gift and lending tracking, a year at a glance view and a 25-square reading bingo.

Book Tracker Google Sheets tabs for reading stats, shelves and reviews

Google Sheets book tracker vs. reading apps

  • vs. Goodreads or StoryGraph: Apps are great for discovery and community. A spreadsheet is better for private, detailed tracking with fields you choose. Many readers use both.

  • vs. a paper reading journal: Paper is lovely, but it can’t count pages, sort by rating or filter a cover gallery. The sheet does the math for you.

  • vs. a free template: Free logs are usually one tab. The Book Tracker connects 14, so a single status change updates your dashboard, shelves and stats.

What readers say

The Book Tracker is rated 5.0/5, and we’ve sold over 45,000 templates across our shop.

“I’ve been wanting a proper place to organize all my books, and this is exactly what I needed. I love how everything is connected, from my reading list to my wishlist and book reviews.”

Alina, verified buyer

Frequently asked questions

How do I make a book tracker in Google Sheets?

Create one row per book with columns for title, author, genre, format, status, dates, pages and rating. Add dropdowns with Data > Data validation, then use COUNTIF and SUMIF on a summary tab for totals.

Can I track audiobooks and ebooks?

Yes. Add a Format column. The Book Tracker supports physical books, ebooks, Kindle and audiobooks, with total pages or listening hours.

Is there a limit to how many books I can add?

Not in the Book Tracker. Add as many books as you like, and track multiple years in the same file.

Does it work on my phone?

Yes. Open it in the Google Sheets app with a free Google account. Setup is easiest on a computer.

Can I import my Goodreads history?

Goodreads lets you export your library as a CSV file, which you can paste into a sheet. You may need to match the columns to your tracker’s layout.

The bottom line

A Google Sheets book tracker gives you a private, detailed record of your reading that turns into stats you’ll actually enjoy looking at. Build a simple log with the formulas above, or start with the Book Tracker and get a dashboard, shelves, reviews and a TBR list from day one. Browse all our book and journal templates for more. New here? Enter code WELCOME20 at checkout for 20% off your first order.

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore