How do I convert an Excel file (.xlsx) to an .smi file format?
So a smi file is simply a text file formatted SMILES tab name newline.
Therefore what you need to do is

save for safety
make a new sheet
copy the SMILES column and the name column
save as tab separated file
in Finder/Nautilus/File Explorer rename the file extension to .smi