Create a Dataset From a File Uploaded from Dropbox, Google Analytics, or Google Drive

You can upload Excel spreadsheets (XLSX or XLS), CSV files, and TXT files from Dropbox, Google Analytics, or Google Drive and use them to create datasets.

Note:

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

Before you create the dataset, confirm that the connection you need exists.

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

• The file is either an Excel spreadsheet in .XLSX or .XLS format, a CSV file, or a TXT file.
• The spreadsheet contains no pivoted data.
• The spreadsheet is structured properly for import and use as a dataset.

1. On the 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 page's Name field, provide a name for the dataset table created from the file.
5. If you’re uploading a CSV or TXT file, then in the Separated By, Thousand Separator, and Decimal Separator fields, confirm or change 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.
6. Click OK to upload the file and create the dataset.