There are a total of 5 Treasure Vaults to be found in the Hogsmeade Valley region of Hogwarts Legacy. To open all of them you’ll need Level III in the Alohomora spell. You’ll also need access to the Accio spell, Confringo spell, and preferably the Wingardium Leviosa spell.
Treasure Vault Locations - Hogsmeade Valley
Treasure Vault #1 - East of Hogsmeade Village
The first Treasure Vault that we’ll cover can be found east of Hogsmeade Village, as shown in the screenshot below. There are no puzzles associated with this one, but there are quite a few Dark Wizards and Witches guarding the entrance to the cave. You can choose to kill these first or just run in and loot the chest, which can be found at the end of the cave.
Treasure Vault #2 - West of the Falbarton Castle Floo Flame
The next Treasure Vault can be found to the northeast of the first, just to the west of the Falbarton Castle Floo Flame. There are no enemies outside the entrance to this one, but you will need to have Level II in the Alohomora spell to unlock a gate and gain entrance to the cave. You can increase the level of your skill by finding Demiguise Statues for The Man Behind the Moons quest. See the links below for where to find all of them in different regions:
Treasure Vault #3 - West of Upper Hogsfield Floo Flame
This one is located in the northwest of the Hogsmeade Valley, near the border with the Forbidden Forest. There are a number of undead enemies guarding the entrance to the cave, so you’ll need to use fire-based spells such as Incendio or Confringo to make them vulnerable to regular attacks. Once they’re dead, you’ll find that you need to open a door which requires Level III in the Alohomora spell to unlock. See the links detailed in Treasure Vault #2 to find more Demiguise Statues for this.
Treasure Vault #4 - Northeast of the Upper Hogsfield Floo Flame
You’ll find this Treasure Vault northeast of the Upper Hogsfield Floo Flame, in the northern part of the Hogsmeade Valley. The area is surrounded by enemies but you can actually just fly to the entrance of the cave on your broom, then get off and enter the cave undetected. The chest is at the end of the cave and there are no puzzles required to open it.
Treasure Vault #5 - East of the East North Ford Bog Floo Flame
This one is located just to the northwest of Treasure Vault #4, or east of the East North Ford Bog Floo Flame. There’s more of a puzzle associated with opening this one, and you’ll need to have at least the Accio spell and the Confringo spell to solve it. You’ll notice that the entrance to the cave is blocked, and you can only open it by pulling a nearby magical object onto the platform in front of the entrance. You can do this easily enough with Accio, but you’ll have more accuracy with the more advanced Wingardium Leviosa. Either way, once the object is on the platform, aim at it and cast Confringo to set it alight. This will open the door to the cave, and you can find the chest at the end of it.