Why and how to track your reading
I first began tracking my reading a few years out of college. I am a huge fan of re-reading but I came to realize that I was almost only re-reading. I was in a disappointing job, and my best comfort was to sink into a familiar book. So I did it alot. Jane Austen, L. M. Montgomery, and Louisa May Alcott were the most often read. I didn't think that this was altogether a bad thing. They're great books! I always felt uplifted... until I finally understood that it was a crutch. I think it sunk in when I picked up my collected works of Jane Austen to read something, but I'd just read all of them.
I knew that there was a whole library nearby full of new books (or new to me). I also had several books on my shelves that I'd brought home and never read. So, I decided to write down every book that I read. And limit myself to going through Jane Austen once a year. (Maybe twice if I really needed it.) I just wrote down the month and year, and listed titles and authors. From time to time I'd flip through it and laugh at how often I'd still re-read the old favorites, plus Lord of the Rings and Harry Potter, which I went through about once a year then. I began to make some headway into my own book hoard, and read more widely.
This was about the time I started to use spreadsheets for work, and when I got used to them, I loved them. I have a zillion spreadsheets. It started with a home budget, and now anytime I want a list, I make a spreadsheet for it. So, my hand-written list has become a spreadsheet. I've made improvements, and I think it's really useful, so I'm sharing it.
I have a tab at the beginning with some general information and instructions.
I track the author and title, of course, the month I started and finished, year published, why I'm reading it, and genre. Some of these are in drop-down lists that you could easily change. Or you could add more. Some things that you might want to track:
time spent on the book
who recommended it
your own rating system
In the why column, you could add school or book club. It's really easy, and if you don't know how to change the lists, the instructions cover it.
If you decide to use my reading tracker, I hope that you enjoy it as much as I do. The last field is notes, and I really enjoy stopping to write a short statement about the book. Plus, then I have notes ready if I want to write a review for storygraph.