xlsx

Read, edit, and generate .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

Updated Apr 9, 2026
One-click install
npx skills add https://github.com/TungND2k2/Milo-ai --skill xlsx-tungnd2k2
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/TungND2k2/Milo-ai/tree/main/skills/xlsx
Command: npx skills add https://github.com/TungND2k2/Milo-ai --skill xlsx-tungnd2k2

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Use this skill anytime a spreadsheet file is the primary input or output. This enables automating open, read, edit, or fix tasks on files like .xlsx, .xlsm, .csv, or .tsv, including adding columns, computing formulas, formatting, charting, and data cleaning. It also supports creating a new spreadsheet from scratch or from other data sources and converting between tabular formats. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets
  • Create new spreadsheets from scratch or from other data sources
  • Convert between tabular formats (xlsx, csv, tsv, etc.)
  • Apply formulas, formatting, charts, and data cleaning in batch workflows
  • Example: Update a product list stored in Excel by adding columns for calculated margins and formatting for review

Quick Start

Load a workbook and perform initial edits to produce a validated spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet data cleaning and formatting in xlsx files?

To automate spreadsheet data cleaning and formatting in xlsx files, use this Skill to read existing workbooks, apply formulas, and batch format data while preserving the original structure. It outputs a validated spreadsheet file.

Can I convert csv or tsv files to xlsx while preserving formulas?

Yes, you can convert csv or tsv files to xlsx while preserving formulas. The Skill supports converting between tabular formats and outputs a valid spreadsheet file that maintains your formulas and structure.

Does openpyxl support adding new columns and charts to existing xlsm files?

Yes, openpyxl supports adding new columns and charts to existing xlsm files. The Skill leverages this dependency to read, edit, and generate spreadsheets while applying formulas and formatting to your data.

What is the best way to generate a new xlsx spreadsheet from other data sources?

The best way to generate a new xlsx spreadsheet from other data sources is using this Skill. It creates spreadsheets from scratch, applies formatting and charting, and delivers a fully validated workbook file.

When should I not use a spreadsheet automation tool for tabular data?

You should not use a spreadsheet automation tool when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.