Oh wow this is incredible - the amount of work that you've put in here is phenomenal!! I've only recently found your channel I'm gutted I've found this spreadsheet this close to the end of the year - I'll definitely be trying it for 2023 if you release another one!
Thank you so much Ali! I've been using your spreadsheets for three years now and I mainly use them to track my book spending but this year I'll definitely be using that Habit Tracker!!
Thank you!! Think I’m going to give this a go for the first few months and see if I like it. I’ve never used a spread sheet tracker for my books before.
Thank you so much for all your hard work! I've managed to tweak last years sheet fairly successfully but I could not for the life of me figure out how to fix the habit tracker calendar. Your Sheets skills are amazing!
I did add a column to the Releases tab to reflect pre-order price; I need to curtail my book buying, and sometimes I fool myself into thinking that pre-orders don't count.
I love this! May be better than the other one I've been using (won't say which). I do have a question. (oop, I feel bad.) I did read the "adding columns and rows" bit of the instructions but can't seem to apply it correctly. Under the reading habits tab I'd like to add a type of reading. Because I personally like to track digital versus physical books, and then audiobooks. So I'd need another row. Is this possible?
the reading habits tracker tab is probably the only tab you can't really add anything to given how many formulas are on it :( adding or removing any rows or columns will mess up the formulas for everything after. There is an empty area after the average daily stats that you can unmerge and put in information there, but you'd probably have to manually add everything there
Thank you! I used the one you made a few years ago but I haven't been in the mood in the last couple years I guess. I love the habit tracker, so much easier for me than getting a journal.
First off - thank you so much for making this! It's so incredibly helpful and I love the formatting you've put in. I've been enjoying adjusting it to fit my own personal needs. I did come across a small mistake in one of the charts on the yearly stats page while making adjustments, which I thought I'd pass along so others could be aware/you could edit if you're so inclined. The "Books Read From" chart has the "use row 48 as headers" option checked - which means that whatever book source you have listed in row 48 will not show up in the chart (i.e. any books from Audible won't appear). It's an easy fix, just un-tick that option! (but also super easy to miss)
Thank you so much for the time and effort you put into making this! It helped me so much this past year to be able to track all these things; especially how much I was spending on books. XD
You're right, why would I keep reading a series if all the books were 3 stars for me. Thank you! And im on book 5 of zodiac academy. I know it's not for everyone. If you didnt care for the first two, then dont push yourself, you'll just regret it.
thank you so much! TT__TT you're spoiling us I wasn't planing on using the habit tracker but after hearing how much effort went into it, I'll try to use it
Wow!! Thank you so so much for doing this again! I used your spreadsheet religiously last year! I love the new additions like the sub genre!!! My pie chart was like all fantasy. haha. But I'm sooo excited about the new free form tracking! That's freaking amazing! Oh wow the Habit tracker is really cool. I will use it!
Holy cow! This was a lot of look that you put in to making this! I’ve been wanting a way to track my unread books that I haul in one place and not in my book journal as it’s analog and as I buy books it’s all over the journal. Thank you for this!
I decided to try and track my reading for the first freaking time ever, goodreads doesn't count :D and you scared me. But I'd like to thank you for all of the work you've put into this spreadsheet ♥ I knew where to get for the good stuff!!
thank you so much! i was literally trying to edit last years to fit everything I wanted to track and was in tears, but you hit every. single. thing. thanks for everything you do for the community!
I just made my own spreadsheet and it's not as lavish as yours but I did do a simple one and I love what I created but I also love how much love and care you put into yours though 😍
Oh yay!!! I was worried you weren’t coming out with one! And you’ve added some things that I was going to figure out how to had myself. Thank you so much for your blood, sweat, and tears
Thank you SO MUCH!!!! I really, really appreciate the incredible amount of work and detail you put into this every year. Tip sent, and thank you again!
Thank you so much for making this spreadsheet. I am so glad I went digging for your spreadsheet this year because I LOVED using it last year. I am so excited to try out the changes you made this year and that you added something that I was (silently) wishing for like the author status!
Never do anything you love for free, girl! This spreadsheet should be only available by purchasing it from you! Completely invaluable for any reader who loves to track their reading progress!
THANK YOU for this amazing spreadsheet! I used your one for 2020 and it worked great, and I'm so excited for all of the improvements you've made. Sent a little tip to show my appreciation for all the hard work that went into this, and thanks for sharing!
No one has ever pointed this out omg 😅 you could always manually put 1 since the formula doesn't recognize anything less than a 24 hour period as a day... I'll have to look!
@@hardbackhoarder Thanks! I thought of doing that but I wasn’t sure if that would mess anything up. Have you ever thought about adding a section for blended/hybrid reading. A lot of the time I’m reading both the ebook and switching to the audiobook. Since I have a Kindle my place gets synced between the ebook and the Audible book. Update: I figured I could just add blend to the format choices and it worked because I read the instructions! I also was able to add it to the Yearly Stats!
The real question is... if you own a book, but borrow the audiobook from the library of that book (which I do A LOT), do you put it under library books, or owned books, or both?
Not sure if its intentional but i was waiting and this video doesn't show up on your yt like normal. I only found it through Twitter. Either way, thank you!
It was intentional. I had too many random people messaging me for "special requests" and not following directions last year. I mentioned it on twitter and in a recent video so only actual viewers would find it.
Hi Ali! Thanks so much for making this! I was curious in the “genres read” section for yearly stats, I put in that I read a classic and it’s not showing up? I put in anthology to see if that would show up and the chart didn’t change, so maybe it’s the whole first row. Also, when I put it as another type of graph, classics showed up on the graph. Thanks for any help!
Forgive me if this is in the video, I'm comfortable with excel so I didn't feel the need to watch all of this, but out of curiosity did you consider adding a sexuality tab for authors as you did for race?
I didn't mention in the video but I addressed it at the end of the directions page that I don't personally feel any author has to be out or open with their sexuality and that sexuality can be fluid making it harder to track but anyone is welcome to add it for their own tracking!
Up to you! I believe you can actually change the format to time format from the top menu. I tend to round to quarters myself (15 mins - .25, 30- .5, 45- .75) because I personally don't care for it to be precise.
This is the most beautiful thing I’ve ever seen
Thanks so much!
always wanted one tthank u.
I love you for this. This is so exciting lol
Thanks so much for this! I came from Cindy's video, so glad you made this available for everyone to use.
Thank you so much for doing this!! It’s my favorite book tracker 😃
Honestly thank you for your service 👏🏼
Thank you for the time and effort Ali xx
Thank you so much for creating this for all of us!!!!! ❤❤
This is incredible!!!! I am over the moon and so excited. ✨🌙💫
Oh wow this is incredible - the amount of work that you've put in here is phenomenal!! I've only recently found your channel I'm gutted I've found this spreadsheet this close to the end of the year - I'll definitely be trying it for 2023 if you release another one!
this is AMAZING! I will be using the habit tracker for sure! You said you hoped at least one person uses it and I will!!! :) Thank you!
Thank you so much for this!
Thank you so much Ali! I've been using your spreadsheets for three years now and I mainly use them to track my book spending but this year I'll definitely be using that Habit Tracker!!
You killed this!! Thank you Ali
Ahhhhh thank you so much for making and sharing this 💗💕🔥
This was in a discord I'm part of, and HOLY MOLY it's impressive! Thank you SO MUCH!
You ROCK!!! I loved your spreadsheet last year but you made some changes I am so excited about. Thank you for taking the time to make this video!!
“Read the f*cking instructions!” I love it!
Thank you!! Think I’m going to give this a go for the first few months and see if I like it. I’ve never used a spread sheet tracker for my books before.
Thank you so much for all your hard work! I've managed to tweak last years sheet fairly successfully but I could not for the life of me figure out how to fix the habit tracker calendar. Your Sheets skills are amazing!
This is so useful! Thank you! 🥰
Thank you so much for this Ali will deff be using! This is awesome to track end of year stats for TH-cam, I am terrible at it 😩
I did add a column to the Releases tab to reflect pre-order price; I need to curtail my book buying, and sometimes I fool myself into thinking that pre-orders don't count.
Thank you so much.
this sheet is great! i especially like the companion novel option:) im using this no instead of the cawpile sheet to track my books
Ali the EFFORT that has went into this?! It's amazing!!
This is absolutely INCREDIBLE *chefs kiss*
Thank You so much!! This spreadsheet is so amazing!!! 🎉🎉🎉
Thank you so much!!!!
IT'S FULL OF STARS. I ... can't.... my heart has grown three sizes today.
So excited! I loved using your spreadsheet last year.
I love this! May be better than the other one I've been using (won't say which). I do have a question. (oop, I feel bad.) I did read the "adding columns and rows" bit of the instructions but can't seem to apply it correctly. Under the reading habits tab I'd like to add a type of reading. Because I personally like to track digital versus physical books, and then audiobooks. So I'd need another row. Is this possible?
the reading habits tracker tab is probably the only tab you can't really add anything to given how many formulas are on it :( adding or removing any rows or columns will mess up the formulas for everything after. There is an empty area after the average daily stats that you can unmerge and put in information there, but you'd probably have to manually add everything there
@@hardbackhoarder asrrgg. Thanks! Haha
I'm in awe. Why are you such a badass? You're the best.
Thank you! I used the one you made a few years ago but I haven't been in the mood in the last couple years I guess. I love the habit tracker, so much easier for me than getting a journal.
Yesss I was waiting for this! Thanks so much 😍
Thank you for making this! I loved filling it out in 2021 and can't wait to do the same in 2022 :D
“Read the fuckin instructions”😂😂
I'm pretty sure you are my spirit animal! I tell soo many people to read the directions and THEY NEVER DO
Thank you so so much for the work you put into this ridiculously helpful resource!
Thank you so so much!!! I'm already filling up my spreadsheet and loving it ❤️❤️
First off - thank you so much for making this! It's so incredibly helpful and I love the formatting you've put in. I've been enjoying adjusting it to fit my own personal needs.
I did come across a small mistake in one of the charts on the yearly stats page while making adjustments, which I thought I'd pass along so others could be aware/you could edit if you're so inclined.
The "Books Read From" chart has the "use row 48 as headers" option checked - which means that whatever book source you have listed in row 48 will not show up in the chart (i.e. any books from Audible won't appear). It's an easy fix, just un-tick that option! (but also super easy to miss)
im so excited to use this throughout the year! thank you!!
Thank you so much! This is amazing 🙀❤️📚
Interesting, already have my own sheets but I'll definitely try these out as well
Thank you so much for the time and effort you put into making this! It helped me so much this past year to be able to track all these things; especially how much I was spending on books. XD
Thank you so so much for the time you put into making this every year!
Thank you for taking the time to create this spreadsheet every year!
A reading goal percentage bar?? Excuse me you really went off
Over here on my regular account, not my booktube one lol. Was too excited to watch and THANK YOU SO MUCH. You're the best
THANK YOU! Really loved the 2020 spreadsheet. You're awesome 😁
Thank you for all your hard work and the changes look great!
Thank you for your hard work :D I appreciate it :D
You're right, why would I keep reading a series if all the books were 3 stars for me. Thank you!
And im on book 5 of zodiac academy. I know it's not for everyone. If you didnt care for the first two, then dont push yourself, you'll just regret it.
Damn! The amount of time and effort you must have put in this is amazing! Thank you so much
thank you so much! TT__TT you're spoiling us
I wasn't planing on using the habit tracker but after hearing how much effort went into it, I'll try to use it
ahhhh, that's where I found that spread sheet!! I couldn't remember who was the original creator 😂all the graphs, so satisfying ✨
I read the instructions, yay for me! Thanks for making this spreadsheet, I needed it to much.
Thank you so much for doing this!! I am not patient enough to make one of these myself.
Wow!! Thank you so so much for doing this again! I used your spreadsheet religiously last year! I love the new additions like the sub genre!!! My pie chart was like all fantasy. haha. But I'm sooo excited about the new free form tracking! That's freaking amazing! Oh wow the Habit tracker is really cool. I will use it!
Thank you so much for doing this again this year. We all appreciate it so much. It is my favorite way to track my reading. 🖤
Holy cow! This was a lot of look that you put in to making this! I’ve been wanting a way to track my unread books that I haul in one place and not in my book journal as it’s analog and as I buy books it’s all over the journal. Thank you for this!
This is the most amazing spreadsheet ever 💫💫💫
I decided to try and track my reading for the first freaking time ever, goodreads doesn't count :D and you scared me.
But I'd like to thank you for all of the work you've put into this spreadsheet ♥ I knew where to get for the good stuff!!
Thanks for all the work that you put into this, I'm definitely looking forward to tracking a lot more aspects of my reading in 2022!
amazing! thank you :)
I must say: you are a Queen! Thank youuuu🧡
thank you so much! i was literally trying to edit last years to fit everything I wanted to track and was in tears, but you hit every. single. thing. thanks for everything you do for the community!
I just made my own spreadsheet and it's not as lavish as yours but I did do a simple one and I love what I created but I also love how much love and care you put into yours though 😍
You are an absolute gem, don't know how I'd keep track of everything if you didn't take the time to do this for us! Thank you so much!
Thank you so so much for putting this together!
Oh yay!!! I was worried you weren’t coming out with one! And you’ve added some things that I was going to figure out how to had myself. Thank you so much for your blood, sweat, and tears
I love this! I can't wait to have ALL the stats for 2022. I'm so excited. Thank you for making the ultimate reader spreadsheet!
Thank you SO MUCH!!!! I really, really appreciate the incredible amount of work and detail you put into this every year. Tip sent, and thank you again!
Ali, I just have to say your instructions on the spreadsheets are always super detailed and helpful. Thank you for sharing these every year.
Thank you so much for making this spreadsheet. I am so glad I went digging for your spreadsheet this year because I LOVED using it last year. I am so excited to try out the changes you made this year and that you added something that I was (silently) wishing for like the author status!
This looks absolutely amazing, can't wait to start using it! Thank you so much for all the hard work you put into this!
This is amazing. Thank you so so so much! What a huge accomplishment in making this and you are goddess for letting this be available for free!
The habit tracker is my favorite addition!! This is amazing as always. Your hard work does not go unnoticed . 🖤
Never do anything you love for free, girl! This spreadsheet should be only available by purchasing it from you! Completely invaluable for any reader who loves to track their reading progress!
Thank you so much! This gives me so much more freedom to track my reading and see my trends. 🧡🧡
Thank you SO much!! Your 2020 was one of my favorite things of the year, and I've been so excited for 2021! You truly are the best
THANK YOU for this amazing spreadsheet! I used your one for 2020 and it worked great, and I'm so excited for all of the improvements you've made. Sent a little tip to show my appreciation for all the hard work that went into this, and thanks for sharing!
thank you so much for doing all this work! i'm so excited to get started on the 2021 spreadsheet!
Thank you for doing this! That nasty habit tracker looks very interesting, I'll definitely use it! :)
thank you so much ali for all this hard work! this popped off so hard, forever grateful ❤️
How do you deal with books you read in a day? So I read and finished the a comic on Jan 1. Days to Read remains blank. This sis super cool. Thank you!
No one has ever pointed this out omg 😅 you could always manually put 1 since the formula doesn't recognize anything less than a 24 hour period as a day... I'll have to look!
@@hardbackhoarder Thanks! I thought of doing that but I wasn’t sure if that would mess anything up. Have you ever thought about adding a section for blended/hybrid reading. A lot of the time I’m reading both the ebook and switching to the audiobook. Since I have a Kindle my place gets synced between the ebook and the Audible book.
Update: I figured I could just add blend to the format choices and it worked because I read the instructions! I also was able to add it to the Yearly Stats!
@@JBaby_9783 I have that to add on next years ;) thank you!!!
@@hardbackhoarder Awesome! Thanks!!!!
The real question is... if you own a book, but borrow the audiobook from the library of that book (which I do A LOT), do you put it under library books, or owned books, or both?
Up to you. Or create a new label for it. I use Owned personally
Not sure if its intentional but i was waiting and this video doesn't show up on your yt like normal. I only found it through Twitter.
Either way, thank you!
It was intentional. I had too many random people messaging me for "special requests" and not following directions last year. I mentioned it on twitter and in a recent video so only actual viewers would find it.
This looks amazing, I can´t imagine all the hours you put into it. Thanks for sharing! ❤️
💚🖤
Will there be a spreadsheet for 2022?
Nope, just this! Not sure what else could even be added at this point 😅
@@hardbackhoarder I just wanted to make sure that it wasn't set for just 2021 like for a challenge or anything. Thank you for replying :)
Hi Ali! Thanks so much for making this! I was curious in the “genres read” section for yearly stats, I put in that I read a classic and it’s not showing up? I put in anthology to see if that would show up and the chart didn’t change, so maybe it’s the whole first row. Also, when I put it as another type of graph, classics showed up on the graph. Thanks for any help!
haha idk why but in the beginning she sounded like all of my teachers when online school was starting 😅
Holy shit this is amazing. Seriously. The work the a c t u a l work you do for this community is enormous 👏👏
6.3k views in 5 minutes??? I SEE YOU
Wait a damn minute... I commented a year ago?? Why can't my brain comprehend what's going on
hahahahahahah it was "unlisted" and for whatever reason youtube resets the date when you make it public
as I was saving my own copy of this I accidentally clicked something that made google think I was trying to edit your copy so sorry for that email 😅🙏
Forgive me if this is in the video, I'm comfortable with excel so I didn't feel the need to watch all of this, but out of curiosity did you consider adding a sexuality tab for authors as you did for race?
PS this sounds like a complaint I should be thanking you for your hard work will absolutely be tipping you when i can
I didn't mention in the video but I addressed it at the end of the directions page that I don't personally feel any author has to be out or open with their sexuality and that sexuality can be fluid making it harder to track but anyone is welcome to add it for their own tracking!
@@hardbackhoarder makes sense, and good idea thanks!
I'm over here thinking this is a stream🤣🤣
hahahahahah i guess i coulda done that!
I wonder how many emails you have gotten since this video has went live asking how to change it....lol
SO MANYYYYYYY
@@hardbackhoarder noooooooooooo. some people are just dumb. they can't help it.
What confuses me is how to put how long were audiobooks? If an audiobook is 14 hrs and 20 mins, how I should put it?
Up to you! I believe you can actually change the format to time format from the top menu. I tend to round to quarters myself (15 mins - .25, 30- .5, 45- .75) because I personally don't care for it to be precise.