Showing results for 
Show  only  | Search instead for 
Did you mean: 
How To Connect To Google Sheets Using New Method in JMP 17.1 and Newer


In JMP 17.1, JMP updated the Google Sheets connection method due to changes in Google’s access requirements.

This change requires the removal of the old authorization tokens provided by Google and reconnecting to your Google account.  Failure to remove the old Google authorization tokens will result in an error (see JMP Note 579563).  The following instructions show you how to remove the old Google authorization tokens and successfully connect Google Sheets using the new method.

Remove Old Google Authorization Tokens and Reconnect Google Sheets

Remove old Google authorization tokens

For Windows:

  1. Press Windows key + R to open a Run window
  2. Enter  %APPDATA%\SAS\JMP
  3. Press Enter
  4. Find all files that are named OAuthTokens and delete them

 For macOS:

  1. In Finder, select Go > Go to Folder…
  2. Enter ~/Library/Application Support/JMP
  3. Find all files that are named OAuthTokens and delete them


Authorize JMP to access your Google account

  1. Open JMP
  2. Select File > Internet Open > Google Sheets
  3. Enter your Google Account email address for Google account
  4. Enter the Google Sheet web address for Spreadsheet URL or ID
  5. Click Settings



6. In the Sign in with Google window, click Launch Browser




7. Select the Google account you want to use to sign in

8. Click Continue



9. In the browser window that opens, copy the web address (URL) from the address bar (see yellow outline)




10. Paste the web address in the Sign in with Google window (outlined in blue)




11. You will be presented with the import settings for the Google Sheet you are attempting to import.


You have now connected your Google Sheet to JMP.


Additional Information

You can find more information about using Google Sheets in the JMP Online Help.

If you need additional assistance, please contact JMP Technical Support at or by phone at 1-800-450-0135. 

Operating System
macOS Windows
Fixed Version
Products JMP JMP Pro