About Files for Datasets

You can upload Microsoft Excel spreadsheets (XLSX and XLS), CSV files, and TXT files and then create datasets from them. The maximum file size you can upload is 250 MB and the data column limit for a single file is 250 columns.

Start by creating a simple Excel spreadsheet with no pivoted data. Make sure that:

  • Tables start in Row 1 and Column 1 of the Excel file.
  • Tables have a regular layout with no gaps, repeated column names, or inline headings. An example of an inline heading is one that's repeated on every page of a printed report.
  • Row 1 contains the unique names of the columns in the table.
  • Row 2 and greater contain the data for the table.
  • Data in a column is of the same type. For example, don't use a phone number column to hold email addresses.
  • Data is at the same granularity.