AO3 Works List CSV Bookmarklet

Updates

2024-01-01: Fixed a bug in the Beta version of the bookmarklet that mangled dates (oops)
2023-12-14: Updated the Beta version to remove any non-digits (e.g. the thousands separator) from numbers (wordcount, hits, kudos, etc) in the hopes that it will make it easier to calculate your own statistics with the spreadsheet
2023-04-24: Updated the Beta version to include the work's recipient. Also reordered the columns to something that makes more sense to me, apologies if this has disrupted your workflow.
2022-04-24: Updated the Beta version to include the author's summary.
2022-01-09: Added a beta version of the bookmarklet to load extra columns from the History page.
2020-01-29: Fixed the behaviour for works with multiple authors.
2019-02-18: Updated the bookmarklet to work on Bookmarks pages and pull the bookmark date and bookmarker's name, tags, notes. Tweaked the file download so that it includes a filename (but the code is a lot less pretty!) Also, the 2016 frontend changes mean it no longer requires the Archive to be in English.
2018-02-22: Fixed a bug where it would break on titles that contained #.
2016-07-25: Updated to match latest AO3 frontend HTML. Now includes Wordcount.
2012-08-12: Created this page.

Lets you download the contents of a works listing as a CSV. Comments/bugs to flamebyrd@gmail.com.

Beta Version (Updated May 2023)

This version of the bookmarklet:

Removes any non-digits (e.g. the thousands separator) from numbers (wordcount, hits, kudos, etc) in the hopes that it will make it easier to calculate your own statistics with the spreadsheet
Loads the beta version of the code directly from my site (so it will always be up to date while I'm testing).
New: Includes the work's recipient.
New: Reordered the columns to something that makes more sense to me, apologies if this has disrupted your workflow.
Includes the information from the History page that shows the last time you visited the work, whether it has updated since then, and how many times you've visited. I may want to rework this so it extracts the number from the number of times visited.
Includes the author's summary in the work metadata, with formatting stripped but linebreaks preserved. I'm not sure how reliable the linebreak replacement in this is.
Includes the Unicode Byte Order Mark (BOM) which should hopefully stop Excel from mangling certain non-English characters.

In beta because I'm not sure how well any of these new features work. Stay tuned! And please let me know if you have any issues.

AO3 Works List (Download)

"Stable" Version

AO3 Works List (Download)

AO3 Works List (Manual)
(For Internet Explorer and other browsers that the other version doesn't work for. You can either copy the data into a new plain text document and save as .csv, or paste the text into your spreadsheet editor, then use its Data->Text to Columns menu option to split it into columns.)

Usage Instructions:

Install the bookmarklet in your browser. (For more information, see How to Use Bookmarklets.)
Go to any work or bookmarks listings page.
Click on the bookmarklet. Your browser will download a file.
The file should have a CSV extension. Open in your favourite spreadsheet program - it may ask you for some import settings, so be sure to use comma separators and the UTF-8 encoding.

If you have a lot of works (ie. if the output is truncated), use Internet Explorer or otherwise have trouble, try the second version.

Please note that updates are not automatically applied. Please reinstall the bookmarklet to update it.

Note: This bookmarklet loads jQuery from Google's CDN. If you want to use your own URL, feel free to replace it.

jQuery loaded into bookmarklet using Ben Alman's jQuery Bookmarklet Generator.