Convert Csv To Excel Step

Brief description

This step converts a CSV file into an Excel (.xlsx) file. It allows defining custom delimiters, handling header rows, and specifying the Excel file and sheet names. The step simplifies data transformation between formats, making it easier to process structured data in Excel for reporting or analysis.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

• Input CSV Path (Required) – specifies the full file path to the source CSV file that will be converted to Excel format.
• Delimiter (Required) – defines the character used to separate columns in the CSV file (e.g., comma ,, semicolon ;, or tab \t).
   
• File has header row (Required) – indicates whether the first row of the CSV file contains column headers:
  • T (true) – the first row will be treated as column headers.
  • F (false- default value) – no headers; columns will be named automatically (e.g., Column1, Column2, etc.).
• Use same name as CSV (Required) – determines whether the Excel file should use the same name as the original CSV file:
  • T (True) – the generated Excel file will use the same name as the CSV file, and the Excel file name field becomes disabled.
  • F (false- default value)  – allows you to define a custom name for the resulting Excel file.
• Excel file name (Required) – specifies the name of the new Excel file (without extension). Required if Use same name as CSV is False
• Sheet name (Required) – defines the name of the sheet within the Excel file where data will be stored.

Output parameters

• Excel full path (Required) – specifies the name of the variable that will store the full path to the generated Excel file.
• Row count (Not required) – specifies the variable that will store the total number of rows written to the Excel file.