CSV Create

Description

Converts a dataset into a delimited text file (CSV, TXT, TSV, DAT) and saves it to the server with a download URL. Shares the same configuration field names as CSV Parse for consistency when reading and writing files.

Configuration

Field	Type	Required	Description
filePath	text	No	File name (e.g. report.csv, export.txt). If it includes an extension it is preserved. Default: output
dataKey	text	No	Path to the data array within the input (e.g. results.items). Leave empty to use all data
fileExtension	select	No	File extension. Only used when the name doesn’t include one. Options: .csv, .txt, .tsv, .dat
col_separator	select	No	Column separator: , (default), ;, Tab, |
row_separator	select	No	Row separator: line break (\n, default), crlf (\r\n for Windows)
quote	select	No	Quotes: " (default), ', No quotes
header_first_row	select	No	Include header row with field names. Default: Yes
col_header	text	No	Custom columns separated by comma (e.g. name,email,phone). If empty, exports all keys
codification	select	No	Encoding: utf8 (default), utf8-bom (Excel), ascii, latin1

Shared Fields with CSV Parse

The following fields use the same names and values as the CSV Parse node, making it easy to configure when reading and writing the same format:

Field	CSV Create	CSV Parse
col_separator	Column separator	Column separator
row_separator	Row separator	Row separator
header_first_row	Include header	First row is header
col_header	Columns to export	Column names
codification	Write encoding	Read encoding

Extension Behavior

File Name	fileExtension	Result
report.csv	(any)	report-1712345678.csv — extension from name takes priority
export.txt	(any)	export-1712345678.txt — extension from name takes priority
data	.csv	data-1712345678.csv — uses configured extension
output	.txt	output-1712345678.txt — uses configured extension

Output

{
  "filename": "report-1712345678.csv",
  "filePath": "/www/wwwroot/floogos/engine_us1/temporal/cli_123/report-1712345678.csv",
  "urlPath": "https://us1.floogos.com/download/cli_123/report-1712345678.csv"
}

Usage Examples

Standard CSV

{
  "filePath": "sales-report",
  "dataKey": ""
}

European format (semicolon, no quotes, UTF-8 BOM for Excel)

{
  "filePath": "report.csv",
  "col_separator": ";",
  "quote": "none",
  "codification": "utf8-bom"
}

Data only, no header

{
  "filePath": "data-only.txt",
  "header_first_row": "false",
  "quote": "none",
  "col_separator": ";"
}

Export only specific columns

{
  "filePath": "customers.csv",
  "col_header": "name,email,phone,city",
  "col_separator": ","
}

Tab-separated with CRLF (Windows)

{
  "filePath": "export.tsv",
  "col_separator": "\t",
  "row_separator": "crlf"
}

Notes

• Supported extensions: .csv, .txt, .tsv, .dat
• A timestamp is always appended to the file name to prevent overwrites
• utf8-bom adds the BOM (Byte Order Mark) so Excel correctly detects UTF-8 and special characters
• If the input data is a single object, it is automatically wrapped in an array
• Files are stored in temporal/cli_{client_id}/ and served via the /download/ endpoint
• Output includes _meta_ with generated file info (rows, delimiter, encoding)

Related Nodes

• CsvParse - Parse a CSV file into data
• SaveToExcel - Export data as Excel (.xlsx)
• Save2Json - Export data as JSON file