Since I shared my Veronaville tracking spreadsheet in my recent video on setting up neighborhoods, I’ve had a request to share my spreadsheets for all the Sims 2 basegame ‘hoods. So here they are!
This is the method I use to track my households as a rotational player. It makes planning and keeping up with sometimes dozens of individual Sims much easier for me. The spreadsheets include all the information that I personally track, but they are quite easy to edit if you want to add or remove columns.
Contents
Each spreadsheet is populated with the information available at the start of the game for both playable families and Family Bin families for that ‘hood, including:
- Household Name
- First and Last Names
- Role in the Family
- Age (Child, Adult, Elder, etc.)
- Zodiac Sign
- Aspiration
- Career, Level, and Job
- Hidden Aspiration Tokens
- Gender Preference (if it is anything other than straight)
There are also unpopulated columns for things that are unknown or that you may want to change, depending on your play style. These include:
- Secondary Aspiration
- Lifetime Want
- Hobby and Sub-Hobby
- Bank Account
- Generation
- Partner
- Notes
You may want to remove some of these, for example if you don’t use secondary aspirations or play using my sub-hobby system. You may also want to add columns if you track things like high school grades, college degrees, turn-ons and turn-offs, or whatever.
Color Coding
The spreadsheets are also color-coded. All unmarried Sims have a color assigned, based on age. Feel free to remove or change this if you like. This is just the way I like to track because it makes it easier to pair up Sims in different age groups at a glance.
It’s pretty easy to figure out, but here’s a legend anyway:
- Baby/Toddler: Blue
- Child: Orange
- Teen: Red
- Adult: Green
- Elder: Purple
How to Use
The spreadsheets are available via Google Sheets. In order to use them, you need to copy the sheets to your own Google Drive. You can also download the copy and open it with Excel or Open Office if you prefer.
To make a copy, click “File” in the taskbar at the top right of the screen. Then choose “Make a Copy” from the drop down box. Then you’ll be able to name the document and save it to your own drive.
Spreadsheet Links
Following are the links to all three spreadsheets. I also included a completely blank spreadsheet (with just the headings) if you want to use it for custom neighborhoods.
I hope these help you with tracking your Sims! If you like them, leave a comment and let me know. Thanks for stopping by!
I really appreciate this and the video! I’m using this as a guide for tracking my rotational Test of Time challenge for The Sims 3. The rotational version of the challenge is pretty complicated to get in order, but it’s been worth it 😸
Thanks so much! I use this for my Sims Freeplay town.
You’re welcome! Glad you found it useful!
Hi Cindy! I “accidentally” asked you for permission to use the spreadhseet. I already copied and used for my Pleasant View gameplay. Sorry for some kind of spam or anything like that <3
PS: I love you Youtube channel and your Twitch channel, hugs from Brazil <3
No worries! And thank you!
Thank you very much! This is really helpful!
This is really cool; definitely trying it out! One question: do you remove dead sims from the spreadsheet?
Hi! I move them to a new tab I label “Cemetery.” Then I keep track of my dead Sims there by family.
This seriously has made me so very happy, people have told me for years that making excel files to keep track of my sims is crazy so it is so wonderfully validating to see someone else make them, and in such a similar way haha.
Anyway, thank you!!!
Not crazy at all Joanna! There are a lot of people who play this way! 🙂
I am just rebooting Pleasantview so this is perfect. One question: how do you move a Sim’s information when they marry/move in with another family?
I just copy the line and paste it under their new family, then delete the line from the old entry. 🙂
Thanks so much for this! ♥
You’re very welcome!