Click this link and download using Excel. This will not work currently in Google Sheets.
This is a video explaining how to use the Ranking Tool.