xlsx

Create and edit .xlsx, .xlsm, .csv, and .tsv spreadsheets while preserving formulas.

Updated Mar 19, 2026
One-click install
npx skills add https://github.com/sujaynsv/Agentic-Skills --skill xlsx-sujaynsv
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/sujaynsv/Agentic-Skills/tree/main/skills/community/document-skills/xlsx
Command: npx skills add https://github.com/sujaynsv/Agentic-Skills --skill xlsx-sujaynsv

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Managing spreadsheets across formats and maintaining formulas is error-prone and time-consuming. This skill enables reliable creation, modification, and analysis of workbooks while preserving formulas and formatting.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting.
  • Read, analyze, and visualize data; generate summaries and reports.
  • Update templates or modify existing workbooks while preserving formulas and structure.
  • Use case: prepare quarterly financials by building a workbook that computes totals and charts from raw data, with formulas intact.

Quick Start

Tell Claude to start a spreadsheet project that creates a new workbook, populates it with data, and preserves all formulas during edits.

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 workbook while preserving formulas?

To edit an existing xlsx workbook while preserving formulas, you can use this skill to modify data and structure without overwriting formula cells. It ensures formulas remain intact during updates across .xlsx, .xlsm, .csv, and .tsv formats.

Can I automate spreadsheet creation with formulas and formatting?

Yes, you can automate spreadsheet creation with formulas and formatting. This skill programmatically generates new workbooks, populates them with data, applies formatting, and computes totals while keeping all formulas deterministic and intact.

Does openpyxl support data visualization and charts in xlsx files?

Yes, openpyxl supports data visualization in xlsx files. This skill leverages it to read, analyze, and visualize data, allowing you to generate summaries, reports, and charts directly from raw spreadsheet data.

What is the best way to update reusable spreadsheet templates with new data?

The best way to update reusable spreadsheet templates is by using a skill that supports deterministic formula handling and robust formatting. It modifies existing workbooks with new data while preserving the template's original structure and formulas.

Can I process csv and tsv files the same way as xlsx workbooks?

Yes, you can process csv and tsv files similarly to xlsx workbooks. This skill handles .xlsx, .xlsm, .csv, and .tsv formats, enabling reliable data analysis, modification, and conversion across these different spreadsheet file types.

Why do my formulas disappear when I update spreadsheet data programmatically?

Formulas often disappear during programmatic updates because standard libraries overwrite formula cells with static values. This skill prevents that by explicitly preserving formulas across workbook updates and data modifications.