I just managed to setup import of contracts. Sadly my spreadsheet seems to miss some players.
I used
https://www.spotrac.com/nhl/contracts/ to create it.
Ovechkin surprisingly is one of the missing ones so I had to add him manually.
Does anyone know of another site that presents all NHL player contract cap hits and lengths on one single page?