Diving deep on a book project
No, not writing one. I just mean reading them. After my post about all my various projects, for some reason, I went down a rabbit hole for how I’m tracking books read, next in series, etc.
I tend to do “completion” binges of authors, aka “If I read one, then I want to read them all!” Way back when I was in my early teens, I had a small handwritten list of some titles (some of them came from Carolee as she wanted me to find Agatha Christie or Helen Macinnes titles at garage sales if I saw any!).
Then later, I had a double-sided list in 6-point font that I kept up to date until sometime in the early 2000s when my list of authors was way too large for 2 pages. Since then? I just look it up on the internet when I’m looking for the next read in a series. I’ve thought about a virtual list, but never really found a tool that I liked well enough to use, although to be honest, I’m realizing that is more about not knowing what information I want to keep vs. being simply too anal-retentive with my goals.
So, let’s back up a second. The “book” project has three components.
A. I want a list of books by author or series that I have read along with the list of ones that are to be read. A “status of completion” list, if you will. When I was only reading paper books, that wasn’t that difficult. I tended to buy them and read them, my backlog of TBR wasn’t that big, so I could basically “tick” the box when I bought it. It wasn’t that I had READ it, it was a purchase list. An inventory list rather than a to-do list.
B. When I read something, I like to write a book review. My book review process has been anal-retentive over the years, and it hinders me considerably in actually doing the review. My intent, when I started long ago, was to do them formally, not quite professional but more than the comments you see from most users. A bit of rigour, if you will. I made the review accessible — a blurb about the plot, what I liked, what I didn’t like, a final one-line conclusion, a rating, and some links and tags. Sounds simple enough, right? But then I would share it multiple places. Over the years, this included:
- Amazon.com
- Amazon.ca
- Good Reads
- Library Thing
- Chapters Indigo
- Kobo
- Barnes and Noble
- Google Books
- The Ottawa Public Library
- Savvy Reader
- Facebook forums for a book club with Savvy Reader (My book pledge)
- Facebook forum for my book club
- PolyWogg.ca
I feel like I missed a couple in there, but those are the obvious ones. Yet each of those sites, all 13 of them, tend to have slightly different layouts and formats. My site and Good Reads tend to have a very simple format, so I can use the same layout for both. Amazon (.com and .ca) plus Chapters, Kobo, Barnes and Noble (and Nook) have similar fields, albeit not in the same order so I have done those in batches. The Ottawa Public Library, Google books, and LibraryThing are relatively compatible so that was batch 3.
I would write the review in a Microsoft Excel template on a “writing” tab that would follow my PolyWogg.ca template pretty close (batch 1), but then I had a few other tabs that would take the info from that template, copy it to another format / layout for batch 2, and another for batch 3. I could therefore write it on the writing tab and it would autopopulate the other sheets. Then when I went to upload a review to the other sites, I could go to that sheet, copy and paste the layout with headings, and paste it into the review and press save. I have about 200 reviews across all the sites done that way. It works, it is “efficient” for process, and way back when I started all of this in the early 2000s, it made some sense to me.
If the first point of a review is to publish my thoughts, then the second point of a review is to help someone else decide if THEY would like the book too or not. And if so, then of course I should publish my reviews where readers are looking for reviews i.e., on those sites. Early on, I would get people interacting with me about the review, commenting on this or that, agreeing or disagreeing, etc. And on some of the sites, you would get a ranking of how many you had done and if people found them helpful. I liked that interaction. Most of the time, when I had read something, that was the end of it. Very few people read the books I read, so it was an informal way to have an ad hoc book club. But over the last 15 years, many of those sites have decreased interaction rather than increased it. Easier to manage the social media side if there isn’t direct interaction. If you see a review on Amazon, for example, all you can do now is say if it was helpful or report it. You can’t comment on it.
Which means, after that long summary, I am no longer getting much in the way of interaction on the books I review. It doesn’t help that I do a lot of backlist stuff too. If I was publishing a review of the latest book, it would get more traction on GoodReads for example. And, at the same time, I have my own book club that I run. Low intensity, sure, but if I want interaction on what I read, I just post there.
Why am I looking at this? Because I want to do more book reviews. I want to churn and burn and move on. Mostly I want to clear the freaking backlog of reviews too. And the current process has been WAY too anal-retentive. It not only collects info I don’t care about (why do I care who the ****ing publisher was????), and I stopped some of the elements a while ago, but also simply takes too long for me to write a review. On a regular basis, I would say it takes me upwards of 30-45 minutes to write the review, upload it on all the websites, and be “done”. For those that are more complex (like short-story collections), it can take me an hour at least. With no real added benefit for all the sub-sites too.
So I’m going to focus on putting it only on the PolyWogg site, not all the other sites. It isn’t driving people to me nor creating discussion/interaction, so what’s the point? They don’t need my support. Well, maybe the Ottawa Public Library, but their review area isn’t that convenient.
C. I want an in-home solution for tracking not only where I am on collecting and reading, but also for managing my ebook library. I have a large ebook TBR collection, and I’ve gone down a giant rabbit hole this year to make the library collection a lot more segregated for types of books (general fiction, various series, and specialized non-fiction categories). When I’m done reading a title, I add my review to the metadata for the ebook file and store it in a separate e-library collection. But my old idea of “one tick” is sufficient to indicate I have the book to read no longer applies. I need a way to indicate OWN, READING, READ, REVIEWING, and DONE.
I’ve played with a few tools out there. Some are good little trackers but they’re only on an app with no desktop version, so I’d have to type it all on my phone. Pass. Others are great with database imports, but lousy at tracking my categories above. Others are good in one area but not another, particularly for the ability to access while on the go. The list is useless to me if I’m browsing through Chapters and see a title that interests me but I don’t know if I have it or not. Most of the time I just take a picture and order it as an ebook from them later, or from Amazon or elsewhere if there is a price differential, but some titles I buy in paper still. Regardless, I need a list and I need to be able to access it on the go.
So far, all the pieces seem to be taking me out of the Excel world (which has been good to me for a long time) and moving me into more of an integrated OneNote option. I think I’m going to have a separate page for each author (or series if more than one author), as well as another tab with the actual prose of the reviews. Which means I can write my reviews on my site and just paste a copy into OneNote later or simply put in a link in the table.
Great, I have a way forward. Except it now means I’m going to take a night here or there over the next year to go deep on individual authors to compile their full list of books for my tracker. On the plus side, there are some very good sites out there who already compiled the lists for me.

I have a text file listing books I want to read.
I have a directory with my reviews.
I have a text file for each quarter of the year and my review and notes go in there.
I publish some on FB, depending on how interesting it is. Interestingly, recently I’ve been reading books where my reaction is too personal to post – that’s definitely new.
When I need to know if I’ve read a book, I use Windows Explorer to search the directory.
If an author has more books, in my text file of books to read, I include a link or note to “search for more if you like it”. And then when I’m looking for something reserve, I sometimes search for more.
I now have 13 years of book information stored this way. Very manageable. In case you wanted to simplify your life! π
Thanks Matt, some interesting ideas in there. Sooo:
a. List books “to be read”
b. Directory of reviews, I assume with your Q1, Q2 stuff going in
c. Publish on FB
I’m intrigued by the idea that some reactions are too personal to share. I only have that reaction when it is something involving someone else, not quite a privacy thing, more of a respectful thing, that talking about me and topic X would mean revealing some of someone else’s story that I’m not comfortable sharing. Of course, I kind of put a 25y time limit on those too unless it is intensely intimate which is vault territory. Anything else? I’ll blog. π
So do you synch those files anyway so they’re accessible while you’re mobile? Save in the cloud or anything? I feel like OneNote will pretty much do what I want. My only constraint is that I recently did something for keeping a list, a way of adding tags like a to do list bullet except I made ones for NEED/HAVE IN PAPER/HAVE AS EBOOK and then TBR / READ / REVIEWING / DONE. Simple, saved me from adding codes or columns. Except the tag bullets don’t work in mobile — I can *see* them when I synch, but I can’t CHANGE them on mobile. Not sure that matters too much, but is making me think if a simpler file might be better. I’d do it in Excel but some features don’t work on Mobile either. I don’t really want to create a “database” for this stuff. I like your simple text files, just with a bit more formatting capabilities.
Onward!
Paul
Paul
There was a book on race where I felt that the “white man critiques black female writer” trope was too strong so I reviewed other aspects.
There was a book on relationships that spoke to some of the more frustrating (to me) aspects of being in a relationship that didn’t seem like I should be sharing.
There was a book on parenting kids with certain types of challenges that for to talk honestly about would have exposed more about one of the girls than I was comfortable doing.
When I’m mobile? I don’t do anything when I’m mobile (exactly where would I be going these past two years?) I do everything at my desktop.
My text file has a section “On Hold” at the top, which is where I put a book when I put it on hold, and where I take it from when I write the review.
Below it is “Kids books that I returned” in case I want to get them out again.
Then a few hundreds lines of “To Read” with the title and the reason I want to read it. Maybe a friend mentioned it, or I read others by the author, or it won a prize, or the review looked interesting, etc.
At one point I got ambitious and started sorting by genre, so the list is partially sorted, but I’ve given up on that. Part of the fun is the random order – when I feel like I need a new book, I peruse the list like going through a bookstore, except that I know every book is of interest!
At the bottom are books that aren’t in the library. Not sure how I’ll ever read those.
Then a list of books I enjoyed, because I kept getting asked for recommendations (and I love giving them).
There are a few other random things. “Erikson-like Authors” because Steven Erikson is my favourite fantasy writer. Anything book related is in the file.
You like checklists though, so I can see why you put the effort into creating them.
Writing reviews is definitely a pain. It often takes me an hour or so. And I’m torn – I also want to record what I find interesting about a book, which I can do point form, but once I started publishing on FB I had to give it narrative flow and leave out a bunch of details. So I tend to have the list of factoids/thoughts/revelations, and then the actual review.
Ah, I see why you wouldn’t post those. There are a few where I’ve felt my “meh” would be mistaken for critique more than it simply didn’t resonate with me. One area that I frequently find “lacking”, for lack of a better word (hah!), is where a person in situation X talks about their experience, and suggests that being in situation X is what caused them to experience what they went through. Except, frequently, what they went through is more universal than they seem to know. Imposter syndrome is not limited to POC, or women, or other situation X, lots of people experience it across the spectrums just as lots of people DON’T experience it. What I’m often desiring is more of an attempt at comparative prose about how their experience differs from others who experience the same thing. With persons with disabilities, for example, it is often the “multiple barriers” aspect, and that is easier to imagine in some ways than the barriers of race or religion or geography. It’s not bad prose, it’s not “wrong” in any way, it’s just not very helpful to understand a larger experience of group X, and I hate when they try to generalize from the sample size of 1 to the entire sub-population. I’m guilty of it too, of course, in my blogs. I’ll talk about experiences I had, but there isn’t much comparative prose for me either, with the only difference is I’m not trying to explain men or white men or white people, I’m just trying to explain ME. π
For the list of books you can’t get at the library, I have two suggestions for you. One, you could send the list to me, and magically, if I happen to be anywhere those books might be available at little to no cost, they might appear. Second, more likely, you could create an Amazon wishlist for family and friends who might want to gift you a book but wouldn’t know where to start. π Just a thought.
Thanks for sharing…and I think I have a solution in One Note that seems to be working. I don’t know if you use ON, but it has tabs (Books), has pages (a master index of authors or series), a list of my reviews, and then I have pages for the actual author themself (Robert B. Parker, for instance) with the checklist for his/her bibliography, with sub-pages for individual reviews that match the layout of my website. I’m not sure I’m going to do those, as they are on my website, which is theoretically always available, and I have backups of the site now that are reliable. Not sure the need for the prose in my ON file but it’s easy enough to do. And really easy to search later. Hmm…
Paul