The data are imported into a JMP data table.About Importing Google Sheets

• Information that Google uses to authenticate your account is stored in C:\Users\<user name>\AppData\Roaming\JMP\JMP\OAuthTokens on Windows. On Mac, oAuthTokens 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 with 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.

• @gmail.com is not required for your account name. However, if you do use it, <user name>@gmail.com and <user name> are treated as separate accounts. You must enter the authentication code for both accounts when importing or exporting.

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

1. In Internet Explorer, select the Tools button () and then select Compatibility View settings.

2. Deselect Display intranet sites in Compatibility View.

Note: In Google Sheets, you can select File > Publish to the web to publish the sheet for an audience to view. In this case, the link to the published sheet includes the pubhtml suffix. Use File > Internet Open to open these sheets. See Import Data from the Internet or a Remote Computer.