GIS software prefer tabular data to be in .csv format, rather than .xlsx. So before attempting to bring any spreadsheets into QGIS, make sure to save as .csv