{"id":137162,"date":"2025-03-16T10:39:30","date_gmt":"2025-03-16T10:39:30","guid":{"rendered":"https:\/\/peraltafinancing.com\/entertainment\/books\/why-i-track-my-reading-on-spreadsheets-modern-mrs-darcy\/"},"modified":"2025-03-16T10:39:30","modified_gmt":"2025-03-16T10:39:30","slug":"why-i-track-my-reading-on-spreadsheets-modern-mrs-darcy","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=137162","title":{"rendered":"Why I track my reading on spreadsheets \u2013 Modern Mrs Darcy"},"content":{"rendered":"


\n<\/p>\n

\n\t\t\t\t\t<\/p>\n

Anne and the team refer to me as the \u201cspreadsheet queen.\u201d That\u2019s partially because I do some metrics reporting for Modern Mrs Darcy but also because I use spreadsheets for everything<\/em>. However, I didn\u2019t start tracking my reading via spreadsheets until 2018, all thanks to a Modern Mrs Darcy Book Club class.<\/p>\n

Book Journaling Inspiration<\/h2>\n

In 2018, Anne led a class called Book Journaling for Book Lovers<\/a><\/em><\/strong> (which I continue to rewatch) for MMD Book Club. She shared her straightforward method of writing down the books she wanted to read and then noting when she finished them. She also talked about writing down the recommendation source of where you first heard about a book so you can start to learn over time what your best sources are. She also shared some favorite supplies like pens and highlighters<\/a><\/strong>, which is one of my favorite topics.<\/p>\n

I almost started a reading journal after watching this class but the more I thought about it, the more I realized a spreadsheet would work better for me, mainly for the following two reasons:<\/p>\n

    \n
  1. I could continue to add books to the spreadsheet over the years so I\u2019d have one big, easily searchable, document where I could sort and filter data however I wanted.<\/li>\n
  2. I could use the spreadsheet to come up with some pretty charts and graphs at the end of the year, including year over year views. <\/li>\n<\/ol>\n

    Here are a couple of examples\u2026<\/p>\n

    \"\"\"\"<\/figure>\n
    \"\"\"\"<\/figure>\n

    Favorite Data I Track<\/h2>\n

    Here are some examples of reading data I track in my spreadsheet\u2026<\/p>\n

      \n
    1. Source<\/em><\/strong>: As noted above, this was Anne\u2019s tip from the class and it\u2019s helped me to figure out what the best recommendation sources are for me. There\u2019s also been a delightful side benefit. One of my favorite things about the MMD Book Club is checking out the forum called Reading This Week<\/a><\/strong>. I get SO many great recommendations there. When I add a book to my TBR, I note the source and once I\u2019ve read (and often loved) the book, I send the recommender a direct message on the Book Club member site thanking them. This has started many wonderful conversations!<\/li>\n
    2. Tropes<\/em><\/strong>: This is a new category for my tracking. It\u2019s easy to identify the trope for some genres like romance (enemies to lovers, second chance love, fake relationship) and mystery (amateur sleuth, police procedural, locked room). It\u2019s been fun trying to identify themes in other genres like multiple timelines, hero\u2019s journey, magical realism, family drama, and more. I can\u2019t wait until the end of the year when I can put together a chart showing which tropes had the highest star ratings!<\/li>\n
    3. Publishing Imprint<\/em><\/strong>: I make sure to note the specific publishing imprint so that I can see patterns of which are my favorites. For example, I won\u2019t list Simon & Schuster, which is the parent company; instead I note the division\/imprint like Atria, Avid Reader Press, or Gallery. I also include this information when I add a book to my TBR because I definitely have some favorite imprints at this point, which helps me in deciding what to read next. Some of my favorites are Minotaur, Pamela Dorman Books, Riverhead, Flatiron, and Entangled: Red Tower.<\/li>\n<\/ol>\n

      How to Get Started<\/h2>\n
        \n
      1. First, think about whether a spreadsheet, journal, or an app like The Storygraph<\/a><\/strong> is right for you. (I actually use all three!) A few questions to ask yourself are: do you like to customize what data you track? Do you like to see metrics and charts or do you prefer to write out reviews? Do you want to be able to easily search what you\u2019ve read in the past or is that not a priority?<\/li>\n
      2. Second, if you decide you want to give spreadsheets a try, I think the easiest thing to do is to search on Etsy for \u201creading tracker\u201d<\/a><\/strong> and pick a Google Doc template that works for you. I use this spreadsheet from creator With Ali<\/a><\/strong>.<\/li>\n<\/ol>\n

        Tracking my reading on a spreadsheet brings me both a lot of joy, as well as many insights into my reading. I will be forever grateful that the MMD Book Club<\/a><\/strong> inspired me to start this practice!<\/p>\n

        Do you track your reading? Are you a spreadsheet aficionado? Please share in the comments.<\/em><\/strong><\/p>\n

        P.S. Why star ratings matter\u2014and when they don\u2019t<\/strong><\/a> and Book journaling tools for every reader<\/a>.<\/strong><\/p>\n

        About the author<\/h2>\n
        \n
        \n
        \"\"\"\"<\/figure>\n<\/div>\n
        \n

        Donna Hetchler<\/strong> helps out with our numbers, keeping a high level view of the business. Her go-to genre is mystery. You can find Donna on Instagram @dhetch<\/a>.<\/p>\n<\/div>\n<\/div><\/div>\n