You should see a JMP data table. If you are seeing excel opening a spreadsheet, something else is going on. If you open the .xlsx manually from JMP's file->open dialog, you'll land in JMP's import wizard which will help you do the first import. You can use the Source script in the JMP data table to repeat the process without going through the wizard.
Craige