NylaLand

Book Tracker Google Sheets 2027: Multi-Year Reading Tracker Spreadsheet with Covers, Dashboard and Themes

Digital book tracker spreadsheet in Google Sheets, Dark Academia dark mode, with a library of book covers and a book card
1 / 12

Type a book title and the rest fills in: author, pages, year, genre, series and cover. No ISBN needed. This digital book tracker is a Google Sheets spreadsheet that turns your reading log into a bookshelf of covers, a dashboard that updates itself and a year in review you'll want to share.

What makes it different

  • Just type the title. Other trackers need an ISBN. Here the author, pages, year, genre, series and cover fill in by themselves.
  • A real bookshelf. Your covers stand on wooden shelves with little reading treasures between them: a candle, a globe, an hourglass. Page through your shelves with Back and More like a carousel, filter by genre, format or stars, search by title, author, series or trope, and tick any cover to open its book card.
  • Yours from the first page. Add your name once and every page carries it: "Emma's reading", "Emma's 2026 in books".
  • Light and dark modes. Four themes, Cozy Cottage and Light Academia in light, Dark Academia and Rainy Night in dark. Every tab changes with one pick.

What's inside

  • Book log: every book you've read, are reading, want to read or didn't finish, with dates, the page you're on, quarter-star ratings, spice, tropes and your review. Pick several genres, formats and tropes per book. Reading the paperback along with the audiobook? Choose both, and log the audiobook's length and the hours you spent reading.
  • Automated dashboard: books, pages, hours, average rating and your reading goal; a recently finished carousel; what you're reading now with your page progress; a quote of the day from your favourites; top rated, top genres and tropes, formats, money spent and your wishlist total; reading status and star rating charts.
  • Movie and TV tracker: rate the movie or series too, say whether the book or the screen version was better, and keep a list of adaptations still to watch.
  • Reading calendar: the cover of every book on the day you finished it, the days you started, and your goal for the month.
  • Reading days and streaks: tick each day you read and watch your streak grow.
  • Reading challenge: a 25-square reading bingo card. The cover of the book that fills each square shows on the card, and your bingos count themselves.
  • Series tracker: reading order, how far you are, your stars and the next book to read.
  • TBR wishlist: the books you want next, most wanted first, with prices, the total and a countdown to release dates. Share it as your Christmas or birthday wish list so nobody has to guess.
  • Favourite quotes: the lines you loved, with the page.
  • Year in review: your top five, month by month, and records like your longest book and fastest read.
  • Book list: pick a list (favourites, 5 stars, finished, to read, wishlist, did not finish or all books) for any year and print it or send it as a PDF. Recommend your favourites to a friend, suggest picks for your book club, or take your to-read list to the library or bookshop.
  • Save as PDF: print book cards, your calendar, challenge, dashboard and year in review on US Letter or A4. Take them to your book club discussion, or share them online.
  • Loans: see who has your books, and who you borrowed from.
  • Goodreads and StoryGraph import: bring your books over in one paste.
  • Export: all your books in one table, ready to download as a backup or use anywhere else.

Easy to live with

  • Truly automated: your status, shelves, dashboard, calendar and lists update themselves. Nothing to copy down or fill in twice.
  • Add, sort, filter or paste books and the colours and dropdowns stay in place.
  • Starts blank, with no sample books to delete. A filled-in sample comes with it, so you can try every tab before you start your own.
  • Room for 2,000 books from the start, and no limit after that: it adds more rows by itself as your library grows.
  • Multi-year: 2026, 2027 and every year after live in one tracker, with no new file each January. It opens on the current year; pick an earlier year or All years on the Dashboard, and set a goal for each year. Reading Days keeps a tab for each year.
  • A Start Here tab walks you through setup in plain English.

New versions

Your link always makes a copy of the latest version of the book tracker. To move up, export your books from your current copy and paste them into the new copy's Import tab: your books, dates, ratings, reviews and quotes all carry over.

How you get it

A PDF with two links. The first makes your own copy of the tracker in your Google Drive; the second makes a copy of the filled-in sample to explore first. It works best on a computer.

Questions

Do I need a new tracker every year?
No. Keep logging in the same copy: every year stays in it, and you pick the year to look at on the Dashboard.

Does it track ebooks and audiobooks?
Yes. Pick one or more formats for each book, and log an audiobook's length and the hours you spent reading.

Does it work in Excel?
No, it's made for Google Sheets, free with any Google account. That's what lets it look up covers and book details for you.

How many books can it hold?
Room for 2,000 from the start, and it adds more rows by itself after that.

Can I bring my books from Goodreads or StoryGraph?
Yes. Export your library there and paste it into the Import tab.

Good to know

  • Works in Google Sheets only, not Excel or Numbers. You need a free Google account.
  • Book details come from Open Library. If a detail is off, type over it.
  • The first time you add a book, Google asks you to allow the book lookup.
  • For personal use. Digital product: nothing is shipped.

Instant Download

$14.39$17.9920% off

Pro Lifetime member? Sign in to download

No reviews yet — be the first!

You may also like

2027 Desk Calendar Printable: Floral Watercolor Calendar, 5x7 and 4x6

2027 Desk Calendar Printable: Floral Watercolor Calendar, 5x7 and 4x6

A printable 2027 desk calendar with soft watercolor meadows and a birth flower each month. 5x7 and 4x6 cards, Sunday or Monday start.

$2.79$3.4920% off

View Collection & Details→
Christmas Wish List Printable: 5 Templates for Family, Kids, Teens, Teachers & Secret Santa

Christmas Wish List Printable: 5 Templates for Family, Kids, Teens, Teachers & Secret Santa

Printable Christmas wish lists for kids, teens, family, teacher favorites and Secret Santa. Print at home in US Letter or A4. Instant PDF download.

$3.19$3.9920% off

View Collection & Details→
Free Minimal 2028 Calendar Printable: Plain White Monthly Pages🔓 Free

Free Minimal 2028 Calendar Printable: Plain White Monthly Pages

A free minimal 2028 printable calendar in plain white: year at a glance and 12 landscape monthly pages, Sunday or Monday start, 4 paper sizes.

Free

View Collection & Details→
Free Minimal 2027 Calendar Printable: Plain White Monthly Pages🔓 Free

Free Minimal 2027 Calendar Printable: Plain White Monthly Pages

A free minimal 2027 printable calendar in plain white: year at a glance and 12 landscape monthly pages, Sunday or Monday start, 4 paper sizes.

Free

View Collection & Details→
Free Minimal 2026 Calendar Printable: Plain White Monthly Pages🔓 Free

Free Minimal 2026 Calendar Printable: Plain White Monthly Pages

A free minimal 2026 printable calendar in plain white: year at a glance and 12 landscape monthly pages, Sunday or Monday start, 4 paper sizes.

Free

View Collection & Details→
Free Savings Goal Tracker Printable for Kids: Colour In as You Save🔓 Free

Free Savings Goal Tracker Printable for Kids: Colour In as You Save

A free printable savings goal tracker for kids: 50 numbered boxes to colour in as they save, plus room for the goal and why. 6 colours, 4 sizes.

Free

View Collection & Details→