Book Tracker & Library Catalogue Spreadsheet | 5 Themes, Auto-Linking (Digital Download)

About this product

BOOK TRACKER + HOME LIBRARY CATALOGUE IN ONE SPREADSHEET
Google Sheets & Excel · 5 colour themes · instant download · $2.22

Most book spreadsheets do one job. This one does both: a catalogue of every
book you OWN, and a log of every book you READ - and the two talk to each
other. Type a title the same way in both and the workbook links them by
itself.

Everything on the Dashboard and Report tabs is calculated. You never write a
formula.

• - - - - - - - - - - - - - - - - - - - - - - -
• WHAT YOU GET
• - - - - - - - - - - - - - - - - - - - - - - -
• 5 complete workbooks (.xlsx) - one per colour theme
• 16 tabs · 14 live charts · 8 auto-updating figures
• Quick Start Guide PDF (5 steps) + Full Guide PDF (every tab explained)
• 50 real example books pre-loaded, so nothing opens empty
• Room for 450 books read and 400 books owned
• Instant digital download - nothing ships

- - - - - - - - - - - - - - - - - - - - - - - -
THE 16 TABS
- - - - - - - - - - - - - - - - - - - - - - - -
DASHBOARD - books read, pages, average rating, goal progress, currently
reading, books owned, days per book, spent this year. Plus six charts:
books a month, genre split, rating spread, format mix, pace against your
goal, and pages a month.

REPORT - eight more charts: authors you return to, where your books come
from, reading pace, monthly spending, which genres you rate highest, a
taste radar, series gaps, and pages against days.

READING LOG - one row per book. Status colour-codes the row (finished,
reading, paused, DNF), with a progress bar and a star rating scale.

MY LIBRARY - your catalogue: ISBN, publisher, edition, condition, shelf
location, what you paid and what it is worth. Shows whether you have read
each book and who currently has it.

TBR · WISHLIST · SERIES · LENT OUT · BOOK HAUL · REVIEWS · CHALLENGES ·
SEARCH · ISBN LOOKUP · SETUP - the queue with priorities, a wishlist that
totals itself, series gap-finding, a loan tracker where overdue rows turn
red on their own, spending, your reviews and quotes, 50 reading challenge
prompts, and a search box that scans every book at once.

- - - - - - - - - - - - - - - - - - - - - - - -
THE BIT NOBODY ELSE DOES
- - - - - - - - - - - - - - - - - - - - - - - -
Typing 400 books in by hand is why library spreadsheets get abandoned.
Included free: an ISBN look-up you paste into Google Sheets once. Type an
ISBN and the title, author, publisher, page count and cover come back
automatically. Full setup steps in the guide. (Google Sheets only - Excel
has no equivalent.)

- - - - - - - - - - - - - - - - - - - - - - - -
FIVE THEMES INCLUDED
- - - - - - - - - - - - - - - - - - - - - - - -
AURORA - indigo, teal and coral
BOTANIC - forest, moss and clay
SUNSET - plum, coral and amber
MIDNIGHT - a real dark mode, not a tinted light one
BLUSH - rose, mauve and sage

- - - - - - - - - - - - - - - - - - - - - - - -
WORKS IN
- - - - - - - - - - - - - - - - - - - - - - - -
Microsoft Excel 2016 or later, including Microsoft 365.
Google Sheets - free, and syncs to your phone.
No subscription, no add-ons to buy, no account needed beyond a free Google
one if you choose Sheets.

• - - - - - - - - - - - - - - - - - - - - - - -
• NOT DATED - USE IT EVERY YEAR
• - - - - - - - - - - - - - - - - - - - - - - -
• There is a year selector on the Setup tab. Change it and every chart
• re-reads. Your old years stay in the file. No need to buy a 2027 version.

- - - - - - - - - - - - - - - - - - - - - - - -
HOW IT WORKS
- - - - - - - - - - - - - - - - - - - - - - - -
1. Buy and download instantly - one ZIP with all 7 files.
2. Open a theme, set your goal on the Setup tab.
3. Delete the demo books, add your own.
4. Watch the Dashboard fill up.

- - - - - - - - - - - - - - - - - - - - - - - -
PLEASE NOTE
- - - - - - - - - - - - - - - - - - - - - - - -
This is a DIGITAL download. No physical item is shipped. Because of that,
all sales are final and no refunds are offered - but message me if anything
does not work and I will fix it.
For personal use only. Please do not resell or redistribute the files.

Questions before you buy? Send me a message - happy to help.