Gable Path
Cover image for Reading Tracker Spreadsheet with Virtual Bookshelf, Excel and Google Sheets, TBR Library Stats
Reading & books

Reading Tracker Spreadsheet with Virtual Bookshelf, Excel and Google Sheets, TBR Library Stats

Your reading year, on one shelf. Log a book in a single table — and the moment you mark it Finished, a colored spine slides onto your virtual bookshelf…

$14.99 Instant download
Get it — $14.99

Secure checkout on Etsy. Download link arrives immediately.

  • Works in Microsoft Excel and free Google Sheets
  • Formulas and layout locked — nothing to break
  • Yours to keep, for personal and business use

Your reading year, on one shelf. Log a book in a single table — and the moment you mark it Finished, a colored spine slides onto your virtual bookshelf, colored by genre with the title running up the spine. Five shelves, one hundred books, zero effort.

You only ever type in one place. The My Books tab has dropdowns for genre (12 options), format (paper / ebook / audio), status (owned-unread, reading, finished, DNF, wishlist), and rating, plus columns for series, pages, dates, and spice/notes — 400 rows, so your whole library fits.

Everything else fills itself:

  • BOOKSHELF — the showpiece. Finished books appear as genre-colored spines on shelf rows.
  • STATS — books finished this year, pages read, average rating, counts by genre and format, DNF count, and a reading-goal cell with live progress %.
  • TBR & SERIES — wishlist and owned-unread counts, one-click filter instructions, and a series tracker that tallies owned vs. read per series.

Dead simple on purpose: formulas are locked (no password) so nothing breaks, sample books show you how it works, and a PDF quickstart covers Excel and Google Sheets step by step. Works in Microsoft Excel and free Google Sheets, desktop or mobile.

Instant download: 1 xlsx + 1 PDF quickstart. Nothing ships; nothing to wait for. Happy reading.

How this was made: the spreadsheet’s formulas, layout and documentation were built with the help of AI tools, then tested by hand before release. Every formula in this file has been verified to calculate correctly.

What's included

  • quickstart.pdf — one-page quickstart, download to first entry
  • reading-tracker.xlsx — spreadsheet, opens in Excel or Google Sheets

Questions

How do I get the file?

It is an instant download. Checkout happens on Etsy, and the download link is on the confirmation page and in your emailed receipt. Nothing ships; there is nothing to wait for.

What do I need to open it?

Open it in Excel, or upload to Google Drive and choose Open with Google Sheets. No Microsoft subscription needed.

Can I change it to suit my business?

Yes. Categories, names and labels are yours to rename, and the totals follow automatically. The calculated cells are the protected ones, so you can edit freely without knocking a formula out.

Can I use this for client or business work?

Yes — use it in your own business or personal projects as much as you like. The one thing you cannot do is resell or redistribute the file itself.

What if it isn't right for me?

Refunds are handled by Etsy under their own buyer policy for digital downloads — request one through your order there and it goes through their process, not ours.

← All templates