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 properties 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

When you select a file to upload, it is analyzed to determine whether your review is required. If your review is not required, you can still choose to review and make adjustments to properties that were detected by selecting "Review and make changes" in the upload dialog.