See how to open Excel files and use the Excel Import Wizard.
The Excel Import Wizard is built into JMP and will help guide you through pulling in data that could be anywhere in an Excel workbook, within one or more Excel worksheets.

We need to get data into the right structure for analysis in JMP, and the Excel Wizard will help us accomplish this. JMP has a structured row/column approach to data, where columns represent a single construct, variable or attribute. JMP uses a row to represent a single unit or observation, so that all the data across the row in all the rest of the columns reflect only that one unit or observation.
Resources: