Load data to a google sheet using JMP

Question

Hello everybody,

I was wondering if it was possible to load data to a google sheet using JMP. I'm running a script, it generates some numbers, and I would like those numbers to end up in a google sheet. Any ideas on how to do this?

Cheers,

Eduardo

FN · Answer

If you have JMP 15 (2019 release), you can do it now

https://www.jmp.com/support/help/en/15.1/#page/jmp/import-data-from-google-sheets.shtml

briancorcoran · Answer

Hi Eduardo,

You can save the JMP data as an Excel file or a CSV file.  In Google Sheets, open a blank table.  Now, import the data using File->Import file from a known folder and select "replace sheet" to replace the blank sheet with the import data.

Brian Corcoran
JMP Development