|First, a thank you: Several authors have contributed to this database by giving me the information on their ace and aro characters, saving me a lot of time and making the information contained here much more reliable. Thank you so much for your time--I know how precious it is. Second, a caveat: Classification is a great tool to find what you want, but it has its flaws. I had to create broad categories for this, and sometimes a story doesn’t fit neatly into these. "Word used", for example, can mean anything from the quick use of "asexual" to extensive On page description. And while it’s nice to have an idea of which ship happens with the ace characters, a quick look at the Chameleon Moon series and its network of polyamorous relationships quickly shows the limitations of my column. But I think these tables have the potential to do what I set out to accomplish: allow asexual and aromantic people to find themselves in a wide range of stories. Our narratives are out there, but too often it’s hard to find more than the same handful of well-known (and sometimes not-that-great rep) recommendations.These tables will let you differentiate characters by the role they play in the story, by their gender, by their aromantic and asexual orientation, and so much more. It’s my hope that one can modulate their search enough to find wonderful works that fill precisely their craving. So get filtering, and may your subsequent reads be richer for it. Cheers, Claudie Arseneault|
How to use the spreadsheets
You can click the tabs and view the full database if you wish. Congratz, you have access to the full information!
|Looking for something more precise? You will need to create a filter view! The instructions below are a simple How-to. If that is not enough, contact me! I have prepared a more lengthy tutorial and am absolutely pleased to answer questions.|
1. Select the appropriate sheet (asexual or aromantic)
2. Click on the Data menu
3. Go to "Filter views". It will open a new menu on the right
4. Hit "Create New Temporary Filter View"
This will open a temporary view which allows you to manipulate the database at will without ever breaking the original! From there, you can filter out at will!
1. Choose the column you want to use as a filter. For example, if you want novels only, use "Length".
2. In the column header, click the little arrow at the top right corner of the cell. This opens the filter window.
3. Uncheck what you want removed, check what you want to keep. There are options to Clear All/Check All.
4. Hit "OK". You should now only lines for which the cells contained the checked option.
5. Rinse and repeat with as many filters as you want, until you have exactly what you'd like to read!
|Since you do not have editing rights, your views will always be temporary. Only I can create permanent ones (a few already exist and are listed). If you think a permanent view could benefit everyone, don't hesitate to contact me!|
That's it! Hit the X at the top right corner to close a view, and you're done! If it doesn't work, please don't hesitate to tell me!
Enjoy all the juicy ace and aro rep!
Please note that the sheet is frozen below row 1 (for headers) and on the right of column B (to keep author and title visible at all times)
Column headers and definitions
Story (or anthology) title
Name of the series (if applicable)
|Length||The length of the story. These categories are somewhat arbitrary numbers but I've based them on what is generally understood by them.|
Up to 10,000 words
10,000 to 50,000 words
50,000 to 80,000 words
More than 80,000 words
Short story is part of an anthology (please list the Anthology in "series")
Published in several installments on internet (blog, Wattpad, etc.)
|Type of rep||How involved the representation is. This description only encompasses the title stated. If, for example, a character is aromantic but it is only mentioned in the second book of a series, then the first book remains "Word of God". The second will show "On Page" or "Word used", depending on context.|
Word of God
|The character’s sexuality is not explicited on page, but the author has confirmed it. This means it may never come up as a narrative element, so be warned!|
|On page||The character’s sexuality is explicitly demonstrated within the text. It should be stated, discussed, or showed to an extent that makes it clear to the readers.|
The identity is stated using the actual word (this usually means it is also On Page)
Character's gender (nonbinary characters are put together)
The character's importance to the story
The character is at the heart of the story's central storyline
The character plays an important role in the story and is frequently on page
The character plays a minor role in the story
|Asexuality / Aromanticism|
The nature of the character's asexuality or aromanticism (where on the spectrum?)
|Romantic / sexual orientation|
The character's romantic or sexual orientation
Is the character in a queerplatonic relationship?
|Pairing (QPP or romantic)|
If the character is in a relationship (qpp or romantic), what are the genders involved?
|Read||Y = Read by Claudie (feel free to reach out to me and ask me questions if marked as Read, but please understand I am no encyclopedia!)|
|Rep warnings and notes|
Warnings or notes with regards to the representation.
|Other warnings and notes||Everything else! This includes notes about polyamory, warnings about book content, explanations, and everything that couldn't fit in the neat boxes elsewhere. I can't guarantee all trigger warnings are there, so be careful <3|
Entries that have last been added to the database. I check/uncheck them when I update with more.