Convert Excel to CSV
- 20 Oct 2022
- 1 Minute to read
- Print
- DarkLight
Convert Excel to CSV
- Updated on 20 Oct 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
This step allows the user to select an Excel file and convert it to CSV. The inputs a user must provide for this step are an Excel file, the file type (Excel_xls, Excel_xlsx, or CSV), whether the user wants to ignore the first line in the Excel file, and whether the user wants the converter to ignore blank lines. The step will output the converted CSV file according to the user's inputs.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| 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 dont contain any data. | Boolean |
| Type | Defines the type of file to convert the input file to. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect. | CSVFileType |
Outputs
| Property | Description | Data Type |
|---|---|---|
| ConvertExcelToCsv1_Output | The converted file in the specified type. | FileData |
Related Information
Forum Posts:
Convert CSV To Excel
Was this article helpful?
