Create a Dataset from a File Uploaded from Dropbox or Google Drive

You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from Dropbox or Google Drive and use them to create a dataset.

Note:

Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.

Confirm that the file that you want to upload meets these requirements:

• The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
• Spreadsheets shouldn't contains pivoted data.
• Spreadsheets are structured properly for import and use as a dataset. See About Files for Datasets.

1. On your home page, click Create and then click Dataset.
2. In the Create Dataset dialog, select a connection.
3. Browse for and select the file that you want to upload.
4. In the Create Dataset Table dialog, use the Name field to change the default dataset name if required.
5. If you're uploading a spreadsheet with multiple sheets, click the Select list to select a single sheet, or click All Sheets to load every sheet.
6. Optional: If you’re uploading a CSV or TXT file, use the Separated By, Thousand Separator, and Decimal Separator fields to configure the default delimiters.
   To specify a custom delimiter, choose Custom in the Separated By field and enter the character you want to use as the delimiter. In the CSV or TXT file, a custom delimiter must be one character. The following example uses a pipe (|) as a delimiter: Year|Product|Revenue|Quantity|Target Revenue| Target Quantity.
7. Click OK to upload the file and create the dataset.