I don’t know about you, but I love doing stats for my reading year! It’s so fun to be able to tell that you have read 50% of Fantasy, 35% of Science fiction, and maybe 15% of Contemporary. With this Excel spreadsheet, you will be able to know if you have read more female authors or male authors, the format of your books, the number of pages per day, etc.
First, you have to download the Excel spreadsheet : download here
When you open the file, it looks like that:
The first part is the reading statistics that YOU have to fill out!
#: it’s just the number of books (you don’t need to do anything except if you read more than 100 books per year)
Month: you have to put the month when you read a book (January, February, March, April, May, June, July, August, September, October, November, or December)
Title: it’s just the title of the book
Number in the series: it’s the number of the book in the series (example: Skyward is the first book of the Skyward quartet, so you put 1). If it’s standalone, you can put 0.
Total in the series: it’s the number of books in the series (example: Skyward is a quartet, so you put 4)
Author: the name of the author
Female/Male/Both: it’s just for statistics at the end of the year for knowing if you read more female books or male ones. Both are for the case where a male and a female write a book together (example: Illuminae by Jay Kristoff and Amie Kaufman)
Pages: it’s the number of pages in the book
Age: it’s the age group of the book (Middle Grade, Young Adult or Adult)
Genre: it’s the genre of the book (Classic, Contemporary, Fantasy, Fiction, Graphic Novel, Comic, Manga, Historical Fiction, History, Biography, Horror, Humour, Nonfiction, Poetry, Romance, Science, Technology, Science fiction, Thriller, or Mystery)
Language: it’s the language of the book (VO or VF). If you read only in English, you just have to put VO or just delete this column and the graphic
Publisher: it’s the publisher of the book
Format: it’s the format of the book (Book, Audiobook, or E-book)
Own/Library: it’s for knowing if it’s your book or not
DNF: you can put DNF when you didn’t finish the book
Grade: it’s the grade that you give to the book out of 5 stars
For the Graphics part, you don’t have to do anything except if you want to change the colors
The third and fourth parts are optional
The best books of the year part is useful if you want to have your favorite in one place. But you can filter the grade by 5 stars and it will also give you your best reads of 2021. It’s up to you! If you want to use it, you just have to fill out the title of the book, the name of the author and the genre.
Finally, the current series and finished ones is a bit like a tracker! You can put all you current series and see during the year if you finished some or abandoned them.
Hope it was helpful and that you will use it! If you have a question, you can leave a comment below!