We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.
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