Simple Animation in Unity
How to create an Animation in Unity from a Spritesheet

The easiest way to animate an object from a sliced spritesheet is:
1. Select all sprites (by clicking with the mouse holding shift)
2. Drag and Drop them into the Hierarchy
3. Save animation
4. Run the game to see the animation.
The default is to loop the animation. In Project panel you can select the created animator and uncheck Loop time.

Automatically an animation controller is created as well. This is relevant for more complex animations. You will find the controller in the same place as where you saved you animation. This is an topic for another day.
Another way
Target GameObject selected > Window > Animation > Create > Save (in animations assets folder)
Target GameObject selected > Animation panel > Record button > Drag and drop all frames > Stop Record Button