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.

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.
  • A field name or value is enclosed in double quotes " if it contains line breaks or a field separator. A double quote inside such values must be escaped using another double quote. For example: "The ""A, B, C"" magazine".

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

See also