Book Collection List

You like to read and read often? Then you certainly (just like me) have a large stock of books and like to lose the overview. Exactly for this case I have created an Excel template, which should remedy the situation:
Enter all your books in one file in a book list!

You can note the following:

  • Book title,
  • author,
  • genre,
  • purchase date,
  • price,
  • reading status,
  • Media type (eBook, book, audio book),
  • Description or own opinion to the book.

To make capturing even easier, the Genre, Media Type and Status areas are provided with a drop-down menu. This allows you to easily select the appropriate entry.

Personally, the list is particularly important to me for the book titles that I read electronically or with my Kindle. Since I don’t hold them in my hand analogously, it’s hard for me to make a reference to them. Again and again I find myself hesitant when searching for new reading material, whether I already know the book or not. With normal books this does not or only rarely happen to me.

Screenshots of the book-collection for Excel

Booklist Excel
Your booklist overview
Master data of booklist
Define your master-data
For some cells the content can be chosen from a list

Download your free Excel-template “book inventory list”

Here you will find the download links for the book directory

This list in german.

More bookcollectionlists in the world wide web

3 thoughts on “Book Collection List”

  1. Why can I not print the Booklist with the content I have added? Do I have to save it with a different extension? Or what? Thanks for your help.

    • Hi Duke,

      normally printing is no problem and not prohibited by my tempate.
      There must be another problem maybe with the printer..


  2. can you scan barcodes (ISBN) and retrieve input directly into cells?
    I’m trying to catalogue about a thousand books on various subjects, some old, some new. Don’t want to manually input ones already able to be directly downloadable. Have enough pre-ISBN to input.


Leave a Comment