Formatting Spreadsheets and Other Files

You can upload Microsoft Excel spreadsheets (XLSX and XLS), CSV files, and TXT files and then create datasets from them.

Note: The maximum file size you can upload is 250 MB and the data column limit for a single file is 250 columns.

Formatting Rules For Excel Spreadsheet Files

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 is repeated on every page of a printed report.
Tables don't contain pivoted data.
Row 1 contains unique names of the columns in the table.
Row 2 and greater contain data for the table.
Data in a column must be of the same type. For example, don't use a phone number column to hold email addresses.
Data is at the same granularity.

Also see, How To Stop Excel From Changing Number Format to Scientific Notation? (Doc ID 2234511.1)

Click here to see an example of an Excel spreadsheet formatted for CIC Analytics. l

Encode source files using UTF-8.
Before you edit your files, configure your text editor to use the appropriate font and script (or subset).