Merry Christmas everyone! Hope you’re having a restful holiday 🎄❄️
I was procrastinating on some other posts that I wanted to make, so I decided to do this rather mindless data wrangling of my 2025 reading. This is my first full year of using the Storygraph app which allows me to record all my books.
The app offers some nice wrap-ups every month and throughout the year, but I wanted a bit more control over the data and the specific metrics. I decided to try my hand at creating my own data! I wrangled some of it in the free online version of Excel, then downloaded it and used the free desktop version of PowerBI to create the charts.
Methodology
- Record my reading data in Storygraph throughout the year.
- Export my reading data from Storygraph in a CSV format. The exported report includes all the book data in my account, including to-be-read books and books read before 2025.
- Filter the CSV file for the books read in 2025.
- Clean up the filtered data and import it in PowerBI. The clean up involves making new columns for dates, editing columns that exported incorrectly, etc.
- Create tables and relationships in PowerBI based on the available CSV information. The CSV format is best viewed in a single table, but I split the data between tables to make it easier to create visualisations in PowerBI.
- Create the visualisations.
Reading overview
First, I created an overview of the books I read. This contained the basic read information like number of books read per month, average star ratings, etc. I was also interested to see which year most of these books were published in. I had a scatter plot originally, but I read one book that was published in 1912, so it skewed the data so much that it was hard to see the finer differentiations when I got to the 2010s.

Excluding Manga
Since I read a lot of One Piece manga this year, I felt the need to exclude those just to see how much of my reading came from non-manga. These filtered stats are below and they look a lot more realistic. Excluding manga, I read 31 books this year.
Most of my reading of non-manga came in Q4 of this year because the latest One Piece volumes have really long hold times so I had no other choice.
As expected, most of books are more recent, with five books published in 2022. However, I also see that I had been going through a backlog of books published before 2020. The books published between 1997 and 2007 are the Harry Potter Series. But the books after 2007 are just random picks from my to-be-read shelf. So that was pretty interesting!
I also didn’t read any books published in 2025! I am not entirely surprised as many of the new releases have long wait times at the library, so I gravitate towards those books that are already available. I did attempt one 2025 book “Empire of AI”, which I DNF-ed because I couldn’t really keep up.

Author breakdown
When preparing the data, I wasn’t sure how good “author country” would be as a metric. This tends to exclude third culture kids, or people who moved around a lot. And what matters most: country of birth, where you grew up, or where you live now? I feel like the answer may change from book to book, depending on the perspective of the book in question.
In the end, I went with what felt right. I searched for author information from their official websites, if possible. If not, I looked at publisher sites, and lastly Wikipedia.

Excluding Manga
When excluding manga, 71% of the books I’ve read are by female authors. Even if I further excluded J.K. Rowling’s 7 books, most of the books I’ve read would still be by female authors.
It would come as no surprise that 48% of the books read are by American authors. However, when doing a search on these authors, I noted that many of these American authors have mixed heritage. For example, Hernan Diaz was born in Argentina and raised in Sweden. Jane Hur was born in South Korea but spent her formative years in the USA, Canada, and South Korea (Source). Sangu Mandanna grew up in South India but now lives in the UK (Source). In the end, I picked the country that they seemed to have spent the most time in.
This is a reminder here for me to up my SingLit game. Only 10% of my reading was by local authors, which is about a fifth of the number of books read my American authors. I think I can do better here!

Genre breakdown
This is the part that gets the most interesting, in my opinion. There are just so many ways to slice the book data to figure out what I like to read. For now, I read mostly fiction and fantasy. I also read 36 manga volumes out of a total of 76 books, so that would skew the data slightly.
What I liked about this page is that I can click on any of the charts and it will cross-filter in the list on the right-hand side to show you the books matching that description. For example, I can filter for SingLit and it will show me the 3 book titles and the main genres that were tagged.

Excluding manga
After excluding for One Piece again, I can see that I still read mostly fiction, but I had a good 23% of non-fiction. I read mostly middle grade books, 7 of which are the Harry Potter Series. The next highest category is contemporary, which makes sense for me.
In terms of sub-genres, I think the LGBTQ+ might not be fully correct. I included books that I remember having LGBTQ+ representation but I probably missed out one some others. Only one of the books centered on the LGBTQ+ experience, so I’m also not sure if the tagging makes sense here.
One more stat I thought was interesting is that 2 of the books I read this year were epistolary novels. These are books that are written in the form of letters or other documents. These were Cover Story and Daddy-Long-Legs. It’s not a lot, but it’s interesting that it happened twice.

Areas for improvement
I think one major issue I had was excluding the manga because it skews the data. I can read one volume of One Piece manga a lot faster than I can read one book. I think I could normalise for the number of pages which is something Storygraph already does, but the export does not include number of pages so I would have to fill in that data manually.
While working on this project, I also kept thinking back to this video that I watched a year ago of this amazing book tracker by With Ali. In it, she walks through a tracker she created in Google Sheets that has linked charts and graphs which are very detailed. I liked how she had separated intended audience (i.e. adult, young adult, middle grade), format (i.e. novel, graphic novel, manga) from the general genre categories. It’s something I would consider the next time I update this file.
Other updates
I think there are other metrics I can consider such as the source of the book (i.e. library, owned), format (i.e. e-book, audiobook, paperback), etc. I would explore the different visualisations more and how I can make the dashboard look more aesthetic.
Future updates should be much easier compared to starting from scratch. When I feel like it, I might go back and add data for previous years and that might give me even more ideas of how to analyse this data. How fun!
Thanks for reading 💜
P.S. How do you wish you could slice and dice your book information?
I write about food, travel, and pop culture. If you liked this post and want to see more, sign up to my newsletter HERE. You will get little letters from me with updates of new stuff like blog posts, videos, or artwork. See you there!
Discover more from in the world
Subscribe to get the latest posts sent to your email.