Data sources

CSV

This article explains how to use the data source for data in CSV format. The exact specification and further information about CSV can be found here.

A nice example of CSV data can be found at this URL: http://mysafeinfo.com/api/data?list=presidents&format=csv. It lists all American presidents. In addition to the connection via URL, CSV files can also be included as a file via a network drive. A network share can be accessed either directly (specifying the desired domain user and password) or via the Peakboard Bridge. In addition, CSV files can also be stored as a resource directly in the packet. This can be useful, for example, if you simply want to “play” with the data offline at the beginning of a project, or if you don’t want to decide on the concrete access method yet. Set the property Source Type to the correspondingly desired access type.

In the case of access via a URL, the classic web authentication methods can be used to gain access to protected files. Use property Authentication to select the desired method.

Normally, columns are separated by a comma in CSV. If a different separator is desired, set the Delimter accordingly. Skip Rows allows to skip a certain number of rows at the beginning of the file (e.g. because the file has a header to be ignored). Max Rows limits the number of rows.

Finally, click on Load Data to call up a preview and display the metadata. If desired, the datatype of each column can be changed (e.g. from String to Number for numeric numbers).

CSV Data Dialog

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit www.peakboard.com

Find out all about Peakboard and browse our different use cases and success stories.