Create a Dataset from a File Uploaded from Your Computer

You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from your computer to create a dataset.

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, either drag and drop a file to the dialog, or click Drop data file here or click to browse to browse your computer for a file to upload.
3. In the Create Dataset Table dialog, use the Name field to change the default dataset name if required.
4. 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.
5. 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.
6. Click OK to upload the file and create the dataset.