lensetek Spreadsheet Operations Capability
When to Use
Use this capability for CSV/XLSX/Sheets analysis, cleaning, formulas, pivot-style summaries, charts, tables, validation, and marketing performance analysis.
Preferred Implementation
- Use spreadsheet libraries, formulas, CSV parsers, or Google Sheets connector when available.
- Use scripts for repeatable transformations.
- Use Computer Use only when spreadsheet UI interaction is unavoidable.
Inputs
- Spreadsheet path or sheet reference.
- Sheet/range.
- Metrics or columns.
- Desired output.
- Data sensitivity rules.
Outputs
- Cleaned Data.
- Analysis Summary.
- Formula or Chart Plan.
- KPI Table.
- Data Quality Notes.
Security and Ethics
- Do not expose customer lists, emails, phone numbers, revenue records, or private CRM exports.
- Use anonymized summaries when possible.
- Do not overwrite source workbooks without approval.