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!
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.