LogoLogo
  • 🖐️Welcome Aboard!
  • 📖Information
    • What is Autom Mate?
    • What is Autom?
    • Features of Autom Mate
    • Architecture of Autom Mate
  • 🤓Learn Autom Basics
  • 📚Libraries
    • Integration
      • Active Directory
      • AFAS
      • Autom Mate
      • Azure Active Directory
      • Azure DevOps
      • BambooHR
      • ChatGPT
      • ConnectWise
      • Database
      • Desktop Actions
      • EasyVista
      • Email
      • Exchange Web Server
      • Exact Online
      • Excel
      • Freshdesk
      • Freshservice
      • Ftp-Sftp
      • GitLab
      • Google Drive
      • Google Workspace
      • HaloITSM
      • Hubspot
      • Intune
      • Ivanti Service Manager
      • Jenkins
      • Jira Confluence
      • Jira Service Management
      • Jira Software
      • Lakeside
      • Lansweeper
      • ME ServiceDesk Plus
      • Microsoft Outlook Calendar
      • Microsoft SharePoint
      • Microsoft Teams
      • My ChatGPT
      • OCR
      • PDF
      • PowerShell
      • Python
      • RESTful Web Service
      • Salesforce
      • ServiceDesk Plus Cloud
      • ServiceNow
      • Slack
      • SolarWinds
      • Stripe
      • TOPdesk
      • Twilio
      • Twitch
      • VMware
      • WhatsApp
      • Word
      • X
      • Xurrent
    • Transform
      • Advanced Actions
      • Array
      • Base64
      • Condition
      • Cryptography
      • CSV
      • Data Table
      • Date
      • File
      • Folder
      • Number
      • Object
      • Repeatable
      • SSH
      • String
      • Text
    • Utility
      • Display Message
      • Grouping
      • Mate DB
      • Mate Drive
      • Time Management
    • Agentic AI (Beta Version)
      • Open AI (Beta Version)
  • 🎇Autom Features
    • Variables
    • Triggers
    • Data Manager
    • Debug
    • Stop Action
    • Function
    • Error Handling and Exception Management
    • Development Mode ( Dev Mode )
    • Business Impact Estimator
  • 🛰️Product Features
    • Dashboard
      • Dashboard
      • Monitoring
      • Alerts
    • Store
      • Autom Store
      • Library Store
    • My Environment
      • Mate Agent
      • Automs
      • Libraries
    • Management
      • User Management
        • Users
        • Roles
        • Forgot Password
      • Vault
      • Webhook & API
      • Alert Management
      • Queue
    • Create Autom
    • Settings
    • Time Zone Management in Autom Mate
  • 💾Installation Setup
    • System Requirements and Ports Configuration
    • Autom Center Installation
      • Autom Center Installation
      • Autom Center Update
    • Mate Agent Installation
      • Mate Agent Installation
      • Mate Agent Update
    • App Installations
      • MS Teams ChatBot Installation
    • Full Chain PFX File Creation Guide
  • 📔Release Notes
    • Amsterdam Edition
      • Amsterdam 3.2.9
      • Amsterdam 3.3.0
    • Boston Edition
      • Boston 4.0.0
      • Boston 4.1.0
      • Boston 4.2.0
      • Boston 4.3.0
        • Boston 4.3.1
        • Boston 4.3.2
        • Boston 4.3.3
        • Boston 4.3.4
        • Boston 4.3.5
        • Boston 4.3.6
        • Boston 4.3.7
      • Boston 4.4.0
        • Boston 4.4.1
  • 🎓Academy
    • 🎓Autom Mate Academy: Basics of Autom Mate
    • 🎓Mastering Automation with Autom Mate: From Workflow Creation
    • 🎓The Ultimate Autom Mate: Teams & Smart Integrations
  • 👔Autom Store & Use Cases
    • 🛒Autom Store Use Cases
    • 🖥️Use Cases
      • How to Create Bidirectional Connection Between JIRA and Xurrent to Open Requests or Tickets
      • Employee Onboarding Process Automation Using Autom Mate
  • ❓FAQ
    • ⚙️General Functionality
    • 🧩Integration Capabilities
    • Data Management and Validation
    • ⁉️Error Handling and Workflow Management
    • Automation Use Cases
    • Connectors and Triggers
    • Custom GPT Models
Powered by GitBook
On this page
  • Introduction
  • What is CSV?
  • How To Use Action
  • Export to Excel
  • Read

Was this helpful?

  1. 📚Libraries
  2. Transform

CSV

PreviousCryptographyNextData Table

Last updated 6 months ago

Was this helpful?

Introduction

The CSV library within the Automate platform offers powerful actions for handling CSV files, providing users with the ability to read and export data efficiently.

The purpose of the CSV library is to streamline data processing workflows by enabling users to manipulate CSV files directly within Automate. This component facilitates tasks such as reading CSV data for automation and exporting CSV files to Excel for further analysis.

What is CSV?

The CSV library in Automate allows users to interact with CSV files, a common format for tabular data storage. Users can perform actions such as reading CSV files to extract data and exporting CSV data to Excel files for reporting and analysis.

Key Features

  • Export to Excel: Export CSV data to an Excel file effortlessly.

  • Read CSV Data: Read CSV files to utilize data within automation workflows.

  • Customizable Options: Configure CSV actions with various parameters for flexible usage.

How To Use Action

Export to Excel

Description: The Export to Excel action allows users to export CSV data to an Excel file.

Usage:

  1. CSV Source:

    • Select the variable containing the CSV source data.

  2. Excel Path:

    • Specify the path where the Excel file will be exported.

  3. Assign Excel File Path:

    • Choose a string variable to assign the full path of the exported Excel file.

Read

Description: The Read CSV Data action is used to read a CSV file and retrieve its contents for use in workflows.

Usage:

  1. File Path:

    • Define the path to the CSV file to be read.

  2. Open Option:

    • Select the desired open option:

      • Read Only: The file cannot be changed or saved.

  3. Contains Header:

    • Check this option if the CSV file contains a header row.

  4. Assign CSV Source Data:

    • Select a datatable variable to assign the CSV source data.

  5. Assign File Path:

    • Choose a string variable to assign the file path of the CSV file.

Hint

  • For CSV files exceeding 250 MB, consider splitting the file into smaller parts or using alternative processing approaches to maintain compatibility with Autom Mate workflows.

Warning

  • Limitation: CSV files larger than 250 MB will not be processed by the CSV Read action.

  • Attempting to process oversized files may result in action errors or workflow disruptions.