What problem does it solve?
This Skill solves the problem of unstructured or noisy text inside large multi-sheet Excel files by cleaning it into standardized Chinese-only values and then producing reliable counts for a dynamically detected target column.
Core Features & Use Cases
- Multisheet Excel Text Cleaning: Applies regex-based extraction to keep only Chinese characters in specified text fields, reducing formatting noise and improving downstream analysis quality.
- Dynamic Column Matching + Counting: Automatically finds the target column by keyword (case-insensitive, tolerant of column naming variations) and counts matching values to generate summary statistics.
- Cleaned Output Export: Saves the cleaned dataset to a standardized Excel file and reports the resulting file size and a download link.
Use Case: You receive an Excel report with many sheets where a field like recipient/type contains mixed language, numbers, and symbols; use this Skill to clean the field to Chinese-only, locate the relevant “type” column, count how many rows match a specific value (e.g., "varchar"), and export a cleaned Excel for reporting.
Quick Start
Ask the Excel workflow to process the uploaded multi-sheet file, clean the designated text column to Chinese-only characters, dynamically identify the column containing a given keyword, count occurrences of a specified value, and export the cleaned Excel output.
