Csv Analyzer

The csv-analyzer skill enables AI agents to parse, validate, and summarize data contained within Comma-Separated Values (CSV) files. It transforms raw tabular inputs into structured insights, allowing agents to handle datasets directly without manual preprocessing.

When to use it

• Data Summarization: Quickly generate a high-level overview of large datasets containing sales figures or inventory counts.
• Error Detection: Identify missing values, inconsistent formatting, or malformed rows in imported spreadsheets before analysis.
• Field Extraction: Isolate specific columns (e.g., dates or prices) from a bulk file to create targeted reports.
• Format Conversion: Prepare raw CSV data for ingestion into other systems by cleaning and structuring the content first.

Key capabilities

• Reads and parses standard CSV file formats.
• Validates data integrity and structure within the file.
• Extracts specific fields or rows based on user instructions.
• Summarizes numerical trends and categorical distributions found in the data.

Example prompts

• "Analyze this CSV file of monthly expenses and list any months where spending exceeded $5,000."
• "Extract all email addresses from the provided customer list CSV and count how many are missing a domain."
• "Summarize the key statistics from this sales report CSV, including total revenue and average transaction value."

Tips & gotchas

Ensure your CSV file uses standard delimiters (commas) and does not contain unescaped special characters that might break parsing. For very large files, consider splitting them into smaller chunks to ensure accurate processing by the agent.