READING/READATHON TRACKER ✐

[@littlebookowl]

VERY IMPORTANT UPDATE: A HUGE thanks to Kristen for providing a formula that means you DON'T need to add your current page number if you haven't made any progress on a book. You can now leave those rows blank!

[@LizaEames]

Will be testing this out during Biannual Bibliothon! Will it affect anything if I delete the welcome & How to pages?? I've exported to excel as I prefer it and don't really need them now that I know how it works but don't want to delete incase it affects something in the rest of the spread

[@littlebookowl]

Not at all, you can delete those to tabs! I always remove them as well :)

[@LizaEames]

@@littlebookowl Awesome! Thanks for getting back to me 😊

[@vixxyi4180]

Since you've added the "Progress" row, you have to change the formula for the Books Started/Finished to match the 5th row rather the 4th as it used to be as it doesn't work now.

[@littlebookowl]

Thank you! I'm still working on updating things, but I had definitely missed that - all fixed :)

[@emilylacey7838]

Spreadsheets, planning and reading I think I’m in heaven

[@autumn5311]

Baby Ghoul I don't even know what to do with myself

[@Atalinay]

Wow I thought I was proud of my spreadsheet. This is so much more thorough. Good Job! I am in awe.

[@jash6922]

As a huge statistics nerd and reader, thank you!!!! This is amazing! I love doing charts and graphs of everything in my life and was working on one for reading, now you've given it to me! Thank you!

[@LetsReadSFF]

The audiobook minute to page converter is amazing. I've been looking for a solution like this and puzzled over many days how to calculate something like this. Brilliant.

[@thadremaw]

Books and data, my two favourite things! Thanks for putting all this together.

[@caseylofton4336]

Thank you for all the effort you put in to make this! It's awesome!

[@courtneyschiela4171]

I'm an accountant, so excel spreadsheets are nerd heaven for me. Thanks for providing such an amazing tool!

[@stardesteney]

This is absolutely amazing! I've never used a spreadsheet before but always wanted to (I've just always been too much of a disorganized mess to even think of it), so this one is making me really excited! Thank you so much!

[@drumsofautumn]

This is amazing, Caz!!! Absolutely cannot wait to use this during Reading Rush and honestly I feel like in general it's gonna make me more motivated to participate in readathons!!

[@dreamer7770]

You can tell a lot of love went into this. Thank you, Catriona!

[@inesslt367]

I love it. I'll be trying it for the newts next month, and I think its very helpful and easy to use. thank you Caz for all the efforts. love you

[@brandiklump6151]

Ok so this is the most AMAZING THING EVER and I will absolutely be using it for the read-a-thons I am doing in August!!!!!!!!!!! THANK YOU THANK YOU THANK YOU!

[@evaisabel977]

OMG that is super helpful! I'll be using it for Reading Rush and NEWTs - can't wait to start! Thank you so much for your effort !!!!!

[@pawsonpagesana914]

Thank you so much Caz! This tracker looks awesome!! I will use it the next time I do a readathon! Also the update number 5 is perfect, I always calculate that on my own. Won't have to now!

[@GrayBush_Knits]

LOVE this spreadsheet so much! Definitely going to do this month as well as next month for NEWTs as well! Thank you so much for sharing!

[@sherrysbookstropolis8067]

This is the best thing ever! Thank you so much Catriona 🤗🤗🤗💕💕

[@brierofbooks9385]

This looks fantastic! I think I’ll start using it for the two readathons I’m doing this month.

[@Hybrysia]

I will definitely use! You did a great yjob, you're amaizing! Thank you - greetings from Poland!

[@lovekatie3528]

This is so handy! Thanks for creating this and sharing! It definitely will be useful for the NEWTs readathon :)

[@TheLadyAli]

Thank you so much for sharing this! I'm getting ready to track a read-a-thon and this will be a huge help!

[@ddgraywrites]

THIS. IS. AMAZING. I just opened the document and omg I'm going to have the greatest time. Thank you.

[@juliaouzia619]

Fantastic spreadsheet! For the empty cell thing you are struggling with: The easiest way I can think of (without actually trying it) is that you'll need a current page counter, let's say it's in G6, I assume you could then have the following formula =G9-G$6$, the page counter would just be =sum(G7:G500)-G5... Again, I'm doing this theoretically right now as I don't have Excel available at the moment but it should work (I hope)...

[@saraisreading4231]

This is an amazing contribution to the readathon world.

[@givemeprimelaughter]

Oh my God I am sooo freaking excited to use this !!!

[@JurassicReads]

This is amazing - thank you for your hard work! I'm actually going to try using this for a monthly/daily reading tracker to help me get out of a slump. In addition, I think it will help me get on top of reading and reviewing arcs :)

[@contrapasso5456]

I can always use another spreadsheet in my life and this is exactly what I’ve been looking for. Thank you!

[@StrawberryBookReader]

JUST found this and I am so excited to use it! Thank you!!

[@reneetaylor2111]

Love this. Will be using it this for the reading rush and newts

[@starry_worlds]

I love this spreadsheet. I'm gonna use it for Newts and for the mythtakes readathon.

[@jenn.131]

To fix your first day problem when you're starting on page 50... Enter a formula in cell H7 that just says "=H5". You have that cell purple, so even though it has a formula in it, it's listed as a safe to update field... So if someone does read on day 1, it will update correctly and take into account your start page, but if you don't read on day 1, it will still take it into account. Hopefully this makes sense! You can message me if you have questions. I love Excel

[@steg8048]

*watches this video once* *adds being competent in excel to my CV*

[@dianagalloway9039]

Wonderful. Thank you for all your work.

[@thornoftheeolian8355]

This is such a great idea! Thank you so much!!!

[@denisakujanova3754]

This is perfect, so nice and a lot of work done to create it! And you explain it well in my opinion, so thank you a much for this tool :)

[@BookLionQueen]

This is so cool! I just use my bullet journal but now I think I’ll use this too!

[@aname4700]

Wow amazing work!! So much dedication!

[@alinafaye02]

Thank you so much for making this and all the hard work you've put into this, love it!! 😍😍

[@UpsideDownBooks]

This is absolutely amazing! I'm so glad you made this. I'll 100% be using it, thanks!

[@nancy7542]

Much thanks and appreciation!!!

[@beepboop9976]

When it comes to using online spreadsheets and exel I am like an OAP, but tracking on pen and paper is my one true love. I've managed to work this spreadsheet out for the bianual bibliothon, so I'll give it a go and if I like it I'll use it for other readathons :)

[@littlebookowl]

Let me know how you go! I almost always prefer using pen to paper, but I got a little tired of doing the calculations myself (HELLO LAZINESS).

[@damora626]

This is AMAZING!✨ I'm so happy and thrilled to try this, thank you so much for sharing and taking the time to explain❤❤

[@yaredi]

Today I started using it for my NEWTs. Thank you. :)

[@MeiSophie58]

Wow! This is amazing. You put a lot of work into this. ^_^ I wish I had it at the start of the year to track all of my pages.

[@littlebookowl]

Thank you!!

[@arryn1993]

This is awesome. Thank you so much for sharing it with all of us!

[@juditkovacse]

Such a spreadsheet wiz. You're awesome for doing this.

[@jessielauren333]

Your makeup looks beautiful in this video

[@rimbluebooks]

This is great. Thank you. I can't imagine how much time and energy went into this 🤘😘💙

[@melissathereadingnerd]

Great sheet! Love the work that was put into making this! But I am wondering how I can work out if I am doing a yearly challenge (like how many audiobooks I can listen to in a year).

[@FourPawsandaBook]

OMG THIS IS AMAZING!! I will definitely be downloading this for the Newts!

[@AprilSarah]

Oh my gosh... I love this!

[@princessamymaggie]

This is amazing! Thank you!!!

[@ale_reads]

Thank you so much for this! I'm going to use or for sure 🖤

[@Marteire]

omg, that's just perfect! thank you so so much!

[@BooksofAmber]

This is sooooo useful, Caz!

[@creativewithjia]

This is great. Could need something similar as I love to track things and need a book tracker.

[@BookBiteReviews]

Oh my God I can't wait to use this!

[@YoureBeautiful4Life]

Charts. Give me all the charts. Thank you for this!!!

[@manon53usher]

this is AMAZING and makes me super excited to read!! thank you so much!!

[@awkwardbooknerd8904]

this has been super helpful!! Thank you so much for doing this!!!!

[@princessslibrary4244]

Thank you so much! 💕

[@ReadingCreations]

This is brilliant!!! Yes Cazza 💪👍💕

[@truedreams17]

This is absolutely amazing! Thank you for sharing

[@missKaiZZ]

That's AMAZING, Caz!

[@PutonaChicFace]

You may have saved my life. Thank you!!!

[@mariana.c89]

Thank you so much for this!,

[@dzarif7]

Wow! 😃Thank you for this! Love your videos, so helpful! 💕

[@MirjanaProdan]

This is so amazing and helpful :D

[@rasaslase]

I need to try this. 💛

[@hardbackharvey6747]

WHY!!!!! I GET TOO EXCITED FOR SPREADSHEETS!!!!!

[@ireneg4515]

Taaaaaank you this is fantastic

[@koalasbooks2496]

Thanks so much for this! I've been using this for the past week and it pairs perfectly with Let's Reads spreadsheet. The converters are a lifesaver! One question: Is it possible to collapse columns for books already finished? I was able to do it for the blank columns but it pops up as a warning when I try to collapse columns with books completed. Just asking because as the month goes on we'll have to scroll further and further right to update books.

[@littlebookowl]

+KoalasBooks yes, absolutely! You can collapse any of the columns, that warning pops up for a few columns in case you accidentally delete or alter anything where important formulas are. Just bypass the warning 😁

[@SamanthasBooks]

This is SO helpful!! I love it! Thank you so much

[@vishalchaudhary-lv9hc]

following your channel for a long time. please make a new video on how to listen to an audiobook I have seen your old video. good work keeps up!!!!!

[@fireangel02]

I love this. I know it’s for readathons but can it be used as a way to just track books through out the year. You might have said something but I missed it

[@littlebookowl]

+fireangel02 yes, absolutely! It can be used for general reading, though depending on what you want to track I’d also recommend taking a look at the the spreadsheet I link in the description (created by Let’s Read). This tracker only tracks up to 60 books, however. I can go in and add some more I need be!

[@fireangel02]

Little Book Owl k thank you I have gotten into a reading slump I want to get out of so bad

[@littlebookowl]

@@fireangel02 YOU CAN DO IT!

[@bBooksBB]

WOAH. This is awesome. I love it so much. I'm definitely going to be using this in the future :D

[@toniweller6008]

Amazing! Thanks!!

[@bookishnatie9614]

I might actually just use this format spreed sheets for even homework tracking lmao. Thank you.

[@onomatopoeia9550]

wow,you are so creative

[@Studyinbooks]

HOOOW? Can you do a video on how you did this? It's wow

[@yaredi]

wow, amazing! thank you so much.

[@kerisbookishcorner2864]

Hi! I love this so much! Is there a way to use it from my phone? I have google sheets app but I can’t figure out when I open it how to save a copy so I can make changes like adding my books, etc.

[@kerisbookishcorner2864]

I figured it out! I had to text it to myself then it would open in google sheets and I could save a copy for myself!! Just in case anyone else runs into this issue :-) I’m so excited!!! My OCD nature loves this!!

[@littlebookowl]

@@kerisbookishcorner2864 Thanks for the heads up! I always have an issue accessing new google docs on my phone, sadly :( Glad you found a way around it, will definitely do that in future!

[@damora626]

Where do i see the location on the kindle? I've not used that feature... when i'm reading it shows me the % of the book i've read so far, is that the second option you mentioned in 13:10 ?

[@littlebookowl]

Yes, that's the second option! You can also change the setting on your kindle to show you different Reading Progress options, but I think finding this setting differs depending on what model you have.

[@BrookeClark_]

WOW!! This is awesome! This NEEDS to be an app! haha ❤️ could you put 0 in that day you didn’t read and it calculate it correctly?

[@littlebookowl]

+Brooke and Books sadly no! The formulas treat a blank cell as 0 anyway, so you still need to put the current page you’re on 😁

[@littlebookowl]

Just an update! Someone has given me the formula that fixes this problem, so you can now leave it blank if you haven't read anything that day!

[@BrookeClark_]

Little Book Owl So glad you figured it out! So excited to use it. 🙂

[@tranquilreader6649]

This is wonderful - thank you! : D

[@BrookeClark_]

Can you also add more books onto the end if you want to track say your entire years progress? ☺️ xx

[@littlebookowl]

+Brooke and Books at this stage I would need to go in and do this as I’d have to manually change some of the formulas. If you’re likely to need more let me know and I’ll go in and do so!

[@TangibleReads]

Looks intricate

[@dearD4NI]

thank you so much for the tracker! is there any way to shorten the number of books without screwing with the totals formula? i want to use this to track the reading rush and the goal is only seven lol

[@littlebookowl]

+deardani You can hide all of the excess columns/rows you won’t need 😁

[@dearD4NI]

@@littlebookowl omg and i had just done that with the audiobook columns why didn't i think of that lol thanks!

[@FemboyHasu]

Do you know what to so, if I want reading spreatsheet that will track all of my books? Not from just one year?

[@pandareads]

Thank you so much for this

[@misssomod194]

Beautiful🌸✅

[@readbymalja]

I'm not into making spreadsheets but one simply cannot ignore LittleBookOwl's video so I watched it 😊❤

[@AgnahsWorld]

That's really impressive and interesting, thank you for your work ! =D

[@hannahmartha1]

Looks great!

[@MsEnid2u]

where can I find this template? I can't seem to find it, is it still available?

[@Justluffyyy]

This looks really complicated...🤯

[@AgnahsWorld]

I have a question about the challenge section, if there is a challenge like "read 5 fantasy books", how do we do to enter the five books in the challenge if we don't read them one after another ? Like I read a fantasy book, i write it in the challenge section, but i read a sci-fi one after and it's also a challenge, how do i do to enter the next fantasy book between the first fantasy book and the sc-fi one ? Does it work if i just insert a cell down ? (i feel like my explanation is awful xD)

[@littlebookowl]

+Agnah Plays I think I get what you mean! I’ll have a think if there’s an easier way, but I’m not sure if there’s a way to calculate that in one formula. My first instinct would be to actually have five rows for that one challenge, so you can select which 5 books will work for the challenge and mark them off one by one. Does that make sense? It’s so much easier to show than explain 😅

[@AgnahsWorld]

@@littlebookowl So true xD I'll try that and see. Or the next page is a page for challenges with a number of books to read =P Thanks again for your work and your channel ! Love your videos

[@micheleann1737]

I really like your hair color

[@batkisses]

Thank you

[@JayGTheAwkwardBookworm]

I wish I had the patience and persistence to actually keep track of my reading 😂