Excel Report Generator

The excel-report-generator skill enables AI agents to create, format, and export professional Excel reports directly from natural language instructions. It handles data structuring, formula application, and visual styling without requiring manual spreadsheet manipulation.

When to use it

• Automate the generation of weekly sales summaries or monthly financial statements.
• Transform raw CSV or JSON data into formatted tables with calculated totals.
• Create standardized reports for stakeholders that require specific headers, colors, or conditional formatting.
• Generate pivot tables and charts based on provided datasets to visualize trends.

Key capabilities

• Dynamic Data Processing: Ingests raw data and structures it into clean Excel sheets.
• Formula Generation: Automatically inserts mathematical functions (SUM, AVERAGE, VLOOKUP) as needed.
• Visual Styling: Applies custom formatting, including fonts, colors, borders, and cell alignment.
• Chart Creation: Generates visual representations like bar charts or line graphs from data points.
• File Export: Outputs the final result as a downloadable .xlsx file.

Example prompts

• "Create an Excel report summarizing Q3 sales by region using this CSV data, with a total column at the bottom."
• "Generate a formatted spreadsheet for my inventory list, adding columns for 'Profit Margin' and highlighting items below 10 units in red."
• "Build a monthly expense tracker with automatic SUM formulas for each category and export it as an Excel file."

Tips & gotchas

Ensure your input data is clean and structured (e.g., comma-separated or JSON) to prevent parsing errors. For complex logic, provide clear examples of the desired output format within your prompt to guide the agent's styling choices.