topic Re: can JMP open google sheet? in Discussions

can JMP open google sheet?

wma1125 — Sat, 03 Oct 2015 03:14:11 GMT

any way JMP can open or import google sheet?

Re: can JMP open google sheet?

Craige_Hales — Wed, 19 Oct 2016 00:50:02 GMT

yes. Be careful how much you share, you almost certainly want to restrict who can view your documents. It looks like you can do that in the dialogs below, but I did not experiment.

steps to make a google sheet: pick new:

pick sheet:

give it a name...

pick share:

ask for a shareable link. I did not choose anybody for editors. It is shared with the world if you have the link. I think this is where you can restrict viewers as well.

copy the link. As you can see, this doc is open to the world...

modify the link. Google Groups ( productforums.google.com/forum/#!topic/docs/An-nZtjaupU ) suggested a change like this:

....7E/edit?usp=sharing

becomes

....7E/export?format=csv&id

at the end of the link.

finally, use the JMP open function (JSL) to view it. (Or use File->InternetOpen->OpenAs->Data with the same URL)

open("https://docs.google.com/spreadsheets/d/1A...........7E/export?format=csv&id")

There's a bunch of unanswered questions here, join the discussion!

Re: can JMP open google sheet?

ram_asra_gmail_ — Sun, 04 Oct 2015 17:58:20 GMT

I tried same steps as above. but could not access it through jsl.

the only dfference i could see is, that here" anyone can view"

where in my case i have " anyone at company an view"

and it gives a error "Unable to read data from"

Re: can JMP open google sheet?

wma1125 — Mon, 05 Oct 2015 15:23:58 GMT

thanks for the tricks, Graige.. I tried it with my companies share link. it can't open it with message in log window: "Caution: redirected to ........."

Re: can JMP open google sheet?

msharp — Mon, 05 Oct 2015 16:35:32 GMT

Google won't know JMP is part of the user group unless you pass the credentials. You may be logged in but JMP isn't. I'm betting you are going to need to use a socket function here. I will have to play around sometime when I have time.

Re: can JMP open google sheet?

Craige_Hales — Mon, 05 Oct 2015 17:08:33 GMT

It may need SSL; JMP's sockets don't do SSL. You might need to use cURL and RunProgram to do the authentication. Here's a link that might be useful:

developers.google.com/drive/web/manage-downloads Download Files | Drive REST API | Google Developers

Re: can JMP open google sheet?

jojo — Mon, 19 Oct 2015 13:44:05 GMT

I also recently started using Google Sheets and trying to find the best way to import some data files into JMP with JSL. If anyone has figured out what needs to happen I would really appreciate it. Seem to be running into the same errors as the others above...

Re: can JMP open google sheet?

FN — Tue, 09 Jun 2020 09:01:34 GMT

I know it is an old discussion, but JMP 15 includes this option now.

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