Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
This hands-on activity allows you to practice using Workflow Builder to import data from Excel, reshape the data table in JMP, then build a graph using Graph Builder.
The attached PDF contains the activity and solution using the attached Excel file.