Uploading Data

Explore Analytics makes it easy to upload data in CSV Format. If you have data in Excel, you'll first need to save it as a CSV file.

Automatic Detection of CSV Format

Explore Analytics is designed to automatically detect the following aspects of the file being uploaded rather than ask you to specify them.

• Compression - the CSV file may be compressed in ZIP format. Explore Analytics will automatically uncompress the file.
• Encoding - the CSV file may have text using a wide variety of character encodings such as those for Latin languages, Asian languages or Unicode. In most cases.
• Delimiter - CVS files typically use a comma to delimit (separate) fields, however a Tab, space, vertical bar or semicolon may also be used as a delimiter.
• Field Names - the first line in the CSV file may contain field names, however, a CSV file is valid even if it does not contain field names. This is automatically detected and if column names are absent, you can provide them during the upload.
• Field Types - the following types are automatically detected
  • datetime - date or date and time
  • decimal - decimal number
  • integer - integer number
  • varchar - varying-length character: text or any character data such as codes or abbreviations