Import CSV
import_csvImport a CSV or TSV file into an Excel sheet starting at a chosen cell, overwriting existing cells. Converts numbers, TRUE/FALSE and ISO dates to values while keeping leading zeros and formulas as text.
Instructions
Import a CSV file into a sheet from at, overwriting cells.
Numbers, TRUE/FALSE and ISO dates become values; leading zeros ('007'), over 15 digits and ambiguous dates stay text. Never formulas: text starting with = + - @ is text.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| at | No | Top-left cell. | A1 |
| path | Yes | ||
| sheet | Yes | Created if missing. | |
| as_text | No | Keep every field as text. | |
| decimal | No | Decimal mark; the other groups thousands. | . |
| csv_path | Yes | .csv or .tsv file, located like workbooks. | |
| encoding | No | 'utf-8' also reads a BOM. | utf-8 |
| delimiter | No | 'auto': most frequent in the first record. | auto |
| date_order | No | 'dmy' or 'mdy' also read 31/12/2026-style dates; else only ISO ones are dates. | ymd |