Difference between revisions of "Importing a Google Spreadsheet"
Jump to navigation
Jump to search
Guy.yedwab (talk | contribs) |
Guy.yedwab (talk | contribs) |
||
| Line 4: | Line 4: | ||
#Navigate to '''Data > Import a Google Doc Spreadsheet''' | #Navigate to '''Data > Import a Google Doc Spreadsheet''' | ||
| − | #:[[Image:GS1.png| | + | #:[[Image:GS1.png|250px]] |
#You will see an info-message informing you of the required permissions. Review, and click '''Okay'''. | #You will see an info-message informing you of the required permissions. Review, and click '''Okay'''. | ||
| − | #:[[Image:GS2.png| | + | #:[[Image:GS2.png|250px]] |
#Follow the instructions from Google to authorize Explore Analytics access. This is a one-time permission. | #Follow the instructions from Google to authorize Explore Analytics access. This is a one-time permission. | ||
#Select the Google Spreadsheet to import. | #Select the Google Spreadsheet to import. | ||
| − | #:[[Image:GS3.png| | + | #:[[Image:GS3.png|250px]] |
#If there are multiple worksheets, select the worksheet to import. | #If there are multiple worksheets, select the worksheet to import. | ||
| − | #:[[Image:GS4.png| | + | #:[[Image:GS4.png|250px]] |
#Define the table and fields. | #Define the table and fields. | ||
Revision as of 10:55, 26 January 2013
Explore Analytics can import data from a Google Spreadsheet. By giving Explore Analytics a one-time permission to access your Google Drive, you can select from your list of spreadsheets. Google Spreadsheets can be imported regardless of the underlying data format (.csv, .xls, .ods, etc.).
Importing a Google Spreadsheet
- Navigate to Data > Import a Google Doc Spreadsheet
- You will see an info-message informing you of the required permissions. Review, and click Okay.
- Follow the instructions from Google to authorize Explore Analytics access. This is a one-time permission.
- Select the Google Spreadsheet to import.
- If there are multiple worksheets, select the worksheet to import.
- Define the table and fields.
