Create a Dataset from a File Uploaded From Your Computer

You can upload Excel spreadsheets (XLSX or XLS), CSV files, and TXT files from your computer and use them to create datasets.

Note:

Files 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 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. See About Files for Datasets.
  1. On the Home page, click Create and then click Dataset.
  2. In the Create Dataset dialog, either drag and drop a file to the dialog, or click the Upload icon to browse your computer for a file to upload.
  3. In the Add Dataset page, provide a name for the dataset.
  4. 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.
  5. Click Add to upload the file and create the dataset.