Just be sure to pair or plug in your controller before opening Steam or any Steam games, or else your controller may not be recognized (click the link to jump down to the Bluetooth section of this guide). Thanks to official Steam support, there's almost no setup involved in getting your PS4 controller working in Steam.
Remap from Settings Controller tab/in game.
