Ao3 Wrapped History Spreadsheet, It was built by feind (find me on Discord @ deinfeind), and has been inspired by the work of kanasther / bothermione, but does not use any of her code. Since I’m so proud of it, I thought I would share! You can watch it here. Explore and visualize your personal reading history from Archive of Our Own — see your fandom trends, favorite works, and reading patterns throughout the year. Save your changes. When it finishes, the extension should make a little pop up to let you know. This function uses a Flask container on Heroku to perform the following actions: Log into your account Loop Easier access to AO3 data dump I have split up the AO3 tag data into smaller files, in case people want to access smaller subsets of the tags and/or view the data as a spreadsheet. ) AO3 fanfic tracker spreadsheet is linked in my bio! After two years of manually tracking my fanfic reads in Excel, I finally decided to just create my own AO3 fanfic tracker spreadsheet. I'm sorry this asks for your password, but AO3 locks a readers history behind their account. Feel free to take inspiration if you’d like to create your own! Happy reading! 🎉 Archived post. Logging your fics is still manual. The Running and Configuring section of the manual includes details on how to tune things like which year you want to generate a report for and how to set it to scan only a specific range of history pages (to skip forward X pages to get to where you know the next year starts) This tool will generate statistics of your ArchiveOfOurOwn reading habits. I???m not a coder and had no idea what I was doing, but with a lot of help from ChatGPT, I managed to make it work exactly the way I wanted! Then @jasminesbinderyput together the most amazing wrap-up stats for If you want to give yourself an AO3 Wrapped (of sorts) next year, you can clear your history on Dec 31/Jan 1 and then at the end of 2023, you can run this bookmarklet and get a spreadsheet of your Jan 24, 2021 · 18 Hits: 29,141 You've heard of Spotify wrapped what about AO3 wrapped? by illylily illylily Summary: I made a Ao3 wrapped inspired by Spotify's yearly wrapped. Enter your ao3 username and password. Just let it run. Run the program like this: If you're on macOS then do python3 instead of python like python3 ao3wrapped. You’ll see ad results based on factors like relevancy, and the amount sellers pay per click. If you want to give yourself an AO3 Wrapped (of sorts) next year, you can clear your history on Dec 31/Jan 1 and then at the end of 2023, you can run this bookmarklet and get a spreadsheet of your Jan 3, 2026 · Ao3 Wrapped Downloads fics bookmarked for a specified year and outputs stats for making graphs to a CSV file. csv - a spreadsheet of the works you Welcome back to AO3 wrapped. py. >>>THIS HERE<<< is an og instruction on how to scrape from your ao3 history. Smart - but annoying for making these. There are options to scrape your history instead of your bookmarks, as well as to change the year. Open the ao3_flaskserver folder and launch ao3 This app should open and close automatically. To run, use uv. csv - a spreadsheet of the works you The scrape will take anywhere between a few minutes and a few hours, depending on how long your history is. Be very patient. If you experience a server error, the flask app did not launch correctly. (The above data is wonderful, but it's too big to open directly in spreadsheet software). files for ao3 wrapped. exe file For Mac - download the mac. This is how you export your (almost) whole ao3 history into a spreadsheet. This post is about my Google Sheets reading log template, which generates statistics for you. zip and run the ao3wrapped application. Bothermione presents - AO3 wrapped. For Windows - download the windows. Learn more. Back in the Webscraping menu, click the dropdown menu "Sitemap ao3_read_wordcount" and select "Export data as CSV". js implementation inspired by the original AO3 Wrapped Google Colab project by @kyucultures (soupbanana on GitHub). 50 ( Results include ads Learn more Sellers looking to grow their business and reach more interested buyers can use Etsy’s advertising platform to promote their items. Contribute to soupbanana/AO3_wrapped development by creating an account on GitHub. The tool requires Ao3 username and password and may have errors or limitations. It includes author, title and word count, so if you’re only into words, you can just follow those instructions. A user shares a tool to get Ao3 stats for the year, such as works read, words read, and fandoms. Reading Tracker Spreadsheet - Ao3 Version $1. This will also generate two files: works. Probably not useful unless you bookmark every fic you finish reading like me, but if you do it should mostly work. Jan 3, 2025 · Hi! Ao3 has no in-built statistics tab. I analyzed my data from my 2020 ao3 history to make this, with year summaries and monthly summaries ! (Includes interactive photos, video, and in the future, a link to view this on Basically I created a spreadsheet and manually inputted all the data and then spent a while sorting it using MATLAB before creating a summary video on Canva. . If it makes you uncomfortable - For those savvy in code, all the BotHermione code is now open source, and can be found here. zip and run the ao3wrapped. Before running this notebook, it’s Dec 7, 2025 · Generate beautiful wrapped-style statistics for your Archive of Our Own (AO3) reading history! This is a standalone Node. xgssjgpqxa6dkq4pmpcx77wg8zyaigrbntnlwqdfszklyxk86