This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
Eduardo
Eduardo
Level III

Load data to a google sheet using JMP

May 7, 2018 09:36 AM (2785 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 (2757 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 (1126 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