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: ":"
		}
	}
});

See also