Excel + Google Sheets
Book Tracker
Your whole library in one place: what you've read, what you're reading, and the pile you swear you'll get to. Log a book (with the dates you start and finish it) and the dashboard, the charts, the shelves and your yearly challenge calculate themselves.
Coming to Etsy this week
Instant download on Etsy: Excel files plus a link to your own Google Sheets copy.
What’s inside · 10 tabs
- Welcome: A 3-step start guide
- Reading Dashboard: Big KPI cards, donut and bar charts of your reading year
- Setup: Currency, annual reading goal, pages per hour and tracking year; plus your own genres, formats, tags and status emojis
- Dashboard: Total books, finished this year, currently reading, library value, books sold, average rating, status / source / rating / top-genre charts, books per month and your annual challenge bar, all calculated from Book Tracker
- Book Tracker: The engine. Title, author, genre, format, source, cost, pages, a 1-5 star rating and the dates you start and finish each book; status and progress fill in on their own
- Photo Gallery / 06 Gallery: Pick a title to see its data and dates, plus Owned / Borrowed / Waiting shelves that fill from Book Tracker
- Library Toolkit: Your owned books A to Z with status emojis you choose, plus a top-authors chart
- Reading Habits: A full-year grid (12 months, the real number of days in each). Tick the days you read and the streaks, the month-by-month summary, the 53-week chart and the goal donut calculate themselves
- Calendar: Any month and year. The dates lay themselves out, you mark yes/no per day, and books to return come from Book Tracker
Features
- Visual Reading Dashboard tab: big KPI cards (books finished, pages read, yearly goal, average rating, library size), donut and bar charts by genre, status, month and rating that update from your entries
- Everything customisable in Setup: genres, formats, tags, even the status emojis
- Annual reading challenge: books finished this year vs your goal, with a progress bar and an on-track / behind check
- Library value, books sold, pages read and average rating calculated as you log
- 200 book rows per tracker, ready to fill
- Filled EXAMPLE workbook + clean BLANK workbook included
- Excel AND Google Sheets versions, both in this listing
- Every formula tested before publishing
You’ll need
- Microsoft Excel 2016 or newer (desktop; Microsoft 365 not required) or a free Google account for the Google Sheets version.
- Best on desktop or laptop.
More in Lifestyle trackers
