cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Eduardo
Eduardo
Level III

Load data to a google sheet using JMP

May 7, 2018 09:36 AM (3197 views)

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

0 Kudos
2 REPLIES 2
briancorcoran
Staff briancorcoran
Staff

Re: Load data to a google sheet using JMP

May 7, 2018 03:08 PM (3169 views)  |  Posted in reply to message from Eduardo 05-07-2018

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

FN
FN
Level VI

Re: Load data to a google sheet using JMP

Jun 9, 2020 05:02 AM (1538 views)  |  Posted in reply to message from Eduardo 05-07-2018

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

0 Kudos