AO3 Works List CSV Bookmarklet
Lets you download the contents of a works listing as a CSV. Comments/bugs to firstname.lastname@example.org.
Beta Version (Updated April 2022)
This version of the bookmarklet:
- Loads the beta version of the code directly from my site (so it will always be up to date while I'm testing).
- 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 (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.)
- 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.