My Kindle library had grown to 3,941 books, so I asked Claude Code to turn it into an Excel list organised by title, author, genre and so on. Amazon has no official feature for exporting a whole library, so I fed it the file that Kindle for PC saves on the computer. Once everything was listed, I found books I had bought twice without realising, and I could see what I have been interested in.
These days I split my life between Japan and the UK, and with all that moving around, Kindle has become my main way of reading. Over the years I've picked up books on healthy longevity, books on Oriental medicine and acupuncture, books on investing, books on gardening, and works by Ryotaro Shiba — buying whatever caught my interest at the time. Before I knew it, my Kindle library had grown to 3,941 books.
Honestly, once the number got that large, I completely lost track of what I actually owned. I bought the same book twice without realising it more than once, and just trying to remember "wasn't there a book with 'reflections' somewhere in the title?" became a small ordeal in itself.
How it felt not knowing what I owned or where anything was, among 3,941 books scattered across my library.
Amazon has no built-in way to export the full list
I decided it was finally time to make a proper list, but when I looked into it, I found that Amazon has no official feature for bulk-exporting a Kindle library. Taking screenshots of 3,941 books one by one clearly wasn't realistic either.
So I turned to Claude, the AI assistant I use regularly, and asked for advice. It turned out that if you use Kindle for PC (or Mac), the app automatically saves information about every book you own in a file on your computer — one called KindleSyncMetadataCache.xml. By feeding that file into a tool called Claude Code, I could have it automatically generate a proper Excel list.
How it actually went
Roughly speaking, the process looked like this:
- Find where Kindle for PC stores that file on the computer
- Create a new working folder and copy the file into it
- Launch Claude Code
- Ask it to read the file and produce an Excel sheet organised by title, author, genre, and so on
It sounds simple written out like that, but as someone who isn't especially confident with computers, I hit a few bumps along the way. I wasn't sure how to check my own username. I meant to open a command prompt and ended up somewhere else entirely. My login had expired and I had to figure out the /login command. Even so, by checking each screen carefully and asking the AI questions along the way, I found I could keep moving forward step by step — no technical background required.
What I learned from seeing it all in one place
Looking at the finished list was, honestly, more interesting than I expected. It gave me a visual sense of what I've actually been curious about and learning over the years. When I tallied the books by genre, I found I owned far more books on health and Oriental medicine than I'd realised — and, on the flip side, surprisingly few in the genres I'd been meaning to read more of. Seeing my own reading habits turned into numbers was oddly revealing.
It also turned up a handful of books I'd accidentally bought twice, which will save me some unnecessary spending going forward.
The relief of finally having that scattered library turned into a clean list of titles, authors, and genres.
For anyone in the same boat
I suspect quite a few people are in the same situation I was in — ebooks quietly piling up until you have no idea what you own any more. What struck me is that this whole process was manageable even without much confidence in computers, as long as I was willing to ask the AI one question at a time.
Being able to pick up a new tool at this stage of life, working through it patiently, felt like its own small kind of exercise for the mind.
Other books you might like
You're welcome to take a look.
EAST TO WEST: The Heart of Haiku, the Light of Scripture
A quiet one I keep coming back to in my own Kindle library. This is a book my father-in-law left behind.
View on AmazonCataract Surgery-A Memoir: Double cataract surgery in Osaka, Japan
Another record of an experience from my sixties, written down for anyone facing the same thing.
View on AmazonSushi Business in Britain: the complete four-volume series
A novel series following thirty-five years in the British sushi trade, from apprentice to factory manager to a small sushi school. The complete edition offers all four volumes at a better price.