I have become somewhat addicted to the excellent Amazon DOT and find it excellent for playing back my Audible library.
I've been trying to find out how to list out my Audible library so that I can either take screen shots or - if possible - export to Word, Excel or Txt so that I can have a neat list of titles to call up. I am afraid I'm too old to remember them all :(
Is there an existing "List For Print" option or work around does anyone know?
This will also give you some useful experience in Excel!
On Audible.com, go to Library. Find the VIEW BY toolbar, and select All Time and 200 items per page. In my case, this reduced the number of pages in my Library down to two.
Notice that your Library is laid out like a spreadsheet. We'll use this to our advantage. Place your mouse cursor in the top-left "cell" (two cells to the left of the "Download Status" cell): click and hold, then drag to select just the first few rows of the "spreadsheet." With this selected, scroll to the very bottom of the "spreadsheet." Now, hold down your keyboard's SHIFT key and click in a blank space in the bottom-right "cell" of the "spreadsheet." The whole thing should be selected now!
We'll come back for the second page (and third, etc.) later. For now, open a new Microsoft Word Document and hit Paste. This may take a moment and Word may become temporarily unresponsive. Just wait. Really, we can't do much of anything helpful in Word, but we're here for a reason! We'll be copying this data to Excel next, but going first through Word as a medium will actually clean the spreadsheet of some troublesome issues that there is no reason to get into. So, having just pasted your "spreadsheet" into Word, select it all and copy it again (from Word this time, if it isn't clear).
Open a new Microsoft Excel Spreadsheet, click your mouse cursor in the first cell (A1), then hit Paste. Click the top-right cell (should be J1), then scroll down until you hit the bottom of the spreadsheet, hold SHIFT on your keyboard and click the bottom-left cell.
Then, in Excel's Home tab, click on the Merge & Center button in the Home tab to unmerge some of the cells. Then click on the Wrap Text button twice to remove text wrapping. Getting there! With everything still selected, look at the Home tab again, on the far right, click on the Sort & Filter button, then select Filter. (This will enable us to sort out blank rows later.)
Now, remember: all we want is the Title, Author, and Length of each book. Look at row 2: you will see "Title," "Author," and "Length" there along with some other stuff. Clicking on the Filter "down arrow" button on each of the top row's cells will reveal a quick preview of the data in that column. Immediately, you should be able to tell that the first three columns and last four are unimportant. Select the first three columns (by clicking on the column names "A", "B", "C"), then right-click, and select Delete. The spreadsheet will readjust. Repeat the same for columns D through G to clear out the last four unimportant columns.
Now! It's going to look like your important data is all spread out with gaps in between. Because we enabled the Filter earlier, we can get rid of these gaps as easily as clicking on the Filter "down arrow" on cell A1 and selecting Sort A to Z. Scroll down a little bit and remove the "PDF" rows entirely (if, like me, you have any). Scroll down again and remove the "View Series" rows also.
Okay, we're done with the first page of your Audible library. A few of you, like myself, will have libraries large enough to need to go back for a second page. If that's you, do all of this with the second page, too (starting with copy-and-pasting it into Word).
That should be it! Of course, you can clean up a few things, like the font. But there you have the basic information in a trim spreadsheet WITH links to the books' and authors' pages on Audible.com.