Documentation menu

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

See also