excel-field-analyzer

Field mapping automates English translation and naming for Excel/CSV columns using preset rules and AI assistance. The Skill analyzes your file, applies standard terminology (NAIC for insurance data), infers data types, and outputs bilingual mappings in JSON and HTML formats, eliminating manual data dictionary creation.

Yes. The Skill includes 50+ built-in mappings for insurance workflows, enforces NAIC standard terminology, and applies snake_case naming conventions automatically. It validates mappings for uniqueness and consistency, outputting quality reports to ensure data reliability across multi-source configurations.

Field analysis generates HTML reports for visualization, JSON exports for programmatic use, and Markdown quality reports. Outputs include field statistics, bilingual mappings, data type inference results, and validation checks in both human-readable and machine-parseable formats.

Unknown fields trigger AI-assisted learning, where the Skill suggests English names and logical groupings based on context and existing mappings. You can validate and refine these suggestions, which integrate into your configuration for future analyses.

The Skill infers string, number, datetime, and boolean data types for each field, validating consistency across your dataset. Inference results appear in mapping reports and ensure type-safe data dictionary documentation.