As mentioned in the comments, you need to download the .asc grid format from the download page (see image below). After that you can use QGIS > Raster > Translate to convert the .asc grids to geotiffGeoTIFF. The data does download in individual tiles so you may also need to mosaic them or create a virtual raster or similar
