Documentation menu
JS React Angular Vue
JS React Angular Vue

Supported CSV format

In this guide, you can learn how to format your CSV data so WebDataRocks can process it.

CSV format

WebDataRocks supports the following CSV format:

  • The first data record contains field names and optional data type prefixes.
  • Each data record is on a separate line.
  • Field names and values are separated by the same character: comma ,, semicolon ;, or a custom field separator.

Here is an example of a valid CSV file:

Invoice Date, Quantity, Country, Week Day
2018-05-15, 3, France, Tuesday
2018-05-16, 4, Italy, Wednesday
2018-05-17, 2, Spain, Thursday
2018-05-12, 2, Japan, Saturday

Input value formats

Number field format

Number values can contain digits, -, and + characters. Point . must be used as a decimal separator. Numbers in exponential notation are also supported. Examples of valid values: -20, 2.50, 1.0E+2.

String field format

String values can be enclosed in double quotation marks or specified without them. If a field value contains line breaks or a field separator, it must be enclosed in double quotation marks. If a field is quoted, it must be escaped with double quotation marks. Examples of valid values: Apple, "A-Z" section, "1, 2, 3", "The ""A, B, C"" magazine".

Date field format

Date values must be specified in the ISO 8601 format. Examples: "2018-01-10" (date), "2018-01-10T08:14:00" (date and time), "2018-01-10T06:14:00Z" (date and time in UTC).

Time field format

Time values must be specified as a number of seconds. The component displays values in the "HH:mm:ss" format. Examples of valid values: 5400 (displayed as "01:30:00" in the component).

To ensure the detection of time values, set the field data type prefix to +t. Otherwise, they will be processed as numbers.

Month field format

Month values must start with a capital letter. Full names and 3-letter abbreviations of months are supported. Examples of valid values: "October", "Dec", "May".

To ensure the detection of month values, set the field data type prefix to +m. Otherwise, they will be processed as strings.

Weekday field format

Weekday values must start with a capital letter. Full names and 3-letter abbreviations of the days of the week are supported. Examples of valid values: "Monday", "Sun", "Friday".

To ensure the detection of weekday values, set the field data type prefix to +w. Otherwise, they will be processed as strings.

See also