Excel Export Validator

What it does

This skill validates Excel exports to ensure they adhere to expected formats and data types. It checks for common errors like incorrect column headers, missing required fields, or invalid data within cells. The validator can be used to automatically verify exported spreadsheets before distribution or further processing.

When to use it

• Automated Report Generation: Validate Excel reports generated by a system to ensure accuracy and consistency.
• Data Migration: Verify the integrity of data after exporting from one system and importing into another.
• Spreadsheet Template Enforcement: Ensure users create spreadsheets that conform to predefined templates.
• Compliance Checks: Confirm exported data meets specific regulatory or internal compliance requirements.

Key capabilities

• Excel export validation
• Format checking
• Data type verification
• Column header validation
• Required field checks

Example prompts

• "Validate this Excel file against the 'Sales Report' template."
• "Check if the exported data from the CRM has all required fields."
• "Verify that the column headers in this spreadsheet match the expected schema."

Tips & gotchas

The skill requires a defined template or schema to compare the exported Excel file against. Providing an accurate and complete template is crucial for effective validation.