skills.rest
agentscope-ai
agentscope-aiOFFICIAL
Explore all skills by this author →
𝕏@agentscope_aiGitHub

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

34.3k|3.0k|Updated Feb 24, 2026
Search Tags:#data analysis#spreadsheet#excel#xlsx#data cleaning#formula calculation
One-click install
npx skills add https://github.com/agentscope-ai/CoPaw --skill xlsx-agentscope-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/agentscope-ai/CoPaw/tree/main/src/copaw/agents/skills/xlsx
Command: npx skills add https://github.com/agentscope-ai/CoPaw --skill xlsx-agentscope-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, libreoffice, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to effortlessly create, edit, and analyze spreadsheet files, transforming raw data into actionable insights and professional deliverables.

Core Features & Use Cases

  • Data Manipulation: Add columns, compute formulas, format data, and create charts in .xlsx, .csv, and .tsv files.
  • Data Cleaning: Restructure and clean messy tabular data into well-organized spreadsheets.
  • Use Case: Convert a messy CSV file with inconsistent formatting into a clean, professional Excel file with proper headers, data types, and formulas, ready for financial modeling.

Quick Start

Use the xlsx skill to read the data from the file named 'sales_data.xlsx'.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I clean messy CSV data and convert it into a formatted Excel file?▼

This skill automates data cleaning by restructuring messy CSV formatting into professional xlsx files with proper headers, data types, and computed formulas.

Can I add columns and compute formulas in an existing xlsx spreadsheet?▼

You can edit xlsx spreadsheets by adding columns, computing formulas, formatting data, and creating charts directly through automated data manipulation scripts.

Does openpyxl support recalculating Excel formulas after editing?▼

Openpyxl handles Excel manipulation, but formula recalculation requires LibreOffice, which executes alongside pandas for data analysis to recompute spreadsheet formulas.

What is the best way to convert between xlsx, csv, and tsv file formats?▼

Automating tabular data conversion between xlsx, csv, and tsv formats ensures proper data types and consistent formatting while transforming raw data into actionable insights.

Do I need pandas to analyze and clean tabular data files?▼

Pandas is required for data analysis and cleaning tasks, working in conjunction with openpyxl for Excel manipulation and LibreOffice for executing formula recalculation.

Related Skills

Explore More Finance & Accounting Skills→
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate
eosphoros-aieosphoros-ai
19.7k

financial-report-analyzer

Extract financial metrics, calculate ratios, and generate charts from PDF reports.

Official
Advanced
sagunkayasthasagunkayastha

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Community
Advanced