Export CSV
export_csvSave an Excel worksheet range as CSV/TSV, including formula results, with controls for delimiter, encoding, formatting, overwrite, and formula escaping.
Instructions
Export a range (formula results) as a CSV file, like Save As CSV.
Text starting with = + - @ gets a ' prefix unless escape_formulas is false.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| range | No | e.g. 'A1:D20'. Default: the used range. | |
| sheet | Yes | ||
| csv_path | Yes | .csv or .tsv file, located like workbooks. | |
| encoding | No | 'utf-8-sig' adds a BOM, which Excel needs for UTF-8. | utf-8 |
| delimiter | No | comma | |
| formatted | No | Apply number formats, as Excel shows cells; else raw values. | |
| overwrite | No | Replace an existing file (else an error). | |
| escape_formulas | No | Prefix text starting with = + - @ with ' so Excel does not run it. |