import_data
Import CSV, TSV, or JSON data into an Excel sheet at a specified anchor cell, with automatic backup and formula-injection blocking.
Instructions
Import CSV, TSV, or JSON into a sheet at an anchor. Pass source (inline text) or source_file (a path); fmt auto-detects from the extension. location is the top-left anchor (default A1). A cell whose text begins with =, +, -, or @ is written as TEXT to block formula injection unless formulas is true. An import past the 200,000-cell write ceiling refuses rather than dropping rows. A hazardous workbook refuses unless allow_loss is true. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fmt | No | auto | |
| path | Yes | ||
| sheet | No | ||
| backup | No | ||
| header | No | ||
| source | No | ||
| encoding | No | utf-8 | |
| formulas | No | ||
| location | No | ||
| delimiter | No | ||
| allow_loss | No | ||
| verify_com | No | ||
| source_file | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||