How to Catalog Books in Excel

To catalog books in Excel, open a new workbook, add a header row with the fields you want to track — title, author, ISBN, genre, status, shelf location and a rating — then press Ctrl+T to turn the range into a Table so sorting and filtering work automatically. Enter one book per row, add drop-down lists for status and genre with Data Validation, and use a COUNTIF formula on the ISBN column to catch duplicates. That's the whole system, and this guide builds it with you, cell by cell.

Excel is a perfectly reasonable place to keep a book inventory. It's free (or already on your machine), it's portable, and you own the file outright. This is the honest, complete version — including the two or three things a spreadsheet genuinely can't do, so you can decide with your eyes open.

Step 1 — Set up your columns

The single rule that makes or breaks a spreadsheet catalogue is this: one piece of information per column. If title and author share a cell, Excel can't sort by author. If genre and status live together, you can't filter to "all my unread science fiction". Give every fact its own column and everything downstream becomes easy.

Open Excel, start a blank workbook, and type these headers across row 1:

A quick formatting tip for the ISBN column: select it, open Format Cells (Ctrl+1), and set it to Text before you type anything. ISBNs are long, and if Excel treats them as numbers it will drop leading zeros and switch to scientific notation like 9.78E+12. Setting the column to Text keeps every digit exactly as printed.

Step 2 — Turn the range into an Excel Table

This is the step most people skip, and it's the one that does the most work. Click any cell in your data and press Ctrl+T (or Insert › Table). Tick "My table has headers" and confirm.

A Table gives you, for free: filter arrows on every header, alternating row colours so long lists stay readable, automatic expansion when you add a row at the bottom, and a name you can reference in formulas. From here you can sort by any column with the header drop-down — click Author › Sort A to Z and your whole catalogue reorders in one click, keeping every row intact.

Freeze the header too, so it stays visible as you scroll: put your cursor in cell A2, then View › Freeze Panes › Freeze Top Row.

Step 3 — Add drop-down lists for Status and Genre

Free-typed categories drift. One day you write "Sci-Fi", the next "science fiction", the next "SF" — and now no filter catches all three. Drop-downs fix this by letting you pick from a fixed list instead of typing. Here's how to add one to the Status column:

1. Select the Status column cells (click the column letter, or drag down the column under the header).
2. Go to the Data tab and click Data Validation.
3. Under Allow, choose List.
4. In the Source box, type your options separated by commas: Owned,Reading,Lent out,Wishlist,Sold.
5. Click OK. Every cell in that column now shows a little arrow, and you pick a value instead of typing it.

Repeat for the Genre column with your own list, for example Fiction,Non-fiction,History,Science,Cookery,Children,Poetry,Reference. If your genre list is long, it's cleaner to type the options down a spare column on a second sheet and point the Source box at that range — then you edit the list in one place. Consistent categories are what make the filtering in the next step actually reliable.

Step 4 — Sort and filter to find anything

With a Table and clean drop-downs in place, finding books becomes instant. Click the filter arrow on any header to narrow the list:

• Everything you've lent out: filter Status to "Lent out". Now you have a live list of who has what.
• Your unread pile: filter Status to "Owned" and sort Date added newest-first.
• All the cookery books on the kitchen shelf: filter Genre to "Cookery" and Shelf to "Kitchen".
• An author's complete run: filter Author to one name, or just sort the column A–Z.

To find a single title fast, Ctrl+F still works across the whole sheet. And because filters stack, you can combine several at once — genre and status and shelf — to answer oddly specific questions like "which unread history books are in the study?" in a couple of clicks.

Step 5 — Catch duplicate books with a formula

Buying a book you already own is the classic home-library mistake, and a spreadsheet can guard against it — as long as you record the ISBN. Add a helper column called Dup? and, assuming your ISBNs are in column C starting at row 2, put this formula in the first data row:

=IF(COUNTIF($C$2:$C$1000,C2)>1,"Duplicate","")

Copy it down the column (in a Table, it fills automatically). COUNTIF counts how many times the current ISBN appears in the whole range; if that's more than one, the row is flagged "Duplicate". Adjust $C$1000 to comfortably exceed your number of books. The dollar signs lock the range so it doesn't shift as the formula copies down.

Prefer colour to a column? Select the ISBN column, then Home › Conditional Formatting › Highlight Cells Rules › Duplicate Values, and every repeated ISBN gets shaded. Either way, the catch is the same: the check only works on books you've entered an ISBN for, so pre-barcode and some self-published titles slip through. We cover the wider problem in our guide to how to avoid buying duplicate books.

Step 6 — A worked example row

Here's what a few filled-in rows look like, so you can copy the shape. These are illustrative entries, not real data:

If you'd rather not build the headers and formatting from scratch, we publish a ready-made free home library spreadsheet template you can copy and start filling in. Prefer to work in the cloud? The same approach works in Sheets — see how to create a book inventory in Google Sheets.

Tips to keep your Excel catalogue usable

• Enter the ISBN every time. It's the field that powers the duplicate check and uniquely identifies each edition. Skip it and half the value of the sheet goes with it.
• Author as "Last, First". Sorting on a "First Last" column groups by first name, which is rarely what you want.
• Work shelf by shelf. Catalogue one physical shelf at a time, left to right, and set the Shelf value before you start it so every book on it inherits the location.
• Add a Date added column and never delete rows. Change Status to "Sold" rather than deleting — you keep a full history of what passed through your hands.
• Back it up. A spreadsheet is a single file. Keep it in a synced folder so a dead laptop doesn't take your catalogue with it.

Where a spreadsheet stops — the honest limits

Everything above works, and for a small, stable collection a well-built Excel sheet is genuinely enough. But it's worth being clear about what a spreadsheet can't do, because these are the reasons people eventually move off one:

The honest summary: the slow, manual part of a spreadsheet catalogue is entering the books, and the frustrating part is keeping it alive. You do the data-entry once, then do it again every time a book arrives or leaves. None of that is Excel's fault — a spreadsheet is a grid, not a book database. It just isn't built for the specific job of a living library.

The faster, connected alternative — and you keep your spreadsheet

This is where a purpose-built tool changes the maths. PageSwipe turns your physical bookshelf into a connected digital library, and its RapidScan feature does continuous ISBN-barcode scanning: you point your phone at each spine, it reads the barcode and fills in the title, author and cover automatically, and your searchable library builds itself as you move down the shelf. There's no typing. As an illustrative example, a shelf of about 127 books can come together in roughly eight minutes of continuous scanning — the pace that makes cataloguing a whole home realistic rather than a someday project.

PageSwipe is a free platform for readers and authors: scanning, cataloguing, sharing, lending, clubs, collections, discovery, book pages, and launch clubs are not gated. PageSwipe earns revenue through book-native advertising with authors and publishing houses at scale.

And you don't throw away the work you've already done. If you've built an Excel catalogue, you can import your spreadsheet into PageSwipe and carry every book across — then keep it current by scanning new arrivals instead of retyping them. Build the sheet today if you like spreadsheets; move it into a scanning app the day the upkeep stops being fun. For a fuller side-by-side, see the spreadsheet import page.

Tired of typing every row? Scan your first book with RapidScan and watch a shelf turn into a searchable library — then bring your Excel file along so nothing is lost.

Frequently asked questions

How do I catalog books in Excel?

Create a new workbook, add a header row with the columns you want to track (title, author, ISBN, genre, status, shelf location and rating), then convert the range to an Excel Table with Ctrl+T so sorting and filtering work automatically. Enter one book per row. Use Data Validation to turn status and genre into drop-down lists, and a COUNTIF formula on the ISBN column to flag duplicates. You then type or paste each book's details in by hand.

What columns should a book catalog spreadsheet have?

At a minimum: Title, Author, and ISBN. Add Genre and Status (owned, reading, lent out) so you can filter, Shelf or Room location so you can find the physical copy, and optionally Format, Rating, Date added, and — for insurance or collectors — Purchase price and Condition. Keep each piece of information in its own column so Excel can sort and filter it.

How do I check for duplicate books in Excel?

Add a helper column and use =IF(COUNTIF($C$2:$C$1000,C2)>1,"Duplicate","") against your ISBN column, adjusting the range to your data. Any row where the same ISBN already appears is flagged "Duplicate". You can also use Conditional Formatting (Highlight Cells Rules, Duplicate Values) on the ISBN column to colour repeats. This only works if you enter the ISBN for every book.

Is Excel a good way to catalog a large book collection?

Excel is workable and free, and it's a genuinely good fit if you like columns and want to own a portable file. Its weakness is speed and upkeep: you type every field by hand, there are no cover images, and it can't scan a barcode, share a library, or track a book you've lent out. For a large collection, a barcode-scan app is far faster to build and easier to keep current — and you can import your Excel file into one later.

Start with the sheet, or skip the typing. Build your Excel catalogue with the steps above — or scan your first book with RapidScan and import your spreadsheet when you're ready. Learn more at pageswipe.tech.