Help:CSV format

The result format csv is used to produce links to CSV files which allow to export the result of a query.

Remarks

 * All numeric or named entities in the generated output are decoded as UTF-8 strings. Therefore the character set in your application has to be set accordingly (UTF-8).
 * On most platforms, CSV files will be automatically opened by the default application for using spreadsheets.

Default

 * Syntax


 * Result

Change file name
Another file name for exporting the results can be specified by changing the  parameter:
 * Syntax


 * Result

Between results
Another separator between results than "," e.g. ";" can be used if specified by the  parameter:
 * Syntax


 * Result

Between property values
Another separator between results than "," e.g. "~" can be used if specified by the  parameter:
 * Syntax


 * Result

Output separator used
The separator used between results can be listed too in the exported file by setting the  parameter to  :
 * Syntax


 * Result

Combine results for identical subject identifiers
Subject identifier with identical row and column values can be merged by setting the  parameter to , e.g. lines containing "Foo", "1", "2", "3" and "Foo", "4", "5", "6" will result in "Foo", "1,4", "2,5", "3,6".CiteRef::sb:smw:2822. Such a situation can normally only appear when  is used that creates a specific first column and contains identical identifier.

Add the byte order mark
The byte order mark (BOM) can be added to the exported file by setting the  parameter to  :
 * Syntax


 * Result