The Kindle Store has thousands of categories, and it’s hard to make sense of them all if you’re a self-published author. Here at Kindletrends, I’ve crawled all 4000+ categories, and made them available for free.
Download all the Categories (XLSX)
What do all the columns mean?
- Book1Rank and Book100Rank are the Best Sellers Rank of the #1 and #100 book in the category as at the time I snapshotted it. This will change, of course, but it’s a crude proxy measure of how many books the category is selling.
- Rank Trend tells you whether the Best Seller Rank of the #1 book has gone up or down since last month. ‘Book1Rank (last month)’ and ‘Book100Rank (last month)’ are listed at the end of the spreadsheet (to the right) if you want to check how big the increase or decrease is.
- nLast30Days is the (rounded) number of books published in the last 30 days in this category, which is a crude proxy measure of activity. Frustratingly for us, Amazon rounds this heavily to the nearest 1000, or sometimes 10000. So it’s really only accurate to within an order of magnitude, but maybe still useful with that caveat.
- Activity Trend tells you whether the number of books published in the last 30 days has gone up or down since last month. As above, nLast30Days (last month) is listed at the end of the spreadsheet if you want to compare them.
- browseNodeID is the unique reference number for each category. There are a standard set of pages for each category: given the browse node ID for a category, you can work out what the URLs will be for them. Specifically, what the URL for the Top 100 for that category will be, as well as the ‘Last 30 Days’ page, the ‘Last 90 Days’ page, and the ‘Preorders’ page. Practically as an author, you can probably ignore this, except it’s the best way to uniquely identify a specific category (handy in situations where there are two or more commonly-confused categories).
- parentName and parentBrowseNodeID are the name and browse node ID of the parent category for the current one; again this isn’t super-useful, although I do use it to construct the ‘category path’ column. And, there might be a time when you want to find everything underneath a particular category, I guess.
You can use this to find appropriate categories for your own work, and to look at the ranks and level of activity in each category. It comes complete with:
- Ranks of the #1 and #100 book in each category for this month and last month
- The number of books published in the last 30 days for this month and last month
- Links to the Top 100 and the ‘Last 30 Days’ for each category
Caveat: pulling all this data isn’t an exact science, and with a big website like Amazon, there are always a few strangenesses. Within the 4000+ categories, you’ll definitely find a few places where something went haywire: either there wasn’t a 100th book in the category (this happens quite a bit!), or there weren’t any books in the last 30 days, or something else unexpected. If you see something weird, use the links provided and go to the store to check it out yourself before you make any decisions based on it. I do try to recheck everything if we don’t get back what we expect, but something is always changing at Amazon, and this kind of activity really makes that clear.
How do I open it?
This is an XLSX file, so you can open it in pretty much any spreadsheet program: Excel, LibreOffice, Numbers. If you don’t have any of those, Google Sheets is a good free online alternative. If you have any questions about sorting, filtering etc. just drop me an email and I’ll be happy to help you out.
This is an online spreadsheet powered by a tool called ‘Airtable’. If you want a bigger version (you probably do), click the ‘view larger version’ link on the bottom right. You can search for categories by name, as well as sort and filter them by level, by ranks or by activity.
Was this useful? I’ll update it here for free every month. Kindletrends subscribers get a bunch of other goodies, plus weekly newsletters on trends in 14 different fiction genres.