An Excel fanfiction tracker for AO3 readers who want to organize their favourite fics, authors, fandoms, and reading statistics without the hassle of manual data entry.
This innovative reading tracker template features automatic AO3 import capabilities, allowing you to build your perfect TBR list and manage your reading challenge progress while organizing your favorite fics, authors, and fandoms without manual data entry hassles. This all-in-one organization tool streamlines your fanfiction journey from discovery to completion.
Ultimate Fan Fiction Organization Solution for AO3 Readers
✨ 𝐅𝐄𝐀𝐓𝐔𝐑𝐄𝐒
𝐄𝐱𝐜𝐞𝐥 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐭𝐫𝐚𝐜𝐤𝐞𝐫 designed specifically for organizing your fanfiction library.
𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐜𝐚𝐥𝐥𝐲 𝐢𝐦𝐩𝐨𝐫𝐭 𝐀𝐎𝟑 𝐬𝐭𝐨𝐫𝐲 𝐝𝐞𝐭𝐚𝐢𝐥𝐬 by simply pasting an AO3 link into the spreadsheet. The built-in import tool retrieves story information for you, including:
• Automatic AO3 story import feature - simply paste any AO3 link to instantly retrieve title, author, fandom, chapter count, and additional story details
• Comprehensive reading tracker with customizable fields for organizing your entire fanfiction library by fandom, author, pairing, rating, and reading status
• Built-in TBR list manager and reading challenge tracker to set goals and monitor your progress throughout the year
• Beautiful aesthetic charts and statistics that visualize your reading habits, favorite fandoms, and most-read authors
• Instant digital download - fully editable Excel template compatible with Microsoft Excel and Google Sheets for immediate use
𝐍𝐨 𝐭𝐞𝐝𝐢𝐨𝐮𝐬 𝐜𝐨𝐩𝐲-𝐚𝐧𝐝-𝐩𝐚𝐬𝐭𝐞. Save hours of manual data entry and build your fanfiction library in seconds.
𝐓𝐫𝐚𝐜𝐤 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐬𝐭𝐨𝐫𝐢𝐞𝐬 across all your fandoms in one organized spreadsheet.
𝐊𝐞𝐞𝐩 𝐚 𝐩𝐞𝐫𝐬𝐨𝐧𝐚𝐥 𝐚𝐫𝐜𝐡𝐢𝐯𝐞 𝐨𝐟 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐚𝐮𝐭𝐡𝐨𝐫𝐬 and discover which writers you return to most often.
𝐌𝐨𝐧𝐢𝐭𝐨𝐫 𝐲𝐨𝐮𝐫 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐫𝐞𝐚𝐝𝐢𝐧𝐠 𝐠𝐨𝐚𝐥𝐬 and watch your progress over time.
𝐁𝐞𝐚𝐮𝐭𝐢𝐟𝐮𝐥 𝐯𝐢𝐬𝐮𝐚𝐥 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 with easy-to-read charts and reading statistics.
𝐒𝐞𝐞 𝐲𝐨𝐮𝐫 𝐦𝐨𝐬𝐭-𝐫𝐞𝐚𝐝 𝐟𝐚𝐧𝐝𝐨𝐦𝐬, 𝐭𝐚𝐠𝐬, 𝐚𝐮𝐭𝐡𝐨𝐫𝐬, 𝐚𝐧𝐝 𝐦𝐨𝐫𝐞 with automatically updated analytics.
𝐓𝐫𝐚𝐜𝐤 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐭𝐚𝐠𝐬 𝐛𝐲 𝐟𝐚𝐧𝐝𝐨𝐦 to identify the tropes, ships, and themes you love most.
𝐑𝐞𝐚𝐝𝐢𝐧𝐠 𝐁𝐢𝐧𝐠𝐨 𝐭𝐫𝐚𝐜𝐤𝐞𝐫 adds a fun challenge to your reading throughout the year.
𝟗 𝐨𝐫𝐠𝐚𝐧𝐢𝐳𝐞𝐝 𝐭𝐚𝐛𝐬 to manage your library, reading statistics, favourite writers, fandoms, dashboard, bingo, and more.
𝐃𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐰𝐢𝐭𝐡𝐨𝐮𝐭 𝐬𝐭𝐨𝐫𝐲 𝐫𝐚𝐭𝐢𝐧𝐠𝐬.This tracker intentionally does not include star ratings or numerical scoring, making it perfect for readers who simply want to remember and organize the stories they love.
𝐈𝐧𝐬𝐭𝐫𝐮𝐜𝐭𝐢𝐨𝐧𝐬 𝐢𝐧𝐜𝐥𝐮𝐝𝐞𝐝, along with a step-by-step video tutorial for setting up the AO3 import feature.
𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐜 𝐬𝐲𝐧𝐜𝐢𝐧𝐠 𝐛𝐞𝐭𝐰𝐞𝐞𝐧 𝐭𝐚𝐛𝐬 means you enter information once and let the spreadsheet do the rest.
𝐇𝐎𝐖 𝐓𝐎 𝐎𝐑𝐃𝐄𝐑
1. Add this listing to your cart and proceed to checkout.
2. Download the Excel and VBA Macro files from the My Purchases section of your Etsy account. A copy will also be sent to your email.
3. Open the spreadsheet in Excel
4. Follow the steps on the Instructions tab to enable the auto-importer for AO3 links
𝐅𝐑𝐄𝐐𝐔𝐄𝐍𝐓𝐋𝐘 𝐀𝐒𝐊𝐄𝐃 𝐐𝐔𝐄𝐒𝐓𝐈𝐎𝐍𝐒
𝐖𝐡𝐚𝐭 𝐝𝐨 𝐈 𝐫𝐞𝐜𝐞𝐢𝐯𝐞 𝐚𝐟𝐭𝐞𝐫 𝐩𝐮𝐫𝐜𝐡𝐚𝐬𝐞?
You'll receive:
* An Excel file and a VBA Macro file
* One Excel spreadsheet with 9 tabs
* A plain text Macro file used to power the AO3 import button
* Written setup instructions
* A link to a video tutorial showing you exactly how to enable the import feature
𝐇𝐨𝐰 𝐝𝐨 𝐈 𝐝𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐦𝐲 𝐟𝐢𝐥𝐞𝐬?
After your purchase, you'll be able to download your files via the confirmation email.
𝐖𝐢𝐥𝐥 𝐭𝐡𝐢𝐬 𝐰𝐨𝐫𝐤 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝐨𝐫 𝐀𝐩𝐩𝐥𝐞 𝐍𝐮𝐦𝐛𝐞𝐫𝐬?
This version is built specifically for 𝐄𝐱𝐜𝐞𝐥. The automatic AO3 import feature relies on a VBA Macro, which is not supported in Google Sheets or Apple Numbers.
If you're looking for a Google Sheets version, a separate edition is available.
𝐈'𝐦 𝐧𝐨𝐭 𝐯𝐞𝐫𝐲 𝐭𝐞𝐜𝐡-𝐬𝐚𝐯𝐯𝐲. 𝐂𝐚𝐧 𝐈 𝐬𝐭𝐢𝐥𝐥 𝐮𝐬𝐞 𝐭𝐡𝐢𝐬?
Absolutely! Detailed written instructions are included, along with a video walkthrough that shows exactly how to enable the AO3 import button. Once it's set up, the spreadsheet is designed to be as simple as possible, with information automatically syncing across multiple tabs.
𝐂𝐚𝐧 𝐈 𝐢𝐦𝐩𝐨𝐫𝐭 𝐬𝐭𝐨𝐫𝐢𝐞𝐬 𝐟𝐫𝐨𝐦 𝐅𝐚𝐧𝐅𝐢𝐜𝐭𝐢𝐨𝐧.𝐧𝐞𝐭, 𝐖𝐚𝐭𝐭𝐩𝐚𝐝, 𝐓𝐮𝐦𝐛𝐥𝐫, 𝐨𝐫 𝐨𝐭𝐡𝐞𝐫 𝐰𝐞𝐛𝐬𝐢𝐭𝐞𝐬?
The automatic import feature currently works 𝐨𝐧𝐥𝐲 𝐰𝐢𝐭𝐡 𝐀𝐫𝐜𝐡𝐢𝐯𝐞 𝐨𝐟 𝐎𝐮𝐫 𝐎𝐰𝐧 (𝐀𝐎𝟑) links. However, you can still manually enter stories from any fanfiction website, including FanFiction.net, Wattpad, Tumblr, SquidgeWorld, or personal author websites.
𝐃𝐨 𝐈 𝐧𝐞𝐞𝐝 𝐚𝐧 𝐀𝐎𝟑 𝐚𝐜𝐜𝐨𝐮𝐧𝐭?
No. You don't need an AO3 account to use the tracker. As long as the work is publicly accessible on AO3, you can paste its link into the spreadsheet and import the available information.
𝐖𝐢𝐥𝐥 𝐦𝐲 𝐝𝐚𝐭𝐚 𝐬𝐭𝐚𝐲 𝐩𝐫𝐢𝐯𝐚𝐭𝐞?
Yes. Once you've saved the spreadsheet to your device or cloud, your reading tracker lives in your own digital space. Only you can access it unless you choose to share it with someone else.
𝐂𝐚𝐧 𝐈 𝐜𝐮𝐬𝐭𝐨𝐦𝐢𝐳𝐞 𝐭𝐡𝐞 𝐬𝐩𝐫𝐞𝐚𝐝𝐬𝐡𝐞𝐞𝐭?
Yes! You're free to personalize it with your own charts, categories, filters, and additional tabs if you'd like.
An Excel fanfiction tracker for AO3 readers who want to organize their favourite fics, authors, fandoms, and reading statistics without the hassle of manual data entry.
This innovative reading tracker template features automatic AO3 import capabilities, allowing you to build your perfect TBR list and manage your reading challenge progress while organizing your favorite fics, authors, and fandoms without manual data entry hassles. This all-in-one organization tool streamlines your fanfiction journey from discovery to completion.
Ultimate Fan Fiction Organization Solution for AO3 Readers
✨ 𝐅𝐄𝐀𝐓𝐔𝐑𝐄𝐒
𝐄𝐱𝐜𝐞𝐥 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐭𝐫𝐚𝐜𝐤𝐞𝐫 designed specifically for organizing your fanfiction library.
𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐜𝐚𝐥𝐥𝐲 𝐢𝐦𝐩𝐨𝐫𝐭 𝐀𝐎𝟑 𝐬𝐭𝐨𝐫𝐲 𝐝𝐞𝐭𝐚𝐢𝐥𝐬 by simply pasting an AO3 link into the spreadsheet. The built-in import tool retrieves story information for you, including:
• Automatic AO3 story import feature - simply paste any AO3 link to instantly retrieve title, author, fandom, chapter count, and additional story details
• Comprehensive reading tracker with customizable fields for organizing your entire fanfiction library by fandom, author, pairing, rating, and reading status
• Built-in TBR list manager and reading challenge tracker to set goals and monitor your progress throughout the year
• Beautiful aesthetic charts and statistics that visualize your reading habits, favorite fandoms, and most-read authors
• Instant digital download - fully editable Excel template compatible with Microsoft Excel and Google Sheets for immediate use
𝐍𝐨 𝐭𝐞𝐝𝐢𝐨𝐮𝐬 𝐜𝐨𝐩𝐲-𝐚𝐧𝐝-𝐩𝐚𝐬𝐭𝐞. Save hours of manual data entry and build your fanfiction library in seconds.
𝐓𝐫𝐚𝐜𝐤 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐬𝐭𝐨𝐫𝐢𝐞𝐬 across all your fandoms in one organized spreadsheet.
𝐊𝐞𝐞𝐩 𝐚 𝐩𝐞𝐫𝐬𝐨𝐧𝐚𝐥 𝐚𝐫𝐜𝐡𝐢𝐯𝐞 𝐨𝐟 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐚𝐮𝐭𝐡𝐨𝐫𝐬 and discover which writers you return to most often.
𝐌𝐨𝐧𝐢𝐭𝐨𝐫 𝐲𝐨𝐮𝐫 𝐟𝐚𝐧𝐟𝐢𝐜𝐭𝐢𝐨𝐧 𝐫𝐞𝐚𝐝𝐢𝐧𝐠 𝐠𝐨𝐚𝐥𝐬 and watch your progress over time.
𝐁𝐞𝐚𝐮𝐭𝐢𝐟𝐮𝐥 𝐯𝐢𝐬𝐮𝐚𝐥 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 with easy-to-read charts and reading statistics.
𝐒𝐞𝐞 𝐲𝐨𝐮𝐫 𝐦𝐨𝐬𝐭-𝐫𝐞𝐚𝐝 𝐟𝐚𝐧𝐝𝐨𝐦𝐬, 𝐭𝐚𝐠𝐬, 𝐚𝐮𝐭𝐡𝐨𝐫𝐬, 𝐚𝐧𝐝 𝐦𝐨𝐫𝐞 with automatically updated analytics.
𝐓𝐫𝐚𝐜𝐤 𝐲𝐨𝐮𝐫 𝐟𝐚𝐯𝐨𝐮𝐫𝐢𝐭𝐞 𝐭𝐚𝐠𝐬 𝐛𝐲 𝐟𝐚𝐧𝐝𝐨𝐦 to identify the tropes, ships, and themes you love most.
𝐑𝐞𝐚𝐝𝐢𝐧𝐠 𝐁𝐢𝐧𝐠𝐨 𝐭𝐫𝐚𝐜𝐤𝐞𝐫 adds a fun challenge to your reading throughout the year.
𝟗 𝐨𝐫𝐠𝐚𝐧𝐢𝐳𝐞𝐝 𝐭𝐚𝐛𝐬 to manage your library, reading statistics, favourite writers, fandoms, dashboard, bingo, and more.
𝐃𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐰𝐢𝐭𝐡𝐨𝐮𝐭 𝐬𝐭𝐨𝐫𝐲 𝐫𝐚𝐭𝐢𝐧𝐠𝐬.This tracker intentionally does not include star ratings or numerical scoring, making it perfect for readers who simply want to remember and organize the stories they love.
𝐈𝐧𝐬𝐭𝐫𝐮𝐜𝐭𝐢𝐨𝐧𝐬 𝐢𝐧𝐜𝐥𝐮𝐝𝐞𝐝, along with a step-by-step video tutorial for setting up the AO3 import feature.
𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐜 𝐬𝐲𝐧𝐜𝐢𝐧𝐠 𝐛𝐞𝐭𝐰𝐞𝐞𝐧 𝐭𝐚𝐛𝐬 means you enter information once and let the spreadsheet do the rest.
𝐇𝐎𝐖 𝐓𝐎 𝐎𝐑𝐃𝐄𝐑
1. Add this listing to your cart and proceed to checkout.
2. Download the Excel and VBA Macro files from the My Purchases section of your Etsy account. A copy will also be sent to your email.
3. Open the spreadsheet in Excel
4. Follow the steps on the Instructions tab to enable the auto-importer for AO3 links
𝐅𝐑𝐄𝐐𝐔𝐄𝐍𝐓𝐋𝐘 𝐀𝐒𝐊𝐄𝐃 𝐐𝐔𝐄𝐒𝐓𝐈𝐎𝐍𝐒
𝐖𝐡𝐚𝐭 𝐝𝐨 𝐈 𝐫𝐞𝐜𝐞𝐢𝐯𝐞 𝐚𝐟𝐭𝐞𝐫 𝐩𝐮𝐫𝐜𝐡𝐚𝐬𝐞?
You'll receive:
* An Excel file and a VBA Macro file
* One Excel spreadsheet with 9 tabs
* A plain text Macro file used to power the AO3 import button
* Written setup instructions
* A link to a video tutorial showing you exactly how to enable the import feature
𝐇𝐨𝐰 𝐝𝐨 𝐈 𝐝𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐦𝐲 𝐟𝐢𝐥𝐞𝐬?
After your purchase, you'll be able to download your files via the confirmation email.
𝐖𝐢𝐥𝐥 𝐭𝐡𝐢𝐬 𝐰𝐨𝐫𝐤 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝐨𝐫 𝐀𝐩𝐩𝐥𝐞 𝐍𝐮𝐦𝐛𝐞𝐫𝐬?
This version is built specifically for 𝐄𝐱𝐜𝐞𝐥. The automatic AO3 import feature relies on a VBA Macro, which is not supported in Google Sheets or Apple Numbers.
If you're looking for a Google Sheets version, a separate edition is available.
𝐈'𝐦 𝐧𝐨𝐭 𝐯𝐞𝐫𝐲 𝐭𝐞𝐜𝐡-𝐬𝐚𝐯𝐯𝐲. 𝐂𝐚𝐧 𝐈 𝐬𝐭𝐢𝐥𝐥 𝐮𝐬𝐞 𝐭𝐡𝐢𝐬?
Absolutely! Detailed written instructions are included, along with a video walkthrough that shows exactly how to enable the AO3 import button. Once it's set up, the spreadsheet is designed to be as simple as possible, with information automatically syncing across multiple tabs.
𝐂𝐚𝐧 𝐈 𝐢𝐦𝐩𝐨𝐫𝐭 𝐬𝐭𝐨𝐫𝐢𝐞𝐬 𝐟𝐫𝐨𝐦 𝐅𝐚𝐧𝐅𝐢𝐜𝐭𝐢𝐨𝐧.𝐧𝐞𝐭, 𝐖𝐚𝐭𝐭𝐩𝐚𝐝, 𝐓𝐮𝐦𝐛𝐥𝐫, 𝐨𝐫 𝐨𝐭𝐡𝐞𝐫 𝐰𝐞𝐛𝐬𝐢𝐭𝐞𝐬?
The automatic import feature currently works 𝐨𝐧𝐥𝐲 𝐰𝐢𝐭𝐡 𝐀𝐫𝐜𝐡𝐢𝐯𝐞 𝐨𝐟 𝐎𝐮𝐫 𝐎𝐰𝐧 (𝐀𝐎𝟑) links. However, you can still manually enter stories from any fanfiction website, including FanFiction.net, Wattpad, Tumblr, SquidgeWorld, or personal author websites.
𝐃𝐨 𝐈 𝐧𝐞𝐞𝐝 𝐚𝐧 𝐀𝐎𝟑 𝐚𝐜𝐜𝐨𝐮𝐧𝐭?
No. You don't need an AO3 account to use the tracker. As long as the work is publicly accessible on AO3, you can paste its link into the spreadsheet and import the available information.
𝐖𝐢𝐥𝐥 𝐦𝐲 𝐝𝐚𝐭𝐚 𝐬𝐭𝐚𝐲 𝐩𝐫𝐢𝐯𝐚𝐭𝐞?
Yes. Once you've saved the spreadsheet to your device or cloud, your reading tracker lives in your own digital space. Only you can access it unless you choose to share it with someone else.
𝐂𝐚𝐧 𝐈 𝐜𝐮𝐬𝐭𝐨𝐦𝐢𝐳𝐞 𝐭𝐡𝐞 𝐬𝐩𝐫𝐞𝐚𝐝𝐬𝐡𝐞𝐞𝐭?
Yes! You're free to personalize it with your own charts, categories, filters, and additional tabs if you'd like.
