Importing a Google Spreadsheet

Explore Analytics can import data from a Google Spreadsheet. By giving Explore Analytics 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.).

Explore Analytics will automatically detect numeric and date/time columns. Once imported, your data is ready for analysis and visualization.

Importing a Google Spreadsheet

1. Navigate to Data > Import a Google Doc Spreadsheet

   

2. You will see an info-message informing you of the required permissions. Review, and click Okay.

   

3. Follow the instructions from Google to authorize Explore Analytics access. This is a one-time permission.
4. Select the Google Spreadsheet to import.

   

5. If there are multiple worksheets, select the worksheet to import.

   

6. Define the table and fields.