How I Rate My Books (CAWPILE) + Downloadable Reading Tracker Spreadsheet | Book Roast

[@lori.sabrina]

This system is the reason I trust your ratings more than anyone elses!

[@BookRoast]

Thank you, your trust means so much! ✨🖤🖤

[@StarspangledHeart]

Spreadsheets make my nerd heart happy! I can't wait to check it out when I get home from work. I wonder if my book ratings will change a lot vs. my gut star rating.

[@BookRoast]

I wonder too! I’d love it if you could tell me!! ♥️

[@leannejenkins6887]

I cannot believe only found your channel since being in lockdown. You have given me the OWLS, a bi monthly book read club and now this! I was actually thinking of making a spreadsheet like this for next year but as you've already been so kind to share yours I might as well sift back through my 2020 reads and start now! So grateful for you fulfilling my nerdy book analysis needs!

[@BookRoast]

Aw happy to hear it is useful! I hope you’ll enjoy using it! And thank you for all your kind words, hope you’re keeping safe ♥️

[@judee.9362]

I love CAWPILE and have been using it for about a year now. It's so helpful when you write reviews too, because it gives you specific things to focus on. That being said, I really need to know who murdered Papa Blue!

[@BookRoast]

Aw I’m so happy to hear it’s been working for you! ♥️ hahah it will be the biggest mystery of 2020 😱😱

[@savannahcarlon7033]

Maybe it was you O.O

[@JungkookxSim]

Going to start using for 2020!

[@judee.9362]

@@savannahcarlon7033 Plot twist! 😱😂

[@MarissaCurtis0630]

I love this spreadsheet!!!! Note for US users though, use the UK date format (or change the spreadsheet to US date format) otherwise the date calculations won't work. US=month/day/year UK= day/month/year It literally took me 10 minutes to figure out why the formula wasn't working for me. lol

[@era5943]

Oh my god, this system satisfies my organizing self! I am definitely gonna use the spreadsheet. I always thought the de goodreads way wasn't helpful in many ways, and this definitely is. It is also gonna help me a lot to think more through about what I really think of the books.

[@EviLittlefoot]

I LOVE this! I’ve been wanting to find a better way to rate my books than “hmmmm how many stars does this feel like?” 😅 Thank you for sharing!

[@savannahcarlon7033]

I so appreciate that spreadsheet. I never learned how to use Excel and I'm impressed that it actually works.

[@lialoveislife]

Okay, now this is a great outline to help structure my book reviews. Maths was never my strong point so I'm happy the spreadsheet will fix all of that. I have subscribed to your youtube channel. I know that this video is old but this is evergreen content as it is still relevant. Great stuff!

[@BookRoast]

(Sorry for the caps I copied this from insta haha) GUYS! IF YOU GOT THE SPREADSHEET A WHILE BACK (within first 3 hours of the upload) PLEASE DOWNLOAD A NEW COPY AS A COUPLE OF TOP ROWS HAD A FORMULA MISSING FROM WHEN I DELETED THE DEMO INFO! THIS WILL MAKE THE STAR RATING STATS NOT SHOW UP FOR THE FIRST 15 OR SO ROWS! IF YOURS SHOW UP JUST MEANS YOU DOWNLOADED IT AFTER I ADDED THAT BACK ON 🥰 YOU CAN DOWNLOAD A NEW ONE AND COPY-PASTE YOUR INFO IF YOU ALREADY PUT SOME IN! ♥️♥️♥️

[@leahb9609]

Thank you for this spreadsheet! I've been rating on a system similar to this for years now...and I really like yours, especially the acronym. I've been working on my own spreadsheet but I'm terrible with the formulas. I've incorporated this into mine that I have...I think I'm going to love it. I just have to retrain myself to think of my ratings on a scale of 1-10 instead of 1-5.

[@MariaMightReadThat]

I’m using your spreadsheet for the first time this year and I’m so excited. Thanks for putting so much thought into it and sharing it with all of us!

[@paginator]

Thank you SO MUCH for the spreadsheet! One of my reading goals is to use CAWPILE for every book I read.

[@131Hora]

Now I kind of want to read the big blue book :D

[@BookRoast]

It’s really good, got 4 stars! 😂

[@Sharie-]

I've been using CAWPILE since you've introduced it to us, but I never checked out this video before. Looking forward to using this spreadsheet now. Thank you so much, G!

[@berryvillain5115]

This system looks fantastic! And the spreadsheet is sooo helpful!! Thank you for taking the time to make the spread sheet AND to explain it to us!! Im starting this is January 2024!!

[@Erinnlovestea]

I just found this video and the rating system and spreadsheet are LIFE CHANGING!!!! thank you!!!

[@MiyagiYuki]

Thank you a lot for sharing the spreadsheet. It's amazing and I'll be using it through the year and for life. You're lovely!

[@djezmin_o]

This is sooooo helpful and awesome and satisfying! Goodreads should totally employ you to make their website better, lol.

[@i_am_robinnxp]

Thank you so much for taking the time to making and explaining this spreadsheet for us! We really appreciate it

[@aliceborry3753]

It's so interesting to hear about your rating system ! (I rate my books purely based on how I feel right after I finish them - I guess I read too many books that would not fit into a well-structured rating system haha). And thank you for this wonderful spreadsheet, I will use it to track what I read in 2020 ! Have a good day :D

[@kerstincarw2503]

Wow! Thank you for this spreadsheet! I can't wait to write all my books into it!!

[@tanjagardner285]

Thanks so much for making this available - here via JadeyRae, who recommended I check out your channel when I asked about her rating system. Really looking forward to using CAWPILE (and I ALSO really want to know who murdered Papa Blue ;-) :-D :-D )

[@abbeyroche2983]

You are so talented!! I’m still reeling from the magical readathon and now you have given us this! Thank you so so much 🥲

[@carissaclimer6919]

Oh my gosh that spreadsheet is amazing. Makes my little Ravenclaw heart happy!

[@xchaptersofcrime]

This spreadsheet is amazing! Normally I would rate books by enjoyment , but this is so much more fun en specific and so handy to write reviews! Thank you G!

[@gamiine1]

I've been wanting to use CAWPILE as a rating system on my blog (of course I'll credit you!) for a while now and thanks to the spreadsheet it makes it so much easier! You're a wonderful person G, thank you ❤️

[@42lucyinthesky]

This has made my nerdy little heart so happy, I have tracked my reading for a few years now but this is so much more in depth, and the graphics are just the best!

[@mybookishdelights4767]

I'm so excited to use this spreadsheet! It will make it so easy to use your system. I remember your other video and I liked the idea of CAWPILE, but when it came down to it I still just went mainly with my enjoyment level. I love that this calculates it all for me. Thank you so much for all the effort you put into it! :)

[@mariaval9501]

G!! SERIOUSLY?!? HOW COME YOU’RE SO AMEOWZING?!? This is incredible and ridiculously generous of you to teach us this, and for you to create and share this spreadsheet. You’re unbelievable, woman!! I just love ya! Thank you!! 😽😽🖤🖤

[@lazyhomebody1356]

Sharing is G's middle name

[@mariaval9501]

lazy homebody So true!

[@chelsikay13]

7:45 wait! Hold on! Who killed Papa Blue?!

[@BookRoast]

Wouldn’t want to spoil the book for you! 😱🤐

[@chelsikay13]

😂😂 dang it!

[@RaesReads]

I have officially switched to this rating system now - I love it!! Thank you so much for making this amazing spreadsheet and helpful video 💜💜

[@ASJames]

Dude, your CAWPILE video is the video of yours I've watched the most. Literally have it linked in the hotbar of my browser. I still remember when you messaged me saying you were thinking about creating a rating system and a simple spreadsheet to go with it. Now we are here :') Also let us all remember The Big Blue Book as your debut novel haha.

[@BookRoast]

I remember that too! I was convinced people will think I’m crazy for being extra 😂😂♥️

[@lazyhomebody1356]

"Does it frequently lead to your unfortunate demise?"

[@frenchshark]

I am so glad you made this! Cawpile seemed rather intimidating initially but it's so easy and I think it'll help me rate my books better as I'm far too easily swayed to give things an easy 4/5 star based off of just random feels when I finish it.

[@samantharust5901]

I LOVE CAWPILE! G, you are amazing and make my Booknerd heart happy!!!

[@galacticzoologist]

This is so cool. This might help me think more critically about my reading. Also I really need to know more about the Big Blue Book.

[@angieallen4884]

Thanks! This is going to be very helpful going forward. Love the spreadsheet!

[@ashleycanter5155]

This is super helpful! I always felt like star ratings were really arbitrary so this will help me figure out a good way to rate books for Goodreads. Edelweiss uses a system similar to this for their ratings when you give a review. You put so much work into this spreadsheet, thank you so much for sharing it with everyone for free!

[@BookRoast]

So glad you like it! ♥️

[@forgedinfiction4376]

This is the greatest thing to ever happen to my lack of reading stats. I am 100% using this from now on, bless your soul for creating this spreadsheet 😱🖤

[@Jamhands9]

I used a spreadsheet last year and loved it. I’m going to use yours this year! Sometimes I have a hard time rating a book, and I think your system is going to really help me.

[@theliterarylawyer5304]

I watched your old video on this and loved it but I've always rated my books based on feeling. This year I think I'm going to change it up and try your system since I feel so wishy washy about my own ratings. If you don't mind, I'm going to call it EPIC LAW instead since I'm a law student and it fits. Love this and thank you for sharing it with us!

[@BookRoast]

Hahah yes absolutely!! EPIC LAW sounds awesome 😂♥️

[@rachella7247]

I'm totally using this spreadsheet! I had already created my own but I don't know how to create the stats graphs. I could probably not be lazy and learn myself lol but I stumbled upon yours, so I really appreciate you putting this out for free for our use! CAWPILE is also new to me so I am excited to see how that goes. :D

[@jerseybabe412]

Just opened KZbin, saw you had a new video out and actually said “yay” out loud because I love watching everything you put out and I am so excited to see an updated version of this! 💜😍💜 Edit: Now that I’ve watched I can’t wait to download the spreadsheet. It’s very similar to the tracker I just put in my bujo for the new year, lol. I’ve used CAWPILE for a few books but plan on using it exclusively for rating this year! :)

[@shabnamjafari8070]

I just start using it and its fantastic!!!!! it helps so much and it's really fun thank you so much for making this and sharing it for free! only one suggestion: it would be nice to be able to add more than one genre for each book, it'll make it more precise I have no idea how to make such a change to it otherwise I would have done it myself

[@alisonrobertson9110]

Finally created mine and I absolutely love your system! I was stuck between 4-5 stars for the books for the Caraval series and this helped me to see my true rating!

[@jaievi76]

Thank you so much! I cannot wait to start using this. I have been wanting a better way to rate/analyze the books I read so it doesn't feel so much like just an arbitrary star rating based solely on how the book made me feel. I am not good at analyzing books so looking at each of the 7 CAWPILE categories will be different for me. I am super excited to give it a go! You are the best G! ❤️

[@ForFictionSake]

This is awesome. As someone who feels like my ratings always come out very vanilla or polite. I look forward to using this to be more critical of the books I read this year.

[@jenny_readss]

Ah thank you so much!! Definitely going to use this! I've been using cawpile for about 6 months now, I love it!

[@kerisbookishcorner2864]

This is what I’ve always been waiting for in my reading life!!!

[@cozybruna]

Thank you for this system and the spreadsheet, G! I had already decided to use CAWPILE this year and this is just perfect!

[@librariananna]

This rating system is my favorite!! Thank you for the spreadsheet~ I tweaked it a bit to fit some of the other stuff that I also like to track and match my branding colors but it is everything!!

[@rinapereira]

Thank you so much for this video and the spreadsheet!! I always track my books on a reading journal and it's really hard for me to be objective when choosing the ratings for the books. It's my first time hearing about the cawpile system, maybe because not many Brazilians know about it. I'll definitely give it a try and talk about it on my booktube channel, and give you all the credit of course and link this video ❤️

[@pierre-francislefoutre6131]

Thank you so much for your sheet, I was looking for something like this but I suck in spreadsheet. Thank you again!

[@nadnadnadnad7133]

I really like your categories! I think I would personally change logic to meaningful or something like that because it's important to me that a book is personally or socially meaningful to me! I'm going to try using cawpile together with my current rating system to see which one fits me better. Thanks for this!

[@kourtneyD84]

I love this. I prefer this video to the last one it made it so much easier to understand the whole process

[@LienVNDL]

This is so great! I love how simple yet extensive the spreadsheet is. Thanks for sharing!

[@megandherbooks6830]

This is perfect, and it'll certain help with writing reviews as well, gets you to think what worked in the story for you or not. Thank you for sharing!

[@LJG7654]

Thank you so much for sharing this! I love stats and reading so now I feel the urge to list everything I've read in the past as well as starting this year!

[@CurrentChapter]

I have been using this system since last year, it's amazing! I only changed it a bit to make each category weighted (enjoyment has more weight than logic, for example). I have my own spreadsheet, but this one helped me so much, I learned new things from it to make mine more efficient! =D Thank you so much for sharing this!

[@khsmiles]

I am so excited to check this rating system out. I have been needing some better structure when it comes to rating my books. On my copy of the sheet, I switched the POC author for if the book was a reread. I think that will be more useful for me. I already plugged in the book I finished today. So this was great timing. Looking forward to using this for 2020.

[@stephaniesbookverse1098]

ok, you go all out and I love it! I will definitely be using this for 2020, so convenient and I love having a system for rating my books. Thank you for all the time and effort that went into this. Love your videos!

[@birgitcecilie626]

Love that you did this! Never rated my reads before but its going to be fun using your cawpile in 2020. Also a great way to track my reading! so thanks! your the best!

[@kellyhaymans7478]

This system is so awesome! This year I'm trying to read more & I started a reading journal to keep track of what I read. I'm now also gonna use you're really cool spreadsheet to do my ratings! Thanks so much!

[@imanehamzaoui]

thanks a lot for sharing with us how you rate books and also the Reading Tracker Spreadshee 👍❤️❤️

[@rachemsful]

This is bloody amazing and I am for sure going to use it! Thank you G!!!

[@BookRoast]

Yay!! Thank you so much I hope it works well for you! ♥️

[@Hellosquirrel]

I am so excited to use the Cawpile spreadsheet!

[@TheLadyAli]

Love this!! Going to have to give this a try. Thanks for the spreadsheet!!

[@tinksreviews347]

How have I only just found this? Ah this will help my reviews so much as I struggle to decide what stars it should be given! Thank you. Also, you’re glasses are beaut 😍

[@ragecleaner]

Oh my gosh. The excel nerd in me is screaming right now. THANKYOUUU

[@MamaLoves22]

This is so helpful. Thank you. The link to GSheets still works.

[@MuzmuzM]

nice ... i never used the cawpile system before and maybe i should for am a bit generous when giving stars to books ^^ wonderful video as usual ^^

[@staceyinthesticks]

I only heard about this recently, going to give it a go as I always struggle with star ratings when comparing to other books 😅 Thank you!

[@kerisbookishcorner2864]

I love this and feel like it’s a great way to determine why books are getting rated the way they are and what you like in books-I’m going to give this a try. Also I LOVE things that are extra lol

[@GBunnyG]

Man, this blue book sounds really compelling. :-) I love your system, I've never really been able to do it myself. But I may play around with this spreadsheet this year and see if I can make it a thing for the year. You are wonderful, as always.

[@thebookwitch5575]

I’ve been looking for a reading tracker for ages, so happy you made this video! Thank you ❤️

[@samanthafrazier5071]

Oh my god, I just started a bookstagram and I also hate the five star system on goodreads so this is sooooo helpful! Thank you so much for sharing!!!

[@kandimassey8582]

AHH Thank you so much for this! Between this and the Magical Readathon, you are just the best!

[@lovedanielle91]

Wow this is incredible!! I am so excited to use this!!! Thank you again for making something amazing and sharing it with all of us!! ❤️

[@librocurious]

Oh my goodness, this is so helpful! Now I don’t have create my own spreadsheet for stats for this coming year. Thank you, thank you, thank you!

[@bookswithike3256]

Ooh this is really interesting! I will definitely use it. I don't know if I will actually let it define my star ratings but I might have like a note in my Goodreads review that says "CAWPILE rating."

[@J2thePower0f3]

I LOVE where your heads at. I know what I’ll be doing at work tomorrow 💃

[@mayelaar]

I love this video and your generosity, G! Thanks for sharing the spreadsheet, it's awesome!

[@elisedubois2328]

I'm gonna try it and compare it to my intuitive reading ! thanks a lot!

[@janamarie2317]

Thank you for this amazing spreadsheet, I'm really hoping to get a good use out of it this year! 😊 Also thank you for all these amazing projects you did over the last years, I'm always in awe of how much work, thought and passion you put in to those, you are truly amazing!! 💗😇

[@Airykah1382]

I love this and look forward to trying it out. I also like spreadsheets!

[@Thedyslexicreader]

G wow. This is crazy! Thank you so much this is going to be my yearly obsession and so helpful. I truly appreciate all the work you have put into this.

[@ClaireRousseau]

Ooooh, I'd never heard of CAWPILE, but it looks super useful! I haven't been giving things star rating for a while because they seemed so arbitrary but I'm excited to start doing it again!

[@yvonnereadsya4722]

Wow! This is so amazing and comprehensive. I can't wait to give it a go! Thank you for sharing :)

[@ronnietucker3712]

Thank you for the spreadsheet. This rating style is awesome

[@ChronicReader]

I love the rating system! Kind of funny, I just went in and put in all of the books I read this year and it came out pretty close to what I rated without a system.

[@georgiam910]

Thank you so much for sharing the spreadsheet. I have already started using it!

[@jennawar13]

I used your rating system especially when I'm not sure how to rate a book right away. I remember it as EPIC LAW because I think someone commented that on your original video haha, and sometimes I just do it on the 1-5 scale for each category so the math is even simpler and just finding the true average.

[@1Natulcien]

This looks like fun and I'm definitely going to give it a try. Thank you for making and sharing this!

[@hazellawrence2062]

I think I might start doing this!! Thanks for making this video!❤️

[@lia-ym3gt]

i started using your system a year ago and i love it so much!

[@christinegreve5602]

I AM SOOOOOOOOOOOOOOOO EXCITED FOR THIS! I'M ALSO USING IT AS A CHALLENGE TO HELP ME READ A BOOK BY A CERTAIN DATE.

[@ViVaLaGloria999]

Hei G., just wanted to say that you are an absolute gorgous person, keep being as humorous and positive as you are 😘 watched you a LOT in 2019 and you became my favorurite youtuber to watch, loved all your videos 😊 excited to see what 2020 holds for you!

[@BookRoast]

Thank you SO much that’s so kind of you!! I hope I keep making the content you enjoy! ♥️♥️♥️

[@lindsayjardine3376]

Just discovered this spreadsheet I love this I love organisation thank you for this x

[@ruthsamworth5077]

I'm crying in bookworm this is beautiful can't wait to use this 😊 thank you G you're the bestest

[@BookRoast]

Thank you!! I’m so excited that you’re excited 😅😂♥️♥️

[@amitymiller9340]

Thank you!!! This is exactly the kind of tracker I've been looking for