ABCDEFGHIJKLMNOPQRSTUV
1
2
To use this sheet, you must save a copy with File -> Make A CopyFor issues with data or sheet, contact @thewinterborn on discord or u/thewintersborn on redditYOU CAN HELP!1.0.1 Apr-04-2026Latest Version
3
4
What is this spreadsheet?
Special thanks to u/auzz1016 for practically all of the data
https://forms.gle/P8uMyoz7kekmZ5w8A
Notes:^If this cell is red, update doc^
5
This is a tool that contains the data for almost every piece of gear in Wizard101. Using this data, the Gear Fetcher tab can search for gear with specific stats and the Character Sheet tab can show the total impact of your gear on stats. Fill out this form to help me fill holes in hp/pip convnersion stats!
-Added Scholomari, Hidden Temple, and Rematch 180 gear
6
-Minor bug fixes
7
8
To do:
Known issues:
9
How to use Gear Fetcher
Streamline set bonuses
-Shadow rating is not known on outdated wiki gear
10
Add 175 Gear
-Missing health/pip conversion stats for many classes/levels
11
Level 100/60 death/storm pins
-Missing several pins for level 140-170
12
Scaling/stat cap compatibility
-Missing level 170-175 gear from Darkmoor expansion
13
14
15
Making a gear guide brb
16
The Gear Fetcher tab will automatically filter out items that you can't equip based on your inputted level and school. Results can further be sorted by stat to make it easier to find the strongest gear. Stats that can be seperated by school have been condensed to reduce size, but can be expanded by clicking the "+" at the top of the sheet. If the stat sorter is missing, it is because you minimized damage; you need to expand the damage section to see the sorter because I'm bad at making spreadsheets.
17
18
19
20
21
22
23
How to use Character Sheet
24
To avoid breaking the sheet, you should only edit cells with white backgrounds. The sheet automatically filters for the inputted school and level. It will also automatically filter for sockets, and any empty socket will not show any drop-down options. You can either type the name of a gear piece or scroll through drop-down options. The stats and bonuses the gear provides will be reflected on the right side of the sheet. Set bonuses and pet rounding are already accounted for. Level scaling is not yet implimented.
25
26
27
28
bro how am i supposed to find these things
29
30
31
32
33
34
How to add pets
35
36
37
38
39
40
41
42
To avoid breaking the sheet, you should only edit cells with white backgrounds. The sheet will automatically calculate the maximum possible stats for your pet given the talents selected; these appear under the blue "Perfect" column. To see what stats your pet actually provides, input the actual stats of your pet in-game under the "Your Stat" column. To see what a potentially perfect pet would give, input the same number you see in "Perfect" to "Your Stat". If your pet is not part of a set bonus, you can leave "Set bonus body" blank. If it is, make sure you have the correct body selected. Your pet's name is entirely custom, you can use its actual name or a representative one like "double triple." To see your pet's impact on your character's stats, input the pet's name in the "Pet" section of the Character Sheet tab. Talents that do not provide stat bonuses can be left blank.
43
44
45
46
47
48
49