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
Download your free Excel-template “book inventory list”
Here you will find the download links for the book directory
- as an Excel file (.xlsx)
- as an Excel template file (.xltx)
- NEW: as file for Apple-Numbers (.numbers)
- all files in a Zip
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..
Cheers
Philipp
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.
Thanks