Actions132
- AI Actions
- Extract Text From Document
- Check Content Policy
- Detect Adult Content
- Detect Brand
- Detect Color
- Detect Email Type
- Detect Faces
- Extract Entities
- Extract Contact Information
- Extract Customizable Information From Text
- Fuzzy Text Matcher
- Generate Image
- Generate JavaScript Code
- Generate Python Code
- Detect Language
- Detect Mood
- Extract Text From PDF
- Recognize Objects in Image
- Extract Text From Image
- Redact Sensitive Information From PDF
- Remove Background Image
- Summarize Text
- Transcribe
- Translate Text
- Image Actions
- Business Actions
- Convert Actions
- Generate Actions
- Crypto Actions
- Operator Actions
- Storage Actions
- Scheduler Actions
- Text Actions
- Chart Actions
- Code Actions
- Calculate Actions
- Date and Time Actions
- PDF Actions
- Compress PDF File
- Count PDF Pages
- Create Empty PDF
- Decrypt PDF
- Convert DOCX to PDF
- Draw Image on PDF
- Draw Text on PDF
- Encrypt PDF
- Convert HTML to PDF
- Convert Markdown to PDF
- Manage PDF Metadata
- Merge PDF Files
- Add PDF Pages
- Remove PDF Pages
- Resize PDF Pages
- Rotate PDF Pages
- Convert PDF to Base64
- Convert PDF to Image
- Split PDF File
- Add Image Watermark to PDF
- Add Text Watermark to PDF
- Shortened URL Actions
Convert → Convert CSV to Array
AI-generatedOverview
The node provides a utility to convert CSV (Comma-Separated Values) data into an array format. This is useful when you have CSV-formatted text data and want to transform it into a structured array for further processing within your workflow. Common scenarios include importing tabular data from CSV files or strings, parsing user input, or integrating with systems that output CSV data.
For example, if you receive a CSV string representing user information like:
Name,Age,City
John,30,New York
Jane,25,London
this node can convert it into an array of objects or arrays that can be easily manipulated in subsequent nodes.
Properties
| Name | Meaning |
|---|---|
| CSV Data | The CSV formatted string data to convert into an array. Example: "Name,Age\nJohn,30" |
| Separator | The character used to separate fields in the CSV data. Common separators are ,, ;, or ` |
Output
The node outputs a JSON field containing the parsed array representation of the CSV data. Each row in the CSV becomes an element in the array, typically represented as an object or array depending on the implementation of the conversion service. This structured output allows easy access to individual fields and rows for downstream processing.
There is no indication that the node outputs binary data.
Dependencies
- Requires an API key credential to authenticate requests to the external service at
https://prod.0codekit.com. - The node sends a POST request to the endpoint
/convert/csvtoarraywith the CSV data and separator as payload. - Proper configuration of this API key credential in n8n is necessary for the node to function.
Troubleshooting
- Empty or malformed CSV input: If the CSV data is empty or incorrectly formatted, the conversion may fail or return unexpected results. Ensure the CSV string is valid and matches the specified separator.
- Incorrect separator: Using a separator that does not match the CSV data will cause incorrect parsing. Verify the separator matches the delimiter used in the CSV string.
- Authentication errors: Missing or invalid API key credentials will prevent the node from connecting to the external service. Confirm the API key is correctly set up.
- Network issues: Connectivity problems to the external API endpoint will cause failures. Check network access and proxy settings if applicable.
Links and References
- CSV Format - Wikipedia
- 0CodeKit API Documentation (if available) (Note: actual docs URL not provided in source)