As Mr. Smooth stated, there are no spells available to unlock chests or doors.
The Tower Stone effect does allow you to unlock one Expert level (or lower) lock per day.
gaming.stackexchange.com/users/4239/Doozer Blake
There's no spell that I know of, but you should know that if you have a follower, they can pick any lock on a chest, regardless of difficulty.
Just talk to them and tell them you need them to do something, and then direct them to unlock the chest.
Here's a reference.
gaming.stackexchange.com/users/15156/Jeff Burka
There is no spell in Skyrim that will unlock doors or chests for you (sadly).
I'm afraid if you want to unlock things
then you're going to have to level your lockpicking (or have a lot of lockpicks).
gaming.stackexchange.com/users/12087/Mr Smooth
Midas Magic mod adds these spells.
gaming.stackexchange.com/users/39347/Guest
The mod, Ancient Spells - Morrowind and Oblivion Spells , adds an " Open Easy/Average/Hard/
Very Hard locks on
target " spell under Alteration.
Upon installation, you can buy these spells (given you have the skill required for them) from the usual merchants that sell spells.
The majority of the spells are on leveled spells merchants (this means that if a illusion spell needs a perk point on for example Master Illusion
you will not see it untill
you have that perk like the other spells on the game), beginner spells can be found regardless on Riverwood and Whiterun.
gaming.stackexchange.com/users/4797/galacticninja
I have played Skyrim for some time as a magic user, and I have by no means visited the entire world yet.  But I'm puzzled that none of the characters I have met that sell spells have any spell to unlock locks.  Is there no such spell, or have I just not found it yet?
Are there any unlock spells in Skyrim?
gaming.stackexchange.com
<the-elder-scrolls-5-skyrim>
gaming.stackexchange.com/questions/38103
gaming.stackexchange.com/users/6454/Pete
There are no spells to unlock chests or doors. You can pick locks, though. It seems that there is not such spell that unlocks anything locked.
The community explains that it is impossible.