Choosel allows you to import data using comma separated value (CSV) files. To import a CSV file:
Choosel supports four data types within comma separated value (CSV) data. These are:
The CSV import routine automatically recognizes these data types based on the following rules:
Numeric values must be expressed as decimal numbers, containing one or more digits separated by a decimal point. E.g., 1.0, 4.726355.
Dates must be expressed in the formats dd/MM/yyyy or yyyy-MM-dd where dd is a two digit day form 1 to 31, MM a two digit month form 1 to 12 and yyyy a 4 digit year. These values must be separated by forward slashes (‘/’) for ‘dd/MM/yyyy’ and by dashes (‘-’) for ‘yyyy-MM-dd’. E.g., 23/09/2010 or 2010-09-23 define a date for the 23rd of September, 2010
Locations must be expressed as latitude/longitude pairs using decimal degrees as lat/lon, where lat and lon are both numeric values as described above. E.g., 48.5/110.24 describes a location at 48 degrees 30 minutes 0 seconds North and 110 degrees, 14 minutes, 24 seconds West. To express latitudes south of the equator or longitudes east of the prime meridian, use negative numbers.
To convert a latitude or longitude value expressed in degrees, minutes, and seconds to decimal degrees, divide the minutes value by 60 and add this to the degrees value, then divide the seconds value by 3600 and add this value to get the total. E.g., 110 degrees, 14 minutes, and 24 seconds becomes 110 + 14/60 + 24/3600 = 110.24
Any values that do not conform to the formatting described for numeric values, dates, or locations are considered to be unformatted text data.