Book Rating Spreadsheet: CAWPILE V.2 [CC]| Book Roast

[@ElevenDaleks]

Ok. I'm actually speechless. The new version is amazing and I can't wait to use it this year! It must have taken so much time, but it's perfect!

[@BookRoast]

So glad you like it, hope it’ll be fun! 🥰

[@cherylpierson4462]

I plan to start using this this year.

[@BookRoast]

Hope you’ll find it useful ✨

[@MorganWolf13]

Not sure if anyone else has posted about this, but if you are having trouble changing the dates from the European model to the United States model, what you'll want to do is go to File --> Spreadsheet Settings --> under General look for Local and change it from United Kingdom to United States.

[@juliafogleman198]

Thanks for the tip! I was struggling to change it but this worked perfectly!

[@giuliageller7217]

“ You should not waste time on books you don’t want to read” PREACH! It feels so good to let a book, you do not like, go. ALSO...Thank you for putting so much effort in every Project you do, may it be TBRVATAR , Readalongs or the Spreadsheets. I truly love everything you do on this channel Lots of love from Germany

[@Val13012]

Pre-school trials: life will only get worse. I'm screaming at your fake book names! 🤣

[@BookRoast]

😂😂

[@dav9879]

You give us content humanity doesnt deserve. I love it!

[@iammoptimusprime]

Last year the Cawpile spreadsheet helped me so much because I struggle with star ratings and being stuck between different ratings and the spreadsheet made it so much easier. And I'm loving the V2 Plus version, I can't wait to start using it! Thank you for the work you put into making it, I can't imagine it was easy!

[@oliviareadsalatte]

awh heeeeeell yes 🙌🏼 I’m absolutely in love with your rating system and to find there’s an Extended Edition?! Perfection.

[@BookRoast]

😂🥰🥰🥰

[@BooksToAshes]

I'm horrible at committing to things, but I'm going to try doing this because it looks really fun! (As long as I don't procrastinate doing it)

[@BookRoast]

I feel you, it can seem daunting but it’s fun seeing the stats fill in 😂

[@baddiemoyd]

I used your Cawpile Spreadsheet all of last year, it was so so incredibly helpful, I can't imagine not using it! I wasn't expecting an update, this is so exciting!!!!

[@brachydiosmio]

I've just popped in from Jadeyraereads' new video and am absolutely in love with your rating system! I tested it out with some of my recent reads, and got... the exact same star rating I gave them originally. Magic. 🤯 I've always been a person who finds it difficult to articulate WHY I felt a certain way about a book, and just looking at everything divided up into CAWPILE makes it so much easier to put into words. Thank you so much for sharing this with us & all the hard work you put into the spreadsheet!! Really looking forward to your future videos!

[@marta.r.correia]

The time and care put in these spreadsheets is amazing! Thank you so much G!!! 💛To be honest, last year I only kept track of my reading using CAWPILE until July, then life got busier and I just kept forgetting to fill in the data as I finished the books, the same happened with my reading journal... I'll try again this year! One thing I added in mine was "Hours read", instead of pages, for the audiobooks, I would calculate the "hours of the audiobook/the speed I listened" (like: 6/1.5) so it would track the hours I actually listened and I also made a graph for it in the stats sheet. Again, amazing work, thank you so much! 🥰

[@thebookdreamersalley]

Since I first discovered your channel, I've been wondering if there could be anybody as organised and brilliant as you! Thank you so much. X

[@mir2079]

I absolutely loved using CAWPILE last year and I'm so excited to use the new version this year!!!! Thank you so so much for making and providing this

[@weslynrae]

I love the CAWPILE system so much. I started using it for the first time last year and it has been an absolute dream. I did make a few minor changes to it as the year went by, but thanks to all the work you put into it I was able to modify it easily. Thank you so much for sharing this with us all.

[@martynabrzostek9300]

Thank you so much for this new spreadsheet! I highly enjoyed using the previous one last year, so I'm very excited about this new one. It's so nice to see that there are more booknerds in the world, who care about that detailed bookish stuff and tracking it ;)

[@shadowkissedreader1698]

I adore CAWPILE. Its my 2nd official year using it. Can't wait to use the plus version. Thankyou so much for all the time, energy and creativity you put into it. Your amazing!!!

[@IHeartsGardeners]

This is AMAZING. I was so excited to find CAWPILE last year and it really helps me think critically about the ambiguity of star rating and write better reviews overall. Also, the series tracking..... I really need this in my life. My New Year's resolution is to finish even half of the series I started in 2020 😂 Thank you for all the hard work and love put into this and the beautifully straightforward tutorial.

[@autumnwonderland8863]

Perfect timing cause I was about to start using the Cawpile spread sheet from Your Last video😅 I also really love the changes you impemented, I can’t wait to start using it💖

[@brandonalexandery7498]

How is that possible that I’ve just found about a world of spreadsheets for bookish people a day ago? I didn’t think people were as intense with books as me to do these kind of things ! I Love it ! I’m using this right now! Thank u, you’re awesome 👏🏼

[@evireadsbooks5746]

I love using the CAWPILE rating system. The spreadsheet looks so pretty! And usefull. Thank you for all the effort you put in making this.

[@AMilli0NliGHTS]

Oh my goodness, I love this so much! I've already used it for my first book of 2021 and it made me so much more thoughtful with my rating. Thank you, G!

[@ooomar2689]

I started using CAWPILE last year with your spread and it made rating so much easier because I could organize my thoughts and feelings into the categories. I also noticed that because I was not giving half stars I had with be honest with how I felt about the book, which helped a lot at the end of 2020 when I chose my favorites of the year

[@unadelocura]

Thanks for taking the time to create and upload this for us, G!! Really excited about the DNF and actual read pages stats 💜

[@BookRoast]

Thank you! I’m really hyped for those too!

[@niniebou]

I was going to use this for the first time this year so thank you so much for the updated version!

[@jelke2621]

You really out-did yourself, G 🥺 I love it!! So excited to start using the new version 💙

[@isabellaward7602]

THANK YOU SO MUCH FOR DOING THIS!!! I have been looking for some way to track my reading that isn't goodreads for years and this is perfect!!! Thank you fo sharing this and all the effort you put in!!!!! I can't wait to start using it!! It looks like perfection!!!! 💖💖💖💖💖

[@florence4557]

you surprise me more and more! I'm so grateful for how much you invest your time into this community .

[@TanteMiiLie]

Thank you so much for sharing this with us once again 😭 I really love the new additions to the Plus version!

[@Sharie-]

Thank you so much G! I've been using CAWPILE since you 1st introduced it (without excel sheet) and now this spreadsheet. Great additions! Good job! ^_^

[@jennsbookshelf_]

G THIS WAS FABULOUS!!!! I am so excited to use this spreadsheet this year. you do so much for this community

[@aliceborry3753]

I used the spreadsheet last year, it helped me know more about my reading habits (and it's so satisfying seeing this long list of books at the end of the year haha) so thank you a lot ! I will definitely use the "plus" version this year. I will add a column to see how much money I save each time I don't buy a book, as I did last year. It helped a lot to have more control on how much money I spend on books.

[@dwoodw6990]

Thank you so much for the update to CAWPILE. I used the spreadsheet last year and am looking forward to using the new additions this year. You are an amazing human for putting this together and sharing with all us book lovers! (If I could just get the dates to switch to American I'd be set. It will switch for one book and then not for the others. lol)

[@Sarah-tf7yv]

my nerd heart is soaring right now! 😍 thank you so much for creating this!!! i appreciate all the effort you put into making this for everyone's use. 📊 i can't wait to start using this!!!😊

[@Nyxix_]

I'm excited to use this newer version. I only started using the CAWPILE rating system last year and I love it. I really enjoy seeing the end of year stats from all the books I've read. Thank you so much for all the work you put into making this! 💜📊

[@Reading_in_pink]

Love a good visualiser spreadsheet! Thanks G

[@Pagesforwings]

Thank you so much for making and sharing this!! I am so excited about the new categories (especially the series part) and how colorful it is!

[@wordsinember]

Oh, I've been waiting impatiently for this video and the new spreadsheet to be online. I used CAWPILE last year and it really did help me with rating my readings. Thanks for all the effort you put in this, G. 💖

[@BookStuffWithIzzyK]

Thanks again for this system! I found it a couple months ago and completely went back through my books read over the awful year that is never to be named again, critically thinking about each book. I compared the rating CAWPILE gave me with what I gut rated them and it was such a relief! So many of my truly enjoyed 4-5 stars kept their rating, while upon reflection, many books that I didn’t enjoy as much or simply ground through for sake of series dropped in score, as they should. Using your system made me feel much better about the star ratings I give. It no longer feels arbitrary. I feel like the books deserve the stars I ultimately gave them and let’s face it: not everything is a 5 star and I was handing those out like candy on Halloween. I want to be more intentional. Which leads me to another wonderful thing your system did for me: it helped me realize that I was reading a lot of white chicks that write fantasy. That sounds bad, but it was the truth. It prompted me to join a reading challenge that is designed to broaden my horizons in authors, genres and subjects. So again: Thank You! I had downloaded the spreadsheet to use on my computer with Excel and actually broke the stats page by doing it, lol, but doing that also helped get me back into coding, trying to recreate charts that suited my wants, and let me add in category columns and other charts, much like what you’ve added for the CAWPILE Plus with categories from your other viewers that I hadn’t thought of. This has been a wonderful tool for my #ReaderLife and I thank you from the bottom of my heart. I don’t want to imagine going back to a life of reading without this in it. ❤️

[@daphneseguin4933]

love, love, love the new additions can't believe how hard you worked on this!! it's beautiful and so usefull! my inner leslie knope is so grateful to you 💜

[@adele5909]

I love the new CAWPILE😍 I had great time filling the first one❤️Definitely will be using the plus version! Thank you for doing this for us❤️

[@carolinegrd1297]

G this is fantastic! Thank you so much 🥰🥰 Also I just rewatched the first CAWPILE video, it’s so funny seeing cute baby G! 😄

[@thelittlefriend]

These fake book names are honestly SO funny! Love this spreadsheet, makes me want to read even more!

[@beastsbooksandbeauty9136]

I have just downloaded the spreadsheet - its fab! I'm boring and have decided on the basics V2 but love how mindful it makes me on reviewing. I ran a few of my recent reads through from last year to compare to my 'gut feeling' ratings which was interesting too. Definitely going to use this from now on - so glad I found your channel x

[@booknerdnova3151]

I didn't know you could make the CAWPILE even more useful to me than it was last year! This is perfect! Last year CAWPILE showed me how bad I was doing when it came to reading books by BIPOC authors, and it kept me accountable for the rest of the year. I got it down from 89.7% white authors to 74.5%, and I'm hoping that trend will continue. I love the inclusion of the lgbtqia+ columns, and the author's country one, because that last one will help me in my quest to read from more countries. So thank you G, for your hard work.

[@adventuresofsnow1660]

This is amazing, G! I am so excited at the prospect of starting the year off with this and cannot wait to start popping in my current reads. Thank you so much for setting this up and I hope you know how much you are appreciated! Also, I do believe I'll be subscribing to skillshare and signing up to your instruction videos. Your teaching style is on point!

[@accioali1825]

Yaaaaaaaas my love! I adore the additions and the updates! 💕

[@Mothebookdragon]

Oh my goodness! I loved the CAWPILE last year, but I absolutely love this. You included so many things I wanted! Thank you so much for taking your time to create this. I know you do it for yourself, but it is greatly appreciated by me. I am so excited!

[@briek9482]

You are a gift to humanity ❤ Update I just got mine set up for 2021 and now i cant live with out it. This is amazing thank you so much!

[@calathmann]

I love using CAWPILE! It makes rating books so much easier, thank you for creating this!💕

[@datcapa]

Watching your videos not only motivates me to read, but also motivates me to do homework. Idk how, but it works lol

[@Ireku25]

Thank you so much for putting so much effort into this!!!! I'll be using the plus one this year!!!!! Last year the system helped me a lot to keep track of my reading a give ratings!!!

[@KayBethBookish]

I've used CAWPILE for nearly two years and this new sheet makes my heart so happy! I spent three hours yesterday trying to create my own sheet to include elements I felt were missing and just couldn't do it so this will be a literal life saver. Thank you, G!!!

[@ariascarlet7736]

OMG! This is amazing! I'm learning to use excel in a more professional way for my job and I'm amazed about your work! And the fact that you share this with us is just sooo amazingly sweet and generous. Thank you! I hope you have a great year ❤

[@ChelseaZhao]

I used CAWPILE in 2020 and really enjoyed it! I love the new additions! Thank you so much for this!

[@carissareads2496]

So excited that there's an updated version!

[@francisw344]

G, let me just say...holy shit. Like, honestly. You put so much efcort into the things you do for us 💜 I cannot wait to use this!

[@HorsesofthePiano]

Aaaahhh!! Amazing as always!!! I'm really looking forward to using the new version! I really really enjoyed using it this past year

[@professordekarios]

i just tried to rearrange cawpile to reflect how the books affect my mental health and how that affects my rating, but this plus version looks so much better to do that with!! i also love how the star colors are giving bi energy 💖

[@BookRoast]

Hehe you know it! 😂✌️ 🏳️‍🌈

[@lazyhomebody1356]

Everybody do your part to fly the flag!!

[@thebookwitch5575]

I didn’t realise you made CAWPILE!!! I thought it was like a real thing that you just followed, that’s actually amazing!!! 😍

[@BookRoast]

Omg that’s oddly flattering! 😂😂💜💜

[@SMsmith987]

Omg I'm in love! I used a slightly altered version of the CAWPILE sheet last year but this one is amazingly better! My statistician self is so happy 😁 Thank you for sharing this with us! ❤️

[@EmilyJeanBlatt]

The CAWPILE is so helpful!! I appreciate you sharing!! I always just reviewed based on a whim and I was looking for a better rating system and tracking system and you provided it all here :) You're the best.

[@kiara9538]

This is amazing! I used the first spreadsheet all throughout 2020 and absolutely loved it. And I know I'm gonna love the plus version even more. I'm a sucker for all kinds of stats so this heaven for me, haha. Thank you so muchbfor doing this, G!

[@paginator]

Thank you for the spreadsheet! You put so much work into doing nice things for your viewers. 💜

[@bmaddog4]

I’m fairly new to your channel and I have to say, I am super impressed with the amount of effort you put into this. It takes my breath away. Also, I think it’s amazing that you share this (and your TBRVATAR) with all of us. Thank you so much, I will be using both ❤️

[@lazyhomebody1356]

I love your pfp

[@xidera11]

Wow, I’m definitely going to try this. Such a great job you’ve done ❤️! Also “stone tablet” makes my day 🤣

[@bookscoffeewithromie]

thank you so much for all the work you put into this! i'd been meaning to use the cawpile for a while and seeing everything you added was the push i needed! i'm excited to start using it!

[@Soolepoh]

First of all want to say that hearing your voice really calmed me down and cheered me up. Thanks G 💗 I hope to use CAWPILE this year cause I love statistics hehehe

[@daniellehinton9607]

Thanks so much for this update, G!!! Love using CAWPILE!!! ❤️❤️

[@fionadonohue572]

I loved using the CAWPILE sheet this year and I will be downloading this ASAP! It's going to be really good to use this year.

[@jennawar13]

Yay! I wasn't sure if you were doing this, but I moved my 1 book from last year's doc (lol) to this one for 2021! After customizing it of course. I love how easy you make it for us! Thank you!

[@liveathousandlives9915]

You are so incredible! Thank you for all your hard work and for being will to share this with all of us! You are such a blessing!

[@thatoneguylogan6130]

This is gonna make my wrap ups and finding what I like so much easier. I really appreciate that you made this then made it for public use

[@alphabettiispaghetti5380]

I think it could be useful to have a 'translated' section near the language bit, and what language it is translated from. As someone who can only read English, translated works are the best way to read from other countries and expand my world-view of books!

[@idokken]

I absolutely love this system, and have been using the previous version for all of 2020! Thank you so much for sharing this with us!

[@BookRoast]

So glad you like it! I’m not quite sure what stat you mean, could you clarify? I’m just curious 😅 the pie chart for that column is in the stats section under “how you got it” but I’m not sure if you mean something else? ❤️

[@idokken]

@@BookRoast omg hahhah I can’t believe I didn’t see it!😂 Thank you again for the amazing work❤️

[@sarap8003]

Just discovered this and absolutely in love! Thank you SO SO much! I'm definitely going to use it as my book log for this year 💖 I think it could be useful to add hours count for audiobooks too with the total hours listened. This would be PERFECTION ! Sending warm winter wishes from Italy!

[@ke_nickie]

ahhh this is amazing, G!! I love the categories you added 🥰🤓📊

[@lisagna7234]

I love the new spreadsheet! I loved using the old one all throughout 2020 and the new one will be even more helpful

[@catharinel07]

Thank you!!!! I’ve been looking for a good tracking system for me for months. I’m so excited about this I feel like it’s really going to motivate me to read more

[@MoneBoomx3]

2020 was the first full year I used your CAWPILE rating system and I love it 😍 I wanted to download it in 2019 but I wasn't able to use it bc of my laptop. So I used it in my book journal the past 1+ year :) However, I bought myself a new tablet (it should arrive next week 😍) and I hope I can download and use the online and advanced version of this amazing rating system 😌 Thank you soooo much for doing this! You are truly amazing 💕

[@tatireadsbooks8115]

I was honestly about to make a copy of the other CAWPILE spreadsheet cause used it all throughout last year and loved it! thank you so much for always going above and beyond, you are such an inspiration, thank you for all that you do!!

[@MarinaUz]

This is amazing! I have been using version 1 through out 2020 and I loved it. This looks so much fun, I'm excited to start using it! Thank you G ❤️

[@mybookishdelights4767]

Thank you so much for doing this! I loved using your previous one and I will definitely be using the Plus version this year!

[@zephmorningstar2099]

This covers so much, I'm very impressed. I recently started journaling my book reviews. I have often found myself drawing a blank if I don't have pre-planned prompts. So I might have to use your spreadsheet for inspiration. Thanks so much for sharing.

[@stellataneva7012]

Girl, you're not crazy, you are Amazing! ❤️Thank you for everything!❤️

[@mitalirajput3004]

Thank you so much. I can’t wait to use this especially because I really liked using it last year.

[@jwinkies3011]

Ahhh this is so good! Thank you so much G, I can't wait to start using your new version!

[@fla6652]

I loved using cawpile in 2020 and I am already loving the plus version!

[@judithcakelover]

Thank you! ❤ Just what I needed! And just love "The Plus" version. 😁

[@justinem2810]

I've been using CAWPILE for a few months and I really love it Thank you ❤️ And happy new year ! ✨

[@BookRoast]

Happy New Year! ✨

[@jordanmoore8210]

Yay!! I used this all last year and it was perfect! I am so excited to use this more intense version!

[@lindsaylexii5283]

I'm gonna give this a go this year! Thank you so much for your time making this and perfecting/updating it. ☺️♥️ Also I know numbers are not that important, but I can't wait till KZbin will make your channel grow, you deserve it so much, you put in so much hard work!!

[@BookRoast]

Thank you so much 🥺

[@gaara0gaara0]

I really loved this speadsheet last year, and I was using it again for this year (now i will use this one) I did end up changing some colours, columms and graphics styles that I did't use. So you still can adapt it to your liking. Thanks a lot for the new changes.

[@MaryJoHeadrick]

I love CAWPILE as a rating system!! It has helped me maintain consistencies during my reviewing process. I've even adapted it to work for nonfiction, which has been helpful. All that to say, this system has been so, so helpful for me.

[@draigrhosynreads3450]

Youda best!! I loved CAWPILE V1 it was great to track my 2020 reads. I used it from July and I’m so glad you made a V2🤗 that I can use for fresh for 2021

[@Jadeyraereads]

Loooooving the additions! You always do so much

[@RKStumblingbear]

I'm so excited the new version is live. I really enjoyed using this last year. The changes look interesting!

[@floreh.8260]

Having heard so much about this, I will give it a go this year! It will help me for sure! Thank you!!

[@AlyssaReids]

That's so cool that you made this. I can see a lot of people using this. Thanks for providing this resource. 🙂

[@BookRoast]

Pleasure ✨✨

[@kbyt85]

I’m going to start using this immediately! Thanks so much for the video and for sharing this - it clearly took you time to set up and it’s very much appreciated!