excel-expert

To convert Excel sheets to JSON, this Skill traverses all worksheets in .xlsx or .xls files, normalizes NaN values and IDs, and outputs structured JSON. It handles multi-sheet parsing and data cleaning to preserve complete data context for reliable downstream processing.

Yes, you can convert Excel data to CSV while applying strict data-cleaning rules. The Skill normalizes NaN and None values to empty strings and standardizes dates and IDs, ensuring consistent keys before exporting to CSV format ready for data pipelines.

Yes, you need pandas and openpyxl installed to parse .xlsx files. The Skill fulfills environment verification for these dependencies before reading worksheets, ensuring the multi-sheet traversal and data normalization processes run without missing library errors.

The best way to clean IDs from multiple sheets is using automated normalization that traverses every worksheet, applies strict data-cleaning rules, and standardizes ID formats. This approach handles unexpected sheet structures robustly during data extraction.

Excel multi-sheet parsing handles unexpected structures through robust error handling during worksheet traversal. It applies strict data-cleaning rules to normalize values safely, preventing pipeline failures when encountering misaligned columns or empty sheets during data extraction.