Skip to content
Library Book Inventory cover: a sample sheet with titles, copies owned and out on loan and a column chart, beside the Dashboard, Catalogue and Shelf check tabs

Library Book Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Small libraries, classroom reading corners and community book exchanges use this sheet to keep a catalogue of titles. The Catalogue tab lists each book with its ISBN, author, genre, shelf, number of copies and copies on loan, and calculates the copies available and a status for each title. The Dashboard totals copies, shows the genre split and flags titles with no free copy. The Shelf check tab is a grid of checkboxes for regular counts.

Change the On loan figure at the same moment the loan desk records a checkout or return, so the available count stays true. Run a shelf check once a month: tick a shelf only after you have counted every copy on it, then compare the column total with the Copies figure on the Dashboard. A gap usually means a misfiled copy or an unrecorded loss, so search the neighbouring shelves first.

Useful for

  • Cataloguing a classroom or home library
  • Finding titles with no free copies on a busy week
  • Counting each shelf once a month

What's included

  • 4 tabs: Dashboard, Catalogue, Shelf check, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Catalogue: a table
  • Shelf check: a grid
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Catalogue tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I record a lost or damaged book?

Reduce the Copies figure by one on the Catalogue tab once the copy has been written off. If that copy is still on loan, reduce the On loan figure as well. Keep the reason in a separate list, since the sheet holds only the counts.

Where do I find a book's ISBN?

The ISBN is printed on the back cover near the barcode and again on the copyright page. Use one style for every title, with or without hyphens, so that searching and sorting the catalogue finds each title reliably.

Can I sort the catalogue by author or genre?

Yes. Select the table on the Catalogue tab and sort it from the Data menu. The formulas survive a sort, because Available and Status are calculated within the same row. The genre breakdown on the Dashboard is not affected by sort order.

  • #inventory
  • #book-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…