For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Save and Share Your Data > Save Data Tables > Save JMP Data as a Google Sheet
Publication date: 05/05/2023

Save JMP Data as a Google Sheet

A Google Sheet is a spreadsheet that is saved in your Google account. Exporting a JMP data table to Google Sheets enables you to share the data with others and edit the data outside of JMP.

You can export a JMP data table to an existing Google spreadsheet or create a new one.

To export a JMP data table as a Google spreadsheet, follow these steps:

1. If you are exporting to an existing spreadsheet, perform these steps first. Otherwise, go to step 2.

a. From a browser, log in to https://sheets.google.com.

b. Open the existing spreadsheet.

c. Copy the URL from the browser’s address bar.

2. In JMP, open the data table with the data that you want to export.

3. Select File > Export > Google Sheets.

4. Under Spreadsheet Type, choose either Existing or New Spreadsheet.

5. Enter your Google account name. (@gmail.com is unnecessary.)

6. (Existing spreadsheets only) Next to Spreadsheet Name, paste the URL of the Google spreadsheet that you copied in step 1.

7. (New spreadsheets only) Enter a name for the new spreadsheet.

8. Enter the name of the sheet (the tab name).

9. Click Save.

10. If you have already exported a data table from JMP, the data appears in Google Sheets. Go to your Google spreadsheet to see the data in the specified sheet.

or

If you are exporting data using the specified Google account for the first time, you are prompted to give JMP access to your Google account.

a. Click Allow.

b. Go to your Google spreadsheet to see the data in the specified sheet.

Depending on the size of the data table, the Save operation might take some time.

About Exporting Google Sheets

Information that Google uses to authenticate your account is stored in C:\Users\<user name>\AppData\Roaming\SAS\JMP\OAuthTokens.jmp on Windows. On Mac, oAuthTokens.jmp is stored in ~/Library/Application Support/JMP. (Passwords are not stored on the computer, and access tokens are encrypted.) Storing tokens in a data table enables you to import and export data using the same Google account without providing the authentication information again. Note that a user with access to your computer’s user account has access to all of your Google spreadsheets. If the spreadsheets contain confidential information, reconsider sharing your user account.

JMP features such as formulas and List Check column properties are not supported in Google Sheets.

If the spreadsheet is empty, look in the JMP log for error messages. On Windows, select View > Log. On macOS, select Window > Log.

If a Google Sheet has only one sheet, you cannot replace the sheet with a new sheet. Add a second sheet with a unique name and then delete the original sheet. In the Export to Google Sheets window, select Existing Spreadsheet and export the data table again. The sheet name that you specified appears in the sheet.

See About Importing Google Sheets for more information about security, country restrictions, and more.

If Display intranet sites in Compatibility View in Internet Explorer on Windows is selected, the Google Sheet cannot be exported. To avoid this issue, follow these steps:

1. In Internet Explorer, select the Tools button Image shown here and then select Compatibility View settings.

2. Deselect Display intranet sites in Compatibility View.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).