Using Sheets to organize my reading effort

It is a truth universally acknowledged and known that Suchita Agarwal uses a Google sheet to organize her reading efforts. But, why and how that began is a story she would like to tell you today.

I have a lot of thoughts when it comes to the books that I read but I dislike sharing those thoughts publicly. My favourite nightmare is I will say something semi-critical of a book and the author will read it, despite my not using any trackable hashtags or tags or mentions, and then theyโ€™ll feel bad. Yes, I have given too much power to myself and not enough good sense to them. Here we are nonetheless.    

Sometime in 2017, I read a string of books that made my blood boil and I had to find an outlet for it. I opened a Word Document but I was so angry, I could only write 3 lines to encompass my disappointment with a highly anticipated book. Seeing those 3 lines in an otherwise empty document was even more irritating so I opened a Google sheet. I thought this way, Iโ€™ll be able to access the sheet from my phone too and if through the day, I had more thoughts, I could easily add it.

That is how my sheet โ€“ Books Read โ€“ was born. It now has 7 yearsโ€™ worth of data in it. For some entries, there are essays (like Metamorphosis or the Divine Comedy) and for some, there are not even two lines because they failed to engage me that spectacularly.

Using Sheets to organize my reading effort
What my sheet looks like

Itโ€™s a fun thing for me to do and here Iโ€™m going to tell you how it has helped me in my reading journey:

  1. I was going through a phase where I wasnโ€™t reading much. Seeing so few entries in my sheet reminded me I needed to focus more on reading and less on binge watching Netflix shows.
  2. It helped me compare different reads from my list that ultimately makes me a better reader and writer. It has also sharpened my storytelling skills.
  3. At one point, I thought I was spending too much on books so it served as an expense account as well. At the end of the year, I added the cost (yes, sometimes I use sheets for their intended purpose i.e. crunching data) and had a fair understanding of how much budget I needed to park next year for book-purchasing expenses.
  4. In 2022 I realized I hadnโ€™t read a lot of Indian authors in 2021 so the sheet became an easy way to ensure that I would read more desi books.
  5. Similarly, in 2021 I realized I had read less fantasy books in 2020 so I added a column for genre to remedy that.
  6. This year, because I have devised a rating system, I have a column for that. It helps me to filter out books as per the ratings and see if thereโ€™s a pattern that emerges in similarly rated books. I use this pattern to see if a book should be added to my TBR.
  7. Sometimes reading my thoughts makes me want to reread a book. Like this year I reread The Song of Achilles and next year, I may reread The Sense of an Ending.
  8. Sometimes, when someone talks about a book I have read, I go back to my sheet to refresh what I had thought and compare it to their thoughts. Seeing someone elseโ€™s perspective always gives me a kick.

What new column will I add in 2024? Maybe a means to organize my KU reads? Maybe Iโ€™ll join a book challenge and Iโ€™ll have to add prompts โ€“ who knows?

All the above may sound like I take my reading too seriously but this is actually fun for me. There is nothing more relaxing than being able to admire my sheet at the end of the year and revisit previously read books through the thoughts I have written.

Do you have special place where you save your thoughts on the books you read?


This post is part of Bookish League blog hop hosted by Bohemian Bibliophile.

Header image: Photo by Ylanite Koppens

36 responses to “Using Sheets to organize my reading effort”

  1. Quite a novel idea. I might give it a shot next year.

    Liked by 1 person

    1. That’s great! I hope it helps ๐Ÿ™‚

      Like

  2. Prasanna Raghavan Avatar
    Prasanna Raghavan

    Once a teacher is always a teacher– after she has retired too. I summarised everything using tables arranged along horizontal and vertical planes, but I never used that when reading books. Suchita, thanks a lot for putting me back into that system. Now, I have to dig deep into how many books I read a particular year and my reactions to them; all those got erased from my memory, but I can still try. ๐Ÿ™‚

    Liked by 1 person

    1. Thank you so much. You can start with 2024 and build it from there too ๐Ÿ˜Š

      Like

  3. Chandra Sundeep Avatar
    Chandra Sundeep

    I too use Sheets to track my reading. Watching those rows and columns come to life is so satisfying!!

    Liked by 1 person

    1. Absolutely ๐Ÿ˜

      Like

  4. We are kindred spirits, Suchita. I hear you about sharing reviews of books I didn’t like. Exactly the reason why I avoid negative reviews unless they need to be called out. I had a Doc file before I got Kal’s spreadsheet. Tweaked it a bit for a mini-review now.

    Liked by 1 person

    1. True. I have also realized just how subjective reading is so I’m even more wary of reviewing books I do not like.

      Liked by 1 person

  5. Oh this sounds so cool. And you are so organized. I am not that organized but yes, I write down my reading list: English and Hindi separately. Like books that I want to buy, books to read first. I remove the books from the list if I have read it or left it unfinished.

    Liked by 1 person

    1. I’m going to experiment with reading lists this year ๐Ÿ˜€ thank you!

      Like

  6. Oh wow, having 7 years of data is indeed amazing.
    I track most of my reading and blogging through Kal (a fellow book blogger and friend) ‘s free spreadsheet which is very thorough. I’ve been using it for the past few years and I tend to put small thoughts in the notes section there and for more thoughts I either put them on the Goodreads or start drafting a review post. But the spreadhseet is really where itrack my purchases and reading tendencies so I agree, excel sheets are definitely the wya to go!

    Liked by 1 person

    1. That’s amazing to know Charvi! I love the flexibility of sheets too – you can make them as complex or as easy as you want ๐Ÿ™‚

      Liked by 1 person

  7. Impressive system! Your detailed Google sheet approach not only serves as a comprehensive record of your reading journey but also provides insightful reflections. The way you’ve adapted and expanded it over the years, incorporating genres, expenses, and ratings, showcases a thoughtful and organized approach to your reading habits. It’s fascinating to see how such a personal tracking system can enhance the reading experience. ๐Ÿ“š

    Liked by 1 person

    1. Great question to ponder. For me, it has improved my reading speed and I can take an educated guess now if I’ll like or dislike a book.

      Like

  8. Preeti Chauhan Avatar
    Preeti Chauhan

    Excel and Google sheets made things very much organized so why not use it to keep reading stats and book specs organized, it is a sensible decision and one that appeals to me. If only I had been reading as much to need an organizer!

    Liked by 1 person

    1. Haha you can organize how many ever books you read ๐Ÿ˜€ that’s the beauty of the system. You decide.

      Like

  9. This post made me smile!! I used to note my reading lists, TBRs and challenges in Excel too … have done it for 5 years or so. Have an Excel of all my Physical and Kindle Books too. Your sheet is more comprehensive as you share your thoughts about the book too, I mentioned the ratings only.
    You may check a part of my Excel in this post… https://shilpaagarg.com/2020/04/create-organize-tbr.html

    Liked by 1 person

    1. Your excel looks wonderful! And all that data would be such a boon. I always find it very satisfying to see my excel at the end of the year ๐Ÿ™‚

      Like

  10. Oh this is so organised, Suchita.
    You should have seen me scrambling yesterday, trying to remember the books I had read in 2023 for the TBR Challenge. I can now hear you in my mind “see if you had used google sheets like me…”
    So I guess it is time for me to start using them,at least for the prompt based challenges I am doing this year, plus I learnt how to use google sheets this year( yup am a tech dino), so better start practicing it

    Liked by 1 person

    1. Perfect way to practice something ๐Ÿ˜„๐Ÿ‘๐Ÿป

      Like

  11. Suchita keeping everything aside, I want to say what an interesting person you are dear. Not for books but for many other things I am very systematic in life. Love to know about you are your practices in life. God bless you dear

    Liked by 1 person

    1. Awe that’s such a sweet thing to say. Thank you Samata ๐Ÿ’™

      Like

  12. How interesting, Suchita, especially how you keep adding to your tracker every year! Personally, Iโ€™m not a fan of Sheets; I use Notion instead. I like the idea of adding brief notes about the books, maybe Iโ€™ll add that in next year!

    Liked by 1 person

    1. Notion looks like such a cool tool. Hey with tools whatever works best, isn’t it ๐Ÿ˜€ thank you!

      Like

  13. I am so lost with Excel! I would have to take a class in it before going on with it, I love to make handwritten notes, they never survive though, unlike sheets.

    Liked by 1 person

    1. That’s why I love sheets โค

      Liked by 1 person

  14. I love the idea of keeping a Google Sheet to express my feelings in just one word about the book. as you said sometimes its hard to explain feelings elaborately. I will start this on 2024.

    Liked by 1 person

    1. Oh how cool! Would love to know your experience of it too ๐Ÿ™‚

      Like

  15. You make me want to start making my own Google sheet. I absolutely love the idea. This year I started writing out my thoughts long hand in a notepad even as I read the book. However the whole thing remains completely disorganised.

    Liked by 1 person

    1. I’m a big believer of organizing everything ๐Ÿ˜€ I hope you start your sheet and have fun with it!

      Liked by 1 person

  16. Having a google sheets for your reading sounds cool ๐Ÿ™‚

    Liked by 1 person

    1. Thanks Swati!

      Liked by 1 person

  17. My favourite nightmare
    That oxymoron had me laughing till the end of this piece. Also, the eighth point, “Sometimes, when someone talks about a book I have read, I go back to my sheet to refresh what I had thought and compare it to their thoughts. Seeing someone elseโ€™s perspective always gives me a kick.” is totally relatable ๐Ÿ™Œ๐Ÿป in my case I go back to my review post though ๐Ÿ˜„
    My special place where I save my thoughts are in the book highlights (I mostly read eBooks so this is quite easy) and in my review posts

    Liked by 1 person

    1. Yessss I love highlighting paras too โค

      Liked by 1 person

  18. Interesting to meet a person who is so systematic about reading.

    Liked by 2 people

    1. Haha thank you!

      Liked by 1 person

Leave a reply to Samata Cancel reply