Difference between revisions of "Uploading Data"

From Explore Analytics: The Wiki
Jump to navigation Jump to search
Line 6: Line 6:
  
 
*'''Compression''' - the CSV file may be compressed in ZIP format. Explore Analytics will automatically detect that and automatically uncompress the file.
 
*'''Compression''' - the CSV file may be compressed in ZIP format. Explore Analytics will automatically detect that and automatically uncompress the file.
*'''Encoding''' - the CSV file may have text using a wide variety of character encoding such as those for Latin characters, Asian languages or Unicode. In most cases, Explore Analytics will automatically detect the specific encoding without requiring the user to make a selection.
+
*'''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, Explore Analytics will automatically detect the specific encoding without requiring the user to make a selection.
 
*'''Delimiter''' - CVS files typically use a comma to delimit (separate) fields, however other delimiter characters may be used instead such as Tab, space, vertical bar or semicolon. In most cases, Explore Analytics will automatically detect the specific delimiter character without requiring the user to make a selection.
 
*'''Delimiter''' - CVS files typically use a comma to delimit (separate) fields, however other delimiter characters may be used instead such as Tab, space, vertical bar or semicolon. In most cases, Explore Analytics will automatically detect the specific delimiter character without requiring the user to make a selection.

Revision as of 02:01, 17 June 2012

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.

Format

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

  • Compression - the CSV file may be compressed in ZIP format. Explore Analytics will automatically detect that and 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, Explore Analytics will automatically detect the specific encoding without requiring the user to make a selection.
  • Delimiter - CVS files typically use a comma to delimit (separate) fields, however other delimiter characters may be used instead such as Tab, space, vertical bar or semicolon. In most cases, Explore Analytics will automatically detect the specific delimiter character without requiring the user to make a selection.