excel-field-analyzer - Excel/CSV Field Analyzer for Intelligent Mapping and Quality Validation
Analyzes Excel/CSV field structures, generates AI-based Chinese-English mappings, validates translation quality, and outputs statistical reports.
Tags
Updated: 2026-02-11excel-analysisdata-mappingfield-mappingquality-validationdata-dictionaryspreadsheet-toolscsv-analysis
Capabilities
Typical Inputs
What this skill does
- analyze Excel/CSV field structures
- generate Chinese-English mappings
- validate translation quality
- output statistical reports
- create HTML visualization reports
- perform field statistical analysis
- check mapping quality automatically
- save results to custom.json
- read spreadsheet files
- write JSON mapping tables
Inputs
- Excel files
- CSV files
- Spreadsheet data
- Field mapping configuration
- AI model for semantic analysis
Outputs
- HTML visualization reports
- JSON field mapping tables
- Quality validation reports (Markdown)
- Statistical reports
- Field mapping files (custom.json)
Requirements
- Python environment
- Pandas library
- Openpyxl library
- NumPy library
- AI model access
- File read/write permissions