Clean Data

Clean messy data in the active sheet or a specified range.

Preflight: Dependency Check

Before starting, verify required libraries are installed and install any that are missing.

python3 -c "import openpyxl" 2>/dev/null || python3 -m pip install openpyxl

Important: Do not skip this step — the workflow below will fail without these libraries.

Environment

• If running inside Excel (Office Add-in / Office JS): Use Office JS directly. 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 and openpyxl.