xlsx

Open, read, edit, format, and convert spreadsheet files.

Updated Mar 15, 2026
One-click install
npx skills add https://github.com/i0switch/yoyaku-tosho --skill xlsx-i0switch
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/i0switch/yoyaku-tosho/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/i0switch/yoyaku-tosho --skill xlsx-i0switch

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates the end-to-end handling of spreadsheet files, enabling users to open, read, edit, format, clean, and convert .xlsx, .xlsm, .csv, and .tsv data, while supporting the creation of new spreadsheets from various data sources. It also ensures the deliverable remains a valid spreadsheet file, reducing manual, repetitive work across data workflows.

Core Features & Use Cases

  • Open, read, edit, and format spreadsheet data (including applying formulas and basic styling).
  • Create new spreadsheets from other data sources, or consolidate multiple inputs into a single workbook.
  • Convert between tabular formats (e.g., CSV/TSV to XLSX and vice versa) and clean messy data structures.
  • Use cases include data cleaning for reports, generating formatted deliverables for stakeholders, and automating routine spreadsheet updates.

Quick Start

Load an input dataset (data.csv) and save the processed results as output.xlsx with basic formatting.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert CSV or TSV files to XLSX format while applying formatting?

To convert CSV or TSV files to XLSX, this skill automates the transformation by reading the raw tabular data and generating a valid .xlsx file. It applies basic cell formatting and styling during the conversion process to ensure the deliverable is ready for stakeholders.

Can I automate cleaning messy spreadsheet data and fixing malformed structures?

Yes, you can automate cleaning messy spreadsheet data by loading malformed .xlsx, .csv, or .tsv files to fix structural issues. The skill standardizes the data structures and ensures the final output remains a valid, properly formatted spreadsheet file.

Does this tool support creating spreadsheets with formulas and charts from data sources?

Yes, the tool supports creating new spreadsheets from various data sources while applying formula management and generating charts. It leverages openpyxl and pandas to consolidate multiple inputs into a single workbook with functional formulas and visualizations.

What is the best way to consolidate multiple spreadsheet inputs into a single workbook?

The best way to consolidate multiple spreadsheet inputs is to use this skill to read various .xlsx and .csv data sources, merge them using pandas, and save the processed results into a single, formatted output.xlsx workbook with basic styling applied.

Do I need pandas and openpyxl to edit and format existing .xlsm files?

Yes, the skill requires dependencies like pandas and openpyxl to edit and format existing .xlsm files. It also uses lxml and defusedxml for secure XML parsing, ensuring safe manipulation of macro-enabled spreadsheet structures.