xlsx

What it does

This skill enables AI agents to create, edit, and analyze Microsoft Excel spreadsheets (.xlsx, .xlsm, .csv, .tsv). It supports a wide range of spreadsheet functionalities including formula implementation, data formatting, basic data analysis tasks (like calculating sums or averages), and generating simple visualizations. The agent can also handle different file types commonly associated with spreadsheets.

When to use it

• Budget Planning: Generate a budget spreadsheet with pre-defined categories and automatically calculate totals based on user input.
• Data Summarization: Summarize data from a CSV file into a formatted Excel table, including calculated averages and percentages.
• Inventory Management: Create an inventory tracking sheet with columns for item name, quantity, cost, and reorder point.
• Sales Reporting: Build a spreadsheet to track sales figures over time, incorporating formulas to calculate monthly revenue and growth rates.

Key capabilities

• Supports .xlsx, .xlsm, .csv, and .tsv file formats.
• Formula implementation for calculations (e.g., SUM, AVERAGE).
• Data formatting options (e.g., number formats, bolding, colors).
• Basic data analysis functionality.
• Simple visualization generation.

Example prompts

• "Create an Excel spreadsheet to track my weekly expenses with categories like 'Food', 'Rent', and 'Entertainment'."
• "Summarize the sales data in this CSV file into a table showing monthly revenue."
• “Generate a simple bar chart visualizing the data from column B of this .xlsx file.”

Tips & gotchas

The agent's data analysis capabilities are currently limited to basic calculations. Complex statistical analyses or advanced charting features are not supported.