Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 9.32, 10.3 |
| Location | Data > Excel & CSV |
The Convert CSV to Excel component converts CSV tabular data to the Excel format.
Properties
Inputs
| Property | Description | Data Type | |
|---|---|---|---|
| Encoding Type | Allows Users to specify an encoding type. | StringEncodingType | |
| Ignore First Line | Ignores the first line of the worksheet, often used as headers in Excel files. | Boolean | |
| Input | The CSV or Excel file to convert. | FileData | |
| Skip Blank Lines | Ignores any lines that do not contain any data. | Boolean | |
| Template (For v9.32+ and v10.3+) | Takes in an .xls or .xlsx template and formats the numeric columns of the resulting Excel file positionally. | FileData | |
| Try to Format Numbers | Formats numbers in the CSV file. | Boolean | |
| Format Numbers with Decimals (For v9.32+ and v10.3+) |
| ||
| Type | Defines the type of file to convert the input file to. Currently, the options are Csv, Excel_xls, Excel_xlsx, and AutoSelect. | CSVFileType | |
| Worksheet Name | Defines the Name of the Worksheet. | String | |
Outputs
| Property | Description | Data Type |
|---|---|---|
| ConvertCsvToExcel1_Output | The converted file in the specified type. | FileData |
Related Information
Forum Posts:
Convert CSV To Excel
Training Video:
Dynamic Excel Creation
Step Changes
| Description | Version | Date | Developer Task |
|---|---|---|---|
| Added ability to change the Worksheet Name. | 8.12 | June 2023 | [DT-037968] |
| 12 Steps have a new encoding property for CSV files, or more options for encoding. All Steps included in the update have the following encoding options: ASCII, UTF8, UTF32, LATIN1, and Unicode. | 9.16 | October 2025 | [DT-044412] |
| Added a new property name, Template, on the ConvertCSVtoExcel step, which can take a .xls or .xlsx template and format the numeric columns of the resulting Excel file positionally. | 9.32, 10.3 | October 2026 | [DT-048777] |
| A new property "Format Numbers with Decimals" has been added to the Convert CSV to Excel step as a sub-option of "Try to Format Numbers". | 9.32, 10.3 | October 2026 | [DT-048893] |