clean-data-xls

Clean Data Clean messy data in the active sheet or a specified range. Environment If running inside Excel (Office Add-in / Office JS): Use Office JS directly ( Excel.run(async (context) => {...}) ). Read via range.values , write helper-column formulas via range.formulas = [["=TRIM(A2)"]] . The in-place vs helper-column decision still applies. If operating on a standalone .xlsx file: Use Python/openpyxl. Workflow Step 1: Scope If a range is given (e.g. A1:F200 ), use it Otherwise use the full used range of the active sheet Profile each column: detect its dominant type (text / number / date) and identify outliers Step 2: Detect issues Show more Installs 559 Repository anthropics/fina…services GitHub Stars 34.1K First Seen May 4, 2026 Security Audits Gen Agent Trust Hub Pass Socket Pass Snyk Pass