Difference between revisions of "Uploading Data"
Jump to navigation
Jump to search
Gadiyedwab (talk | contribs) (→Format) |
Gadiyedwab (talk | contribs) |
||
| Line 1: | Line 1: | ||
Explore Analytics makes it easy to upload data in [[Glossary of Data Analysis and Visualization Terms#CSV File|CSV Format]]. If you have data in Excel, you'll first need to save it as a CSV file. | Explore Analytics makes it easy to upload data in [[Glossary of Data Analysis and Visualization Terms#CSV File|CSV Format]]. If you have data in Excel, you'll first need to save it as a CSV file. | ||
| − | =====Format===== | + | =====Automatic Detection of CSV Format===== |
| − | Explore Analytics is designed to automatically detect the following aspects of the file being uploaded rather than ask | + | 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 | + | *'''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 | + | *'''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 | + | *'''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 | ||
Revision as of 06:06, 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.
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
