Content Download book list?

[tkavan]

Is it possible, from the Amazon Manage Your Content and Devices page, to download as a spreadsheet the list of books you have purchased?

[knc1]

Originally Posted by tkavan

Is it possible, from the Amazon Manage Your Content and Devices page, to download as a spreadsheet the list of books you have purchased?

I have never seen one myself.

And due to the lack of responses to your question, I think the answer is going to be:
No.

- - - -

If you have a Kindle, with relatively recent firmware, it will contain a list of all books in your account.
But get that in the form of a speadsheet from Amazon or from the Kindle ...
I don't think so.

Now the "Purchases List" on your account might include a list of all your purchased books.
Again, no spreadsheet output, but you might be able to capture and convert that listing.

[tomsem]

You can go to your Amazon account page and generate an Order History Report (downloads a .csv file). I thought this included Digital orders, but I just tried it, and it only includes non-Digital orders. Either they've changed it, or my memory is inaccurate. Seems inconsistent that they would not offer same capability for all orders, but it seems to be the case, unfortunately.

I don't know when I'll have time but it would be fun to write a web scraper script to extract this data.

[tkavan]

Originally Posted by tomsem

You can go to your Amazon account page and generate an Order History Report (downloads a .csv file). I thought this included Digital orders, but I just tried it, and it only includes non-Digital orders.

And it seems that "non-digital orders" only includes books bought from Amazon. Books you buy through Amazon but from a third party are not included.

It's strange that the list doesn't cover digital books. Just as it's strange that the Collections systems on Kindle ereaders and the PC ereader are not compatible. You'd think that a company would ensure that its services are complete and consistent across all platforms.

[tkavan]

Originally Posted by knc1

I have never seen one myself.

And due to the lack of responses to your question, I think the answer is going to be:
No.

I think you're right!

[Cinisajoy]

I may have a work around for you. I think you can export your digital books to Goodreads.

[tkavan]

Originally Posted by Cinisajoy

I may have a work around for you. I think you can export your digital books to Goodreads.

Thanks for the suggestion. I've taken a look at that but was put off by this: "Any books you add will be publicly visible on Goodreads." While I'm by no means a recluse, I'm not really interested in joining a community but instead was looking for a way to transfer my book list from Amazon to a spreadsheet on my own computer.

Perhaps that can be done through Goodreads, without setting up a public list of my books. If that's the case, I'd be interested in finding out how to to it.

Thanks.

[Cinisajoy]

Originally Posted by tkavan

Thanks for the suggestion. I've taken a look at that but was put off by this: "Any books you add will be publicly visible on Goodreads." While I'm by no means a recluse, I'm not really interested in joining a community but instead was looking for a way to transfer my book list from Amazon to a spreadsheet on my own computer.

Perhaps that can be done through Goodreads, without setting up a public list of my books. If that's the case, I'd be interested in finding out how to to it.

Thanks.

I forgot about that little detail. My bad.

[coplate]

It's not a spreadsheett, but it might be a little faster than copying it all yourself.

If you open the browser inspector, and monitor the network requests, and refresh your books likst, you can see a request to ref=myx_ajax

One of those request has the JSON message that has the documents that are showing on the screen.

Mine for example has this:

{
	"OwnershipData": {
		"hasMoreItems": true,
		"numberOfItems": 54,
		"success": true,
		"items": [{
				"targetDevices": {
					"<snip>": 1
				},
				"orderId": "<snip>",
				"isNellOptimized": false,
				"title": "Weavers",
				"sortableAuthors": "davis, aric",
				"isPurchased": true,
				"excludedDeviceMap": {},
				"getOrderDetails": true,
				"productImage": "https://images-na.ssl-images-amazon.com/images/I/51mwy3cZApL.jpg",
				"acquiredDate": "June 6, 2017",
				"orderDetailURL": "https://www.amazon.com/gp/digital/your-account/order-summary.html?orderID=<snip>&ref=kinw_myk_ro_details",
				"isContentValid": true,
				"canLoan": false,
				"renderDownloadElements": true,
				"acquiredTime": <snip>,
				"sortableTitle": "weavers",
				"originType": "Purchase",
				"capabilityList": ["EBOK_PURCHASE_ALLOWED"],
				"dpURL": "/gp/product/B00PJ9M834/ref=kinw_myk_ro_title",
				"collectionCount": 0,
				"asin": "B00PJ9M834",
				"isKCRSupported": true,
				"category": "KindleEBook",
				"authors": "Aric Davis",
				"readAlongSupport": "possible"
			},
<etc>

[knc1]

Hmm...
There is a small add-in that controls the built-in browser to fetch things -
The touchscreen Kindles include Lua -
Which has libraries pre-installed for json -> table, table -> csv

So it seems everything is present **on the Kindle** to fetch the information and output the desired *.csv table.
**on the Kindle**

But the Kindle would have to be jail broken for the user to run such custom code.