Overview
CSV is a Core Flows360 connector for transforming tabular data between CSV text, JSON arrays and Excel workbooks. It is based on @activepieces/piece-csv version 0.4.21 and is currently a private draft review candidate, not published catalogue content.
The connector has no authentication, no triggers and no external provider API. Its three actions have been execution-verified by the CDK deterministic runtime:
- Convert CSV to JSON parses comma- or tab-delimited text into a JSON array, either using the first row as headers or treating every row as data.
- Convert JSON to CSV serialises a JSON array to comma- or tab-delimited CSV text, always emitting a header row and flattening nested objects so dotted key paths become headers.
- Convert Excel to CSV reads a valid .xlsx or .xls workbook and converts one sheet to CSV text using a comma, tab or semicolon delimiter. If a sheet name is not supplied, the first sheet is used.
Use it when table data needs to be normalised before looping or filtering rows, or when a JSON array needs to become CSV text for a file, export or attachment.
Technical guide
Technical guide
CSV requires no connection or scopes. Convert CSV to JSON supports comma and tab delimiters; Convert JSON to CSV accepts JSON arrays and flattens nested objects to dotted headers. Convert Excel to CSV accepts valid .xlsx or .xls workbooks and converts the requested sheet, or the first sheet when none is supplied.
Capability summary
Authentication
Authentication method: No authentication required
Supported objects
| Object | Read | Write | Notes |
|---|---|---|---|
| Convert CSV to JSON | Yes | No | Parses CSV or tab-separated text into a JSON array, with an option to use the first row as headers. |
| Convert JSON to CSV | Yes | No | Serialises a JSON array to comma- or tab-delimited CSV text, flattening nested objects to dotted headers. |
| Convert Excel to CSV | Yes | No | Converts one selected or first .xlsx/.xls workbook sheet to CSV text using comma, tab or semicolon as the delimiter. |
Supported actions
Convert CSV to JSON · Read
This function reads a CSV string and converts it into JSON array format.
convert_csv_to_json · Risk: low · Retry: safe
Inputs
csv_text· string · Requiredhas_headers· boolean · Requireddelimiter_type· string · Required, Select the delimiter type for the CSV text.
Convert JSON to CSV · Read
This function reads a JSON array and converts it into CSV format.
convert_json_to_csv · Risk: low · Retry: safe
Inputs
markdown· string · Optional, n**Notes**:n* The input should be a JSON array.n* The JSON object will be flattened If nested and the keys will be used as headers.njson_array· object · Required, Provide a JSON array to convert to CSV format.delimiter_type· string · Required, Select the delimiter type for the CSV file.
Convert Excel to CSV · Read
Converts an Excel file (.xlsx or .xls) into CSV text.
convert_excel_to_csv · Risk: low · Retry: safe
Inputs
file· object · Required, The Excel file (.xlsx or .xls) to convert to CSV.sheet_name· string · Optional, Name of the sheet to convert. Leave blank to use the first sheet.delimiter_type· string · Required, Character used to separate values in the output CSV.
Setup
- Add the CSV connector to a draft workflow step.
- Select one of the execution-verified actions: Convert CSV to JSON, Convert JSON to CSV, or Convert Excel to CSV.
- No connection, credential or scope setup is required. This connector uses no authentication and does not call an external provider API.
- For Convert CSV to JSON, provide CSV Text, choose whether the CSV has headers, and select comma or tab as the delimiter.
- For Convert JSON to CSV, provide a JSON array and select comma or tab as the output delimiter. The action emits a header row and flattens nested objects to dotted headers.
- For Convert Excel to CSV, provide a real .xlsx or .xls file, optionally enter a sheet name, and select comma, tab or semicolon as the output delimiter. Leave Sheet Name blank to convert the first sheet.
- Use the returned output in later steps. Convert Excel to CSV returns CSV text, the selected sheet name and the available sheet names.
Limitations
This connector content remains private, in draft and unpublished. It must not be treated as live catalogue documentation until licence, content and publication review are complete.
The @activepieces/piece-csv version 0.4.21 implementation has no authentication, no triggers and no external provider API. Supported inputs are limited to the verified actions and options documented here: CSV text with comma or tab delimiters; JSON array input for JSON to CSV; and valid .xlsx or .xls Excel files for Excel to CSV.
Convert JSON to CSV accepts a JSON array only, not a single object. Nested objects are flattened so dotted key paths become column headers, and a header row is emitted.
Convert Excel to CSV converts one sheet only, selecting the named sheet when supplied or the first sheet otherwise. It validates Excel file signatures and rejects non-Excel content such as HTML or PDF files. If a supplied sheet name is not present in the workbook, the action fails and reports the available sheet names.
No other actions, objects, provider operations or catalogue connector runtime status are documented by this draft.
Troubleshooting
Why are all CSV values appearing in one column after Convert CSV to JSON?
Check that Delimiter Type matches the input text. Convert CSV to JSON supports comma and tab delimiters; if the wrong delimiter is selected, the parser will not split the columns as expected.
Why does Convert JSON to CSV fail with u201cThe input should be a JSON array.u201d?
The JSON Array input must be an array of rows. A single JSON object is not accepted. Wrap row objects in an array before running the action.
Why do nested JSON fields become dotted column names in Convert JSON to CSV?
This is expected. Nested objects are flattened before serialisation, and the flattened key paths are used as CSV headers.
Why does Convert Excel to CSV say the file is not a valid Excel file?
The action validates the binary signature for .xlsx or .xls content. Use a direct Excel file upload or download, not a webpage, HTML response or PDF file.
Why is my Excel sheet name not found?
Provide the exact sheet name from the workbook, or leave Sheet Name blank to use the first sheet. When a supplied sheet name is missing, the action reports the available sheet names in the error message.