xlsx

Create, edit, and convert spreadsheet files while preserving formulas and formatting.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles spreadsheet creation, editing, conversion, and repair so tabular work stays dynamic, accurate, and easy to update.

Core Features & Use Cases

  • Builds new spreadsheets from scratch or from imported data.
  • Edits existing .xlsx, .xlsm, .csv, and .tsv files while preserving formulas and formatting.
  • Cleans messy tables, adds calculations, formats financial models, and converts tabular files between spreadsheet formats.
  • Example: turn a messy CSV of monthly sales into a polished workbook with formulas, headers, and consistent formatting.

Quick Start

Ask the xlsx skill to open the attached spreadsheet, clean it up, preserve the formulas, and return an updated workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an existing xlsx file while preserving formulas and formatting?

To edit an xlsx file while preserving formulas and formatting, the spreadsheet processing applies formula-safe editing using openpyxl. This ensures your existing workbook calculations and visual styles remain intact during tabular data modifications.

What is the best way to convert csv to a formatted xlsx workbook with formulas?

The best way to convert csv to a formatted xlsx workbook with formulas is by importing the tabular data and building a new spreadsheet. This process cleans messy tables, adds calculations, applies headers, and ensures consistent spreadsheet formatting.

Does openpyxl support recalculating spreadsheet formulas in xlsm files?

Yes, openpyxl supports recalculation for xlsm files when combined with LibreOffice processing. This formula-safe workflow validates against Excel errors and ensures spreadsheet calculations are updated accurately during tabular data modifications.

Can I clean messy tabular data and build financial models directly from tsv files?

Yes, you can clean messy tabular data and build financial models directly from tsv files. The spreadsheet workflow handles tsv format conversion, adds calculations, formats financial models, and outputs a polished workbook with formulas.

Why do my spreadsheet formulas break when converting between csv and xlsx formats?

Spreadsheet formulas break during csv and xlsx conversion because csv is plain text without formula support. Using formula-safe editing with openpyxl preserves formulas by building a proper workbook structure that validates against Excel errors during conversion.