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