topic How do I import data from excel? in Discussions

How do I import data from excel?

giorgio_giudici — Sat, 10 Jun 2023 23:35:31 GMT

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

Re: How do I import data from excel?

txnelson — Sat, 14 Aug 2021 10:16:28 GMT

By default, to determine if a column should be read in as numeric, JMP reads down a column testing that values in a column are either numeric of character. Only if no non numeric values are found, does JMP read in the column as numeric. However, this is not really a problem. Once the column is in JMP, it is easy to convert the column to numeric. Just go to the Column Info screen and change the data type and modeling type to Numeric, Continuous. JMP will then convert all rows to numeric, setting all rows that are not numeric values to a missing value.

What method are you using to import the data?

Have you go through the document "Discovering JMP" under the Help pull down menu?

What version of JMP are you using?

Could you attach a sample Excel file to aid in solving your issue?

Re: How do I import data from excel?

giorgio_giudici — Thu, 19 Aug 2021 16:17:16 GMT

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

Re: How do I import data from excel?

txnelson — Fri, 20 Aug 2021 01:47:59 GMT

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?

Re: How do I import data from excel?

giorgio_giudici — Wed, 25 Aug 2021 15:36:19 GMT

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