AutoBio Spreadsheets
Auto Bios! Beautiful, wonderful, automatic bio-making spreadsheets. Just fill the fields, copy/paste the provided box, and bam you've got a perfectly formatted standardized bio of your choosing! NOTE: I won't make a bio template for you, but I will take a bio template you've made or found free to use and make it into an autobio spreadsheet.
My spreadsheets all come in the .ods format because I make them in Libre Office Calc, but the no macros versions should all work in Excel just fine since I believe all the functions I use exist in both softwares. I believe macros will not work in Excel because Microsoft has their own proprietary coding language for Excel macros whereas Calc uses Basic.
In theory I can make an autobio for any website that lets you make bios, so long as you can provide me a template for what you want your bios to look like. So far I've only made them for sites that use BBcode, so if you want my help with a site that uses CSS or HTML we will be testing how Calc handles that together! I will also note that using a spreadsheet for one site on another may end up with errors in the bbcode, as not all sites have the same bbcode implementations.
Here I've provided the downloads for a couple versions of my own autobio spreadsheets for Pixel Cat's End. I plan to add the matching versions of my Flight Rising autobios here soon - it needs some revamping because it is Very Old at this point lol.
The fullest version of the spreadsheet with the macros intact.
If you go to use this, you may need to go into Tools > Options > Libre Office (open by default) > Security and tell it to allow macros.
You can also look at the macros by going to Tools > Macros > Organize Macros > Basic, selecting the document from the list that shows up and finding the thing labelled "Clear" in the Standard folder. There you can see all the code I put in the macros and double check I'm not some kind of scammer trying to get into your computer!
The same as the previous BUT without the macros or anything that relies entirely on the macros to function.
It preserves the cat list where you can fill in your cats by hand so you can use autofill and dropdowns tied to it.
If you want to reorder how the cat list works, just make sure to change the vlookup formula in the related boxes; if you're moving the column you need farther away, change the range (the A:[X] value) so that the letter of the column you're targetting matches the second letter in the range. You will also need to change the number directly after the range; that number is how far away from the Name column it is, with the Name column itself being number 1. I really don't advise changing the Name column unless you know how to change all the formulas tied to it!
This is the most pared down version.
It is literally just the boxes to fill in all of your cats' information and copy-paste it out to the site. There are still dropdowns tied to the other sheet, but they're literally just what they say they are on the tin.