Skip to main content

CSV

Read, write, and manipulate CSV (Comma-Separated Values) files in your automation workflows.

Overview​

The CSV package provides comprehensive tools for working with CSV files, a common format for data exchange. Use it when you need to process data exports, create reports, or transfer data between systems using CSV format.

Key Features​

  • Read CSV Files - Parse CSV files into structured data
  • Write CSV Files - Create CSV files from data
  • Append Data - Add rows to existing CSV files
  • Split Files - Divide large CSV files into smaller chunks

Available Nodes​

  • Read CSV - Parse a CSV file and return data as an array
  • Write CSV - Create a new CSV file from data
  • Append CSV - Add rows to an existing CSV file
  • Split CSV - Break large files into multiple smaller files

When to Use This Package​

  • Data Import/Export: Process data exports from other systems
  • Report Generation: Create CSV reports from automation results
  • Database Migration: Prepare data for database imports
  • Spreadsheet Preparation: Create files for Excel or Google Sheets
  • Batch Processing: Process large datasets row by row

Common Use Cases​

  • Reading customer lists from CSV exports
  • Creating sales reports in CSV format
  • Splitting large data files for batch processing
  • Appending daily results to a cumulative file
  • Converting between different data formats

Typical Workflow​

  1. Use Read CSV to load data from a file
  2. Process each row using loops
  3. Use Write CSV or Append CSV to save results

Configuration Options​

  • Custom delimiters (comma, semicolon, tab)
  • Header row handling
  • Quote character settings
  • Encoding options (UTF-8, etc.)