ULTIMATE READING SPREADSHEET 2023 / walkthrough & link + CAWPILE options

here's what to expect in my 2023 reading tracking spreadsheet!
etsy: www.etsy.com/shop/withali
tip jar: paypal.me/alisoncline
G's 2023 CAWPILE Spreadsheet & Download: • CAWPILE: V4 Reading & ...
Other (mostly free) reading spreadsheets: www.notion.so/Reading-Spreads...
chapters:
intro 0:00
download options & instructions: 1:55
books read page (& apologizing): 3:41
yearly stats: 9:30
monthly stats: 12:26
series tracker options: 13:01
habit tracker options: 18:24
book acquisitions: 20:26
library books: 20:47
new releases: 20:55
23 in 23 tbr: 21:01
owned library: 22:00
readathons page: 22:46
selection choices: 23:29
cawpile differences: 24:55
end: 27:15
where to find me:
bookstagram: / hardbackhoarder
instagram: / ladyayycee
twitter: / hardbackhoarder
twitch: / withmalice
goodreads: / hardbackhoarder
📧 email: [e-mail]
ways to support my channel:
tip jar: paypal.me/alisoncline
buy me a coffee: ko-fi.com/hardbackhoarder
audiobook wishlist: libro.fm/wishlist/1131730
amazon wishlist: a.co/eNb4p9l
discounts:
scribd two months free (plus one free for me) → www.scribd.com/g/5pe8ou
libro.fm (we both get a free audiobook) → libro.fm/referral?rf_code=lfm1...
sips by box $5 off→ "HARDBACK5"

[@JordalineReads]

It's totally fair that you charge people for it! Your labor isn't free. Now excuse me while I make a purchase 😈

[@CaitlynAnneReads]

I'm so glad you're charging for this! The amount of time and effort is astounding. I think I sent you $20 aud last year because I was so grateful for you makin this available to us! THANK YOU ALI!

[@JurassicReads]

You're amazing, thank you for putting this together and finally not making it free! You've put in a lot of work in the previous years' ones (and obv this one), and you totally deserve to be PAID for your hard work. I'm excited to use this for 2023!!

[@HappyforNow]

I am so excited you actually charged this year because this whole thing is amazing 💖

[@aotearoawahine100]

this spreadsheet is a thing of beauty and I love using this every year - I think it's great you're charging for this now as this is a huge amount of effort and is worth paying for so I don't have to do it (and my attempt would be much more simple!) Have bought and started playing around with while watching this, can't wait to start logging my 2023 reads!

[@Weirder_the_better]

I was so motivated and inspired to make a tracker like this immediately after watching your video. I have a lot of experience with Excel, so I figured "Heck yeah, let's do this!" I sat down and quickly realized just how much time and attention you gave to this spreadsheet and I purchased the green version from your Etsy. My version would only hope to emulate your beautiful design - you deserved the purchase. I'm going to add my own books right away!! I have a few reading challenges as well that I created for myself this year that I will add new sheets for. Thank you so much for making this available to us all! :)

[@shelbycreads]

i’ve never used a spreadsheet in the past. this is the first i’m hearing of it and i’m TOTALLY buying one. honestly $5 is a deal for how awesome this is. thanks for sharing!

[@WorldAccordingtoEmma]

I paused this 18 seconds in because you have been teasing me with your tweets about this new spreadsheet. I have been using your's for the past 4 years and I love them. I'm so excited to see what you put together and it get it set up for this upcoming year. Thank you in advance for all the hard work you put into it! Now I'm going to go watch the video!

[@G-Swizzel]

IT'S HERE AND IT'S BEAUTIFUL!!!! Thank you so much for all your hard work Ali, I cannot wait to use it! 💕

[@amber8206]

Thank you so much for all the hard work you put into these! Also I learn so much just by snooping on your formulas and how you set things up! Super excited for the easy way to add things to the drop down menus!!! That’s so cool! Going to go purchase it now, thanks again for all your hard work ☺️❤️

[@savannahlee5322]

WOW this is so thorough! I’m excited to use this, as I’ve been using my self-made spreadsheet the past 2 years. It’s hard work!

[@Thelittlebookwitch]

Honestly I’m in awe at how you do all this! This is actually amazing ❤️

[@jesstheneverendingbookshelf]

Thank you so much for doing this again. Your spreadsheets are the best and I am totally happy to pay for them!

[@carleene18]

Thank you so much!! I love this and could not do this without you. I just need the basics but I so love all that you include. Also, well worth what you are asking for all the work you have put into this. Thank you!!!!

[@jampsonn1826]

Wow Ali this is truly amazing! I've downloaded the free trackers before but this is next level and I think it's great you're charging for it. Sure, people can say "oh I can just make my own," but anyone who uses Excel daily knows how time consuming and tedious it can be to make multiple tabs, columns, rows, link them all with formulas, make everything cohesive and easy to read, make a graphs chart with all the data, and make it pretty! You've outdone yourself. I'm happy to buy one this year and support your work and time! 😊

[@Kylie546363]

Thank you for putting your time and effort into this I have already bought it and now I'm prepared for 2023 you're amazing!!!

[@mirrorballmusings]

This is honestly a gift!! Can't wait to start reading :D Thank you!

[@KaylasBestie]

This is awesome!! I found your channel by chance and am so glad I did!! I've been having problems finding a great way to track my reading challenges. I've gone through so many journals, followed so many channels, and just couldn't find anything that worked for me. I've purchased the spreadsheet and can't wait to explore and use it. Take care and thanks again for this.

[@BrookesBooks]

Thank you for all your hard work on this, I love using them every year! On my way to buy now!

[@teaindecember]

Thank you again for making this available every year and I'm so glad to compensate you for your efforts, this is so complex and you deserve it!!

[@amandaday313]

I love the aesthetic of your spreadsheets. It's permanently altered the look of all my own spreadsheets I do for work, lol. I love seeing all the changes you do every year. One thing I recently added to mine was a world map that highlights the countries I've read from. One of my goals is reading a book from every country in the world. Took a lot of fiddling to get it pretty but it worked out. I love discovering those hidden features in spreadsheets.

[@HardbackHoarder]

Oh that sounds AWESOME I may take that idea 👀

[@MissRaindrop24]

What program do you use. Google, excel or another one?

[@amandaday313]

@@MissRaindrop24 Google sheets. It should be in the chart and table menu.

[@ixis3094]

I'VE BEEN WAITING FOR THIS AHHHHHHHH

[@seiryumiko]

Last year was the first year I used your spreadsheet and loved it. The updates you made here look great, like the author count on the dashboard being added :) And the color options! Excited to use this for the coming year.

[@kelsiemarice7507]

This is so detailed! You are a spreadsheet wizard! Can’t wait to get in and play around

[@FourPawsandaBook]

I HAVE BEEN WAITING FOR THIS!!!

[@themidnightlibrarian5159]

Love it Ali! Thank you so much! I absolutely love your book trackers every year and am happy to pay for your hard work!

[@StrawberryLemonBooks]

Thanks so much for making this!!! Super excited to use it 💜

[@MarianaFerreira-dh8kx]

This is simply amazing, thank you so much for your hard work!

[@adelabibrlova2481]

Thank you so much! I love these and I appreciate your work ❤

[@elise85391]

This is amazing. And I love how the aesthetic of the spreadsheet you were showing matched your personal aesthetic with your purple glasses and hair and everything!

[@Floripondia77emilyG]

This would be my first year working with a RT spreadsheet, I´m very excited! It looks amazing 💓💓

[@samanthaaiello]

Stunning! I’m glad you are charging. This is your work, and you deserve to charge for its value. Your time and effort is valuable

[@redistrying]

amazing as usual!!! I'm glad you are charging this time you worked so hard!! Thank you for this

[@GavinReadsItAll]

Yay I love the spreadsheet so much and have just got my copy 🥰 can’t wait to use it for 2023

[@Freak80MC]

I clicked because of that thumbnail. I don't necessarily need a spreadsheet for reading but as someone who keeps track of some stuff in spreadsheets, I'm gonna watch this and see what I can take away to improve on my own spreadsheets! EDIT: I actually might take away some of this for a reading tracker, or maybe a more general "media tracker" to track stuff like TV shows, movies, and books too. Tho I definitely would like to increase how much I read, I didn't keep up with reading very much in the latter half of last year and maybe keeping track of it would help me to do it more often lol EDIT2: omg you can do progress bars in google sheets, I never knew that! But a lot of this is definitely more complex than I would go, but might work for others! (my personal philosophy with any system I make now is that it needs to be simple enough to not overwhelm me and not feel like more of a chore to keep up with than anything lol)

[@lizzyrose5494]

Thank you so much for this!! I just bought it and I am so happy to set it up with all my unread library, that's my goal this year, to read my own books :D

[@steviereads]

Just wanted to say thank you so much for this!! This is an incredible spreadsheet, and I'm happy that you chose to charge for this!

[@kylerbooks]

STUNNING! this spreadsheet is gorgeous and I think I am in love

[@dimerymichaels3539]

This is my second year using your spreadsheets! THANK YOU! I am an excel nerd, but these are way above my knowledge base and I am in awe of you and all the hard work you put into this!! I am very glad you're charging for this. It is beautiful and so worth a monetary amount!! Thank you for offering this for us. It's amazing. (:

[@KarasBookshelf]

ali, you are incredible. thank you for your amazing skills and this incredible spreadsheet!!!

[@KristinKravesBooks]

Watching this as am I playing around with my spreadsheet. Worth every penny!

[@ashleydochuk9603]

Holy wow!! You are incredibly talented!! And heck yes.. charge! Going to buy now!

[@clairescreativecorner]

have wanted to try something like this for a while and this looks amazing, Ali you are amazing for creating this I can't wait to try it out and see how I get on with it :)

[@daryanreads]

ugh it's so beautiful thank you for making these😭😭

[@esliet]

Wow excellent work you do. Will have to get this

[@shelfaddiction]

This spreadsheet is so detailed and I love it! Exactly something I will use, I'm going to head over to your Etsy store right now. Thanks!

[@meganfoster4360]

I went and bought it! Thank you. You're amazing!!

[@NerArt]

super excited for this one!

[@mikkareads]

Good for you for charging! This obviously took time and effort, and I'm looking forward to filling it up.

[@AmyNoelleReads]

much appreciated! just downloaded it and I love it!!

[@justynajusty]

😲😲😲😍😍😍😍😍💜💜💜💜💜💜 this is amazing!!! Love it. Thank you so much for this. Love it!

[@sarawithoutanH]

i've used your tracker for the past two years!! so excited for the new and improved one. glad you're getting paid for your work this year!

[@shek1029]

Thank you so much! It is greatly appreciated!

[@metzgersc]

You are amazing for creating this!

[@bookreviewswithzoe]

Love the spreadsheet, the colour palete is beautiful. Will definitely purchase a copy

[@heiditheowl2277]

this is incredible and i need this in my life, immediately purchasing

[@rasaslase]

This is amazing! Love the colors

[@the_eerie_faerie_tales]

This is amazing !! Thank you so much 😸

[@nancynurse4552]

Purchased as soon as I watched the video. I inputted my first two completed reads for 2023 and found it very user friendly. Thank you for offering this especially at the extremely reasonable price that you did.

[@emilyelizabethbooklover]

As always your spreadsheets are amazing!

[@emilyreads5207]

Excited to use this this year. And the hair color is amazing.

[@AbiofPellinor]

You put in so much effort to this! ❤

[@KatheD]

wow, totally awesome!

[@katmartiuk6990]

Just got it thanks so much!

[@iamlaurenhannah]

I make my own spreadsheet because I'm a control freak, but I LOVE watching what you do with yours every year. You're absolutely incredible at this! Respect!

[@ZeeZeeDreaming]

You do amazing work with these spreadsheets!

[@BookaholicsAnonymous]

This will be my first year using a spread sheet, but I like the idea of it so i went ahead and purchased. :)

[@kburkett1231]

this is absolutely AMAZING. take my money💸💸

[@BrittanyLovesReading]

This is amazing! Thank you!

[@gloriac.3447]

I’ve never used a spreadsheet but I want to try something different so excited to use this!

[@kwatschmitsauce]

I just bought it and it looks so good!

[@Monica.Bibliophilebynight]

SPREADSHEET, SPREADSHEET, SPREADSHEET!! YAY! So excited for this!

[@JasReads]

I LIVE FOR THESE

[@BoldBookNerd]

Your hair always looks fabulous! Love the purple!

[@AussieGamerGirl77]

Wow! Just bought a copy. Well worth it with how much work it would have taken. Am loving that I can track series and readathons now.

[@leannejenkins6887]

Thank you so much for this. I love Excel and have put together my own spreadsheets for reading tracking in the past. But with a one year old and going back to work full time, I'm more than happy to pay you for your creation instead!

[@KeepCalmwithBooksandCoffee]

Thank you for all your time and effort putting this together Ali! I'm happy to compensate you for your time because I have no idea where to start making one. 😂

[@BookedandBusy]

Ali you have outdone yourself! Im running to Etsy to get myself a copy!

[@rosepehtels]

thank you for making it decently priced 🙏🏻🙏🏻🙏🏻

[@LynnetteReads]

I think you are charging a more than fair price for the work you have put in. I just spent the last hour looking up the COUNTIF and COUNTIFS formulas to add to bits of information to the owned library page. Most places would charge at least what you are charging for an hours work! Thank you for the encouragement to figure things out though as I have now added a table to show me how many of each format I own and also a table to show me how many of each formula I have read.

[@HardbackHoarder]

UPDATES I will list any updates or changes that need made if you downloaded the template before the update date: 12/29/22 @ 8:18PM EST The Total Series number in the Series Tracker OP3 formula was changed to =COUNTIF(B$5:$B,"*") 12/29/22 @ 10:07pm est The Finished Series number in the Series Tracker OP3 formula was changed to =COUNTIF(T:T,"Completed") 1/2/23 @ 9:02AM EST For CAWPILE version, on the Monthly Stats page, the average was not computing. The formula had =IFERROR(AVERAGEIF('Books Read'!$F$2:$F,"January",Rating)) This was changed to =IFERROR(AVERAGEIF('Books Read'!$F$2:$F,"January",CAWPILERating)) All equations for each month need the “Rating” changed to “CAWPILERating” in the formula if you want to update this change. 1/4/23 @ 8:21PM EST If using Series Tracker Option 2, the formula for total number series counted at the top needs changed to =COUNTUNIQUE(D6:D) It was reading =COUNTUNIQUE(E6:E) which was incorrect. 1/8/23 @ 9:28AM EST I went in and reset the Habit Tracker OP1 calendar colors after realizing many dates had reverted to a purple color. If you are using the GREEN, BLUE, or BLACK template, this likely is the case. To fix this, open the original template. Find the Habit Tracker OP1 Tab and right click. Go to Copy to -> Existing Spreadsheet. Find your Reading Spreadsheet and copy it there. It will now be the last tab in your spreadsheet. Drag it to where you want and copy your current data from your original tab over. (You can click and drag to select multiple data) Delete the original tab and rename the copied habit tab. Very sorry for this inconvenience! It is one issue I can’t seem to troubleshoot enough to figure out why it happens.

[@Cloud9Izzy]

Wow. The amount of work that’s put into this. Take all my money!!!

[@xcsbooknook]

Used it all year last year, with some slight modifications. When I get my paycheck Im getting this one as well

[@YarnReader]

WHOOOOOOOOOOO SPREADSHEETS!!!

[@inhalemusicxhalelife]

Just want to say thank you for making the spreadsheet. I first discovered it back in 2021 but didn't end up using it in 2022. So glad you're charging this time as well, you worked hard and deserve to be compensated for it. Also, where are your glasses from??? I literally went: "OOOH!! Those are pretty."

[@cucina_kristina]

I have always thought you should have charged for these. I get so much value out of these that I will happily pay for them. Thank you for doing all of the labor! 🎉

[@desertbebe7331]

Brilliant

[@floralvarezr]

This is sooo good

[@floralvarezr]

Already bought it. I love it!

[@AliDoisRead]

Yessss!!

[@riankoch9126]

The drooling I did over a purple spreadsheet 🤤🤤🤤🤤

[@JashanaC]

lol I just recorded my spreadsheet & stats video and now I'm like.... "jk deleting all of the spreadsheet stuff bc I'm just gonna use this moving forward!" brb gonna go purchassseeee!

[@lovevanillabug]

Girl, I’d pay 10 for this. ExcelGoogle spreadsheets are a pain in the butt with all the formulas and I swear I would pay someone to do all my required excel/spreadsheet work for me. This must have taken so much time. Absolutely charge for this. As someone who purchased it, I can say A LOT of data is in here and it must have taken hours. Thank you for putting so much effort into this.

[@shannont6061]

This looks amazing and I thank you for taking the time to do this. I'm new to your work and would like to ask if there will be a new version for 2024?

[@HardbackHoarder]

YES!

[@shannont6061]

Yay! I love the one I have and am definitely on the lookout for 2024

[@hatchet1013]

Honestly Im shocked you didn't charge before. I wasnt sure if there would be a new one so I was customizing the 2022 sheet which was so much work lol.

[@soniciris]

I got this and tempted all my bibliophile discord friends to follow me 😂 it was the charts what got 'em! I reckon you'll release one every year? I'll definitely keep using it, it's really helping me with my habits to fill it out every day 🤓 if you do make a 2024 version, it would be fun to have some extra challenges (23 in 23 is great, I'm challenging myself to read down my owned tbr lolol) and maybe a 'experienced user' option with no dummy data 🤔😎

[@cherryseven7926]

I absolutely love the additions and changes to this spreadsheet and will definitely buy it. If you're taking suggestions for next year, G (from the BookRoast) has a chart that converts the final CAWPILE score into a star rating. I combined that with your sheet from last year, because that makes it easier for me to add the star ratings to my Goodreads and Storygraph pages. Again, thanks so much for offering this!!

[@HardbackHoarder]

This converts the CAWPILE into a star rating as well (it's just the average!) If that is what you mean? You can move the decimals it provides if you only wanna see a single star (like 4 stars) instead of like 4.7 stars

[@HardbackHoarder]

I see what you were saying about the star rating!! I didn't realize it was different than the average so sorry for my misunderstanding!

[@ldybg1177]

Here take my money 💰. You had me at series tracker

[@estefaniasanchezsanz7333]

Totally normal that you sell this, i tried doing some changes to a spreadsheet and its time consuming, and time is money. Thank you for your effort!

[@MeMyshelfAndI]

Kind of like your 23 in '23 page, it would be cool to add other challenges. Around the world (reading from various countries) and Alphabet (starting with each letter in the alphabet) would be really cool to include. And depending how intricate you get with tracking it, could be a significant extra value you can charge for. :)

[@arcadelinkauthor]

15:45 If you want to hide the Manga section there, you can just select the columns, right click, and select "Hide columns." Out of sight, out of mind!

[@HardbackHoarder]

You will lose those stats at the top though! (Which might be unimportant anyway so wouldn't matter lol)