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