Download
Documentation menu
Getting started
Integration with frameworks
Data sources
    JSON
    CSV
    1. Supported CSV format
    2. Setting data types in CSV
    3. Connecting to CSV
    4. Data type prefixes
Configuring fields
Pivoting functionality
Formatting
Grid layout
Saving and loading reports
Add-ons
Customizing
Integration with charts
Technical specifications and licensing
API Reference

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