Skip to content

Keboola Component for converting xls/xlsx files to csv files.

License

Notifications You must be signed in to change notification settings

jakubbartel/keboola-xls2csv-processor

Repository files navigation

Keboola Xls2Csv Processor

Build Status

Convert XLS/XLSX (Microsoft Excel) files to CSV files.

Usage

The processor takes all files in the input directory /data/in/files (and all subdirectories), reads them as XLS/XLSX files and converts them to CSV files. A sheet within the XLS(X) file can be selected by the sheet_index parameter. If there is no sheet_index defined, the default value is 0 which is the first sheet.

Configuration

Example processor configuration:

{
    "definition": {
        "component": "jakub-bartel.processor-xls2csv"
    }
}

Example processor configuration - process the third sheet of each file:

{
    "definition": {
        "component": "jakub-bartel.processor-xls2csv"
    },
    "parameters": {
        "sheet_index": 2
    }
}