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

• Setting data types in CSV
• Connecting to CSV
• Data type prefixes