#reading spreadsheet

[agardenandlibrary]

an update to this post about my reading spreadsheet!

It's been 2 years-ish since I made the spreadsheet. When I started, I only had a couple of years of data. But I eventually went back and added everything back to 2015, which is when I started to track my reading (that may also be around the time that I started this blog)(yep, just checked, my first post was April 21, 2015, and April 2015 is when my reading tracking took off. I backdated a few things to Feb. 2015, but the most reliable data I'd say is from April 2015 on)

Columns now include:

episode #, date episode aired, date read, Title, Author, m/f author, poc, nationality, series, genre, comment, year published, decade published, page count.

I want to rethink the "comment" column, maybe? I don't find a star-rating system useful, but I don't find a one-word comment very useful either.

And I just added a "Recommend" page! Still figuring out what information I want in here, but here's the idea so far:

Title, author, genre, and why I'd recommend it.

I'm thinking of adding back in a column for whether it's a series or not, since I personally find that to be useful information.

I also have separate sheets in the spreadsheet for each year! When I have time, it's fun to go and build charts to see trends across the years.

Charts under the cut:

So I can see in 2015 half of the books I read were young adult (31 out of 62):

but in 2023, mostly I read Fantasy & science fiction, and only 14 of the 72 books I read were YA:

(I read 1 western in 2023! It was The Pits by Katy L. Wood)

in 2015 I mostly read recently published books, vs 2023 where I am INCHING TOWARD half books published since 2010 and half books published before 2010. (I started tracking decades in addition to years because it gives me a wider view. trying to build a chart with just years gives you SO MANY PIECES OF PIE, which I found overwhelming and unhelpful)

That's neat, I actually didn't realize how close I was to doing that! Even though it's still heavily skewed to newer books, I'm pretty happy with the spread! Especially when I can see how heavily weighted it was back when I started tracking.

Overall, I really enjoy the spreadsheet and maintaining thereof. If you don't want to bother building your own, just use StoryGraph and use their charts!

(if you made it this far, as a reward, you can find a blank template here. If you already track your reading somewhere, it may be easiest to download an excel file from there and just copy the information over and fill in what other information you want. that's what I did!)

[theblankgarden]

Notion template: reading tracker | book list

Notion template: reading tracker | book list

Hi, folks! I’ve created a Notion template to track my reading in 2021, and I’ve been using it in tandem with my reading spreadsheet & my book journal. I decided to make a simplified version of this template to share with you 🙂 To copy the template, go here: https://www.notion.so/theblankgarden/reading-tracker-template-1cdb4321dc984b059d9883b454931f51 You can find the template here, and I briefly…

View On WordPress

[asreadbydana]

Hello readers! My end of year posts/ statistics probably won’t be up until next week. I decided to revamp my spreadsheet and boy is it taking forever. But it looks so good! And it’s so comprehensive! So look forward to that! 

[backlogbooks]

New year, new reading spreadsheet! I'm keeping my tracker for library books I've read (and may add one for DNFs one I start DNFing things lol), and added a more detailed book buying spreadsheet. Since my goal is to read things within 1-2 months of buying/being gifted them, I've added columns for the date I get them and the date I read them. Books I've been gifted/otherwise got for free will live on the same sheet, just with no cost lol. And I've added a section for possible future purchases, to cut down on impulse buys! Which will be nice, because one of the purchases I've done so far (The Devourer by Alison Ames) was definitely an impulse purchase lol

I'm not doing another tbr tracking spreadsheet. I enjoyed it last year since I had a specific number goal (get my physical tbr down to 33 or fewer books), but from now on I'll be using storygraph's "tagging" function to keep track of my physical tbr. It's a lot easier to add books I've bought and remove books I've read so I know what I've got at any moment

[pdivaricata]

2019 was a bad year

I still have two weeks of mostly vacation and I think I can bump up the wordcount for 2023! I just downloaded 40+ fics and we'll see what I read over the next couple of weeks. Plus I have a couple of library books out. On the 31st, I'll make a "best of 2023" post.

[earlymoderngothic]

Hello, sorry to bother. If you haven't already, could you please make a post about how you do your reading spreadsheet? Thank you and happy new year 💓

Hi, anon! You're not bothering me at all.

It's been a while since I actually looked at the formulae and everything that I used because the spreadsheet is a couple of years old but I'll make a post about it soon. Have a wonderful day :)

[theblankgarden]

Free Printables & Reading Spreadsheet

Free Printables & Reading Spreadsheet

Hi, folks! This is yet another spring cleaning post! As I already mentioned, I decided to transfer some of my pages to regular posts.  Here, I will keep all printables designed by me (such as zines, spreadsheets, and journal templates) for you to download – for free. If you want, you can buy me a coffee in return, to support the blog – but you don’t need to. 🙂 I will add items and update this…

View On WordPress

[yes-the-country-bookworm-blog]

The Sunday Post: A Great Start to the New Year!

The Sunday Post: A Great Start to the New Year!

Happy Sunday! It’s time to link up to The Sunday Post and share what’s been going on, on an doff the blog, for the last week. I actually did not post one of these last week, so this will be to catch up on the first two weeks of the year. So far, 2016 has been amazing as far as reading goes. I’m already on my 5th book of the year. I downloaded the Ultimate Reading Spreadsheet from Book Riot and…

View On WordPress