Convert spreadsheets
convert_workbookConvert xlsx, xlsm, xls, xlsb, ods, csv, tsv, and json workbooks to xlsx, csv, tsv, json, html, or pdf; process one file, a list, or a folder.
Instructions
Convert workbooks (xlsx, xlsm, xls, xlsb, ods, csv, tsv, json; one, a list or a folder) to xlsx, csv, tsv, json, html or pdf (csv / tsv / pdf: the first sheet, or every sheet as its own file with all_sheets).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| suffix | No | ||
| formats | No | Outputs: xlsx (Excel, every sheet, formulas, styles, tables, charts), csv / tsv (values of one sheet), json, html and pdf (one sheet, print layout). | |
| input_dir | No | ||
| overwrite | No | Replace existing outputs. | |
| all_sheets | No | csv / tsv / pdf: write every sheet as its own file (<name>_<sheet>.csv) instead of only the first sheet. | |
| input_path | No | ||
| output_dir | No | Absolute output folder (default: next to the input; required for new files). | |
| input_paths | No | ||
| output_path | No | Absolute output file for the first format (its extension must match). |