CSV is considered to be an industry standard for data analysis. The most common ways of producing CSV data are:
- export from Excel
- export from databases
CSV stands for comma-separated values so a simple CSV file looks the following way:
Product,Price Apple,2.50 Cherry,5.25
Connect to CSV via UI
Step 1. Go to the Connect tab () on the Toolbar.
Step 2. Choose to which CSV you want to connect:
- To local CSV. Use this option to load a file from your local file system.
- To remote CSV. Use this option to load a file by its URL.
Here’s an example of connecting to a remote CSV file:

Connect to CSV programmatically
To get your CSV data from a file, specify the file’s URL in the dataSource.filename
property:
let pivot = new WebDataRocks({ container: "#wdr-component", toolbar: true, report: { dataSource: { filename: "URL-to-your-CSV-file" } } });
Specify a custom field separator
In most cases, a comma (,
) is used as a separator between different CSV fields, such as Product
and Price
. WebDataRocks also supports other separators.
If fields in your data are separated by a semicolon (;
) such data source can be used without any additional configurations. If fields in your data are separated by some other symbol, e.g., a colon (:
), you need to specify fieldSeparator
as in the example:
let pivot = new WebDataRocks({ container: "#wdr-component", toolbar: true, report: { dataSource: { filename: "URL-to-your-CSV-file", fieldSeparator: ":" } } });