Hey guys! Welcome to a new week and a totally new type of post on my blog. I don’t think I’ve ever talked about my mild excel obsession before, and I’ve certainly not highlighted it here before.
But, here today I’m talking about my excel book log for 2019 and why I’m bothering with one!
I did a book log similar to this in 2018, but learnt throughout the year what I did and didn’t like about it. Last year’s sheets were a bit more complicated and involved me blogging a lot of extra information which I often forgot to do, so I’ve developed my 2019 book log from that information and here’s what I’ve got for the year going forward!
You can find my 2019 goals post here, if you’re curious!
[ YOU CAN FIND MY 2019 EXCEL LOG HERE ]
My first sheet that I made for 2019 is my major reading goals sheet. It revolves around the individual books I plan to read this year and as I read them I’ll place a tick or a cross next to them, indicating I finished or DNF’d the book.
On this sheet, I also have two smaller goals/aims that I have for the year. They’re not major goals so I haven’t talked about them on my blog, but they are things I would like to achieve on a lower level throughout the year.
For example, I would love to read “bigger” books this year. In 2018 I primarily read books between 300 and 400 pages. I know I enjoy longer books but I rarely actually take the time to actually read them. So because, and this links to my second goal, I have long bus trips to and from school I would like to listen to a few of them on audio throughout the year.
My second sheet, is blog based! My first section is just a reminder of how many followers I’ve gained throughout the year!
My second section is just a stats log, and the third section is where I log the most popular blog post from each month just so I can get a proper feel for what you guys like to read on my blog!
My third sheet is pretty basic but it’s just you’re run of the mill list of what I read throughout the year. I try to include the month, title, author, my rating, publisher, publication year, any tags I have, and whether I have reviewed it.
I also try to include colours on the left two columns next to the month column, which I use as indicator tabs. I use pink to indicate that the book I read was a 2019 release, green to show that I read a new-to-me author, and blue to show that the book was a buddy read. Honestly, I just love seeing all the colours at the end of the month, even if I only read a few things, seeing the colours makes mefeel really happy and acomplished!
My next sheet is also pretty short and basic, but I enjoy it all the same. This sheet is something I’ll only touch at the end of the month because it’s just where I log the number of books I read each month, and of those books, how many 2019 releases I read.
My very last sheet in my book log, is just to remind me of when I’ll be participating in buddy reads. For example, I have a buddy read coming up later this month with Destiny so I’ve already put that into my log.
[ YOU CAN FIND MY 2019 EXCEL LOG HERE ]
DO YOU HAVE AN EXCEL OBSESSION LIKE ME?
DO YOU LOG YOUR BOOKS AND CHALLENGES EVERY YEAR?
HAVE HAD
allonsythornraxx 
I’ve been using Kaleena’s spreadsheet and I think it has honestly revolutionized the way that I read and blog. It has made my life soooooo much easier. Also, I love your little front page with the main book goals you have! I hadn’t thought of doing one of those, I’m sure it makes it easier to remember what ones you’ve chosen aha.
LikeLiked by 1 person
I’ve seen her spreadsheet and I’m so jealous because mine could never be that good! I’m glad you’re finding it helpful!
Yes, having that goals sheet at the start of my log really helps! It’s already helping to keep me accountable!
LikeLike
This is a great idea! I am trying to get more organised with my reading, I purchased a book diary and I use Goodreads. Good luck for 2019 🙂
LikeLiked by 1 person
Thank you, I think so too! I’ve been thinking about using a book diary, but I know that I would forget to use it, whereas, I’m usually glued to my laptop during the school year so I thought excel was a safer bet. I hope your book diary works out for you though!
Good luck to you too, for 2019! 😘
LikeLiked by 1 person
I am so in awe at your organization. Your spreadsheets look amazing!
LikeLiked by 1 person
Ahh, thank you! 😍😍
LikeLiked by 1 person
Yessssssss queen! I love me some good spreadsheets!
LikeLiked by 1 person
Right??? They’re so much fun to make!
LikeLiked by 1 person
Nice! My spreadsheet holds a list of all of the books I’ve read, and also all of the challenges I’m doing. it’s colour coded to say if the book hits that particular challenge category or not. Plus I have a code at the front to show which challenges I’m using it for if i don’t want to scroll across.
I haven’t got a list of books at the front as I’m more of a mood reader but I like the idea of blog stats like that, I normally just put the date I put the review up next to the date I completed it.
But yes – BOOK SPREADHSEETS FOR THE WIN
LikeLiked by 1 person
Thank you! I love hearing about everyone’s spreadsheets for the year!
Ooh, I love colour coding but I don’t do it as much as I would like because I find that by the end of the year my sheets get too crowded with all the different colours!
Spreadsheets 5ever! 💕
LikeLike