Add Multiple Files to a Dataset

A dataset can include more than one file uploaded from your computer or from Dropbox or Google Drive.

Note:

Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.
Before you add a file from a connection, confirm that the connection you need exists. See View Available Connections.
A dataset can contain tables created from files and connections. See Add a File to a Dataset Created from a Connection.
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.
  • The spreadsheet contains no pivoted data.
  • The spreadsheet is structured properly for import and use as a dataset. See About Files for Datasets.

Tutorial icon Tutorial

  1. On your home page, click Navigator , then click Data.
  2. Click the Datasets tab.
  3. Locate the dataset that you want to open, click Actions, and then click Open.
  4. Locate the file:
    • If the file you want to add is located on your computer, then in the Dataset editor's Connections pane, click Add, and click Add File.
    • If the file you want to add is located on Dropbox or Google Drive, then in the Dataset editor's Connections pane, click Add, and then click Add Connection.
  5. Browse for and select the file that you want to upload.
  6. In the Create Dataset page's Name field, provide a name for the dataset table created from the file.
  7. 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.
  8. Click OK to add the file to the dataset.
  9. In the Connections pane, confirm that the file was added.
  10. Click Save.