What problem does it solve?
This Skill streamlines the process of reading, writing, analyzing, and converting Excel files, eliminating manual data manipulation and saving significant time.
Core Features & Use Cases
- File Operations: Read, write, and update data in Excel files (.xlsx, .xls, .csv).
- Data Analysis: Generate summaries, perform filtering, create pivot tables, and analyze data trends.
- Format Conversion: Convert between Excel, CSV, and JSON formats.
- Batch Processing: Import multiple files into a single Excel or export sheets to individual files.
- Chart Generation: Create various chart types directly from data.
- Smart Insights: Detect anomalies, analyze correlations, and identify trends within data.
- Use Case: Automatically convert a directory of CSV sales records into a single Excel file with a summary sheet and a sales performance chart.
Quick Start
Use the office-xlsx-skills to convert the attached file 'sales_data.xlsx' to CSV format.