How do I import data from excel?

Question

Hello everybody,

I've just begun to use JMP. I'm using JMP on  Windows. I'm trying to import my data from an Excel table, but I don't know why JMP treat numbers as characters, this way I can't handle that variables as continuos.
Does anyone know how to solve that problem?
Thank you in advance for your consideration

giorgio_giudici · Answer

Yes, I don't know why with other columns of my table it didn't work, but I don't know why know I've managed to make it work.
Many thanks for your help

txnelson · Answer

I simply copied the data from your Excel data table

Opened a a new data table

File=>New=>Data Table

And then go to

Edit=>Paste with Column Names

Is this what you need?

giorgio_giudici · Answer

Thanks for the kind response,

For importing data I've copied the my Excel table and pasted in JMP. I actually already tried to substitute the data type from the coloumn info screen to numeric, continuos. What happened is that all my data become dots. I can attach you an exemple of my data in Excel. I'm using the trial versione of JMP 16. 
Thank you for your consideration

data.xlsx