I’m not sure if I’ve ever mentioned it on here, but since the summer of 2014 I’ve been keeping track of the books I’ve read in an Excel spreadsheet. Since I got a new computer, I’ve not got Microsoft anymore, but instead installed OpenOffice; my spreadsheets were transferred to there.
Ever since reading a post by Carina on her blog about the spreadsheet she uses to keep track of her reading (and sharing the spreadsheet with the world), I realized it was about time I updated mine to include a few more features.
I really liked the layout Carina used for her spreadsheet, but I wanted something to keep track of all my books, plus all the books I’d read that weren’t mine. So, the formula fun began! H
Here are the different tabs I now use and the way in which they fit with what I want.
This is the first tab “general”. Here I can find an overview of the total amount of books I own, how many of those I’ve read, male/female authors, total spending (which is skewed, because mostly the prices aren’t on the books anymore), different languages, and audiences.
The second tab is 2014, but since I’ve only kept track since summer 2014, it stars halfway, therefore a picture of 2015. Here you can see the amount of books I’ve read this year. As you can see there’s read (own) and read (other), so I can keep track which books go off my TBR (more on the own/other later). As a lot of the formulas need something to fall back on, it’s not been possible to fill this out halfway through the year (ok, it’s possible, but I’ve been too lazy for those calculations). Thus, a lot is still empty. That should get better in 2016.
“2016”, the green bits indicate numbers that need to be filled in by hand. Everything else is generated automatically. I think the white parts are the most important: the total books read, and the TBR I started with for the year.
The next tab is “books”. These are all the books that I own, with the necessary information. With the sort function in OpenOffice, it’s easy enough to sort through them and pick my next read.
To not make the tabs names too long, I’ve simply called this one “read”. However, these are not all the books I’ve read. These are only the books I’ve read and don’t actually own (or are in eBook and audioBook format). This way, I can keep track of all the books I’ve read, but also am able to easily sort through the books I own, without the two lists becoming confusing.
If you have any questions or would like the formulas or anything, let me know, I’ll be happy to send it to you!