topic Re: Load data to a google sheet using JMP in Discussions

Load data to a google sheet using JMP

Eduardo — Mon, 07 May 2018 13:36:47 GMT

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

Re: Load data to a google sheet using JMP

briancorcoran — Mon, 07 May 2018 19:08:04 GMT

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

Re: Load data to a google sheet using JMP

FN — Tue, 09 Jun 2020 09:02:50 GMT

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