xlsx-editor

Edit existing Excel workbooks while preserving formulas, formatting, and structure.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/danbrickey/edp-ai-expert-team --skill xlsx-editor
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx-editor
Source: https://github.com/danbrickey/edp-ai-expert-team/tree/main/ai-resources/prompts/utilities/excel-editing/xlsx-editor
Command: npx skills add https://github.com/danbrickey/edp-ai-expert-team --skill xlsx-editor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Manually editing Excel files, especially large or complex ones, can be tedious and error-prone. This skill provides AI-assisted editing capabilities for .xlsx files, allowing users to make precise changes, update data, or modify formatting with simple commands.

Core Features & Use Cases

  • Targeted Cell Editing: Modify specific cells, ranges, or entire columns/rows based on your instructions.
  • Data Manipulation: Update values, apply formulas, or clean data within existing Excel workbooks.
  • Use Case: You have an existing sales report in sales_q4.xlsx and need to update the "Total Revenue" for a specific region. Use this skill to quickly locate the cell and update its value or formula without opening the file manually.

Quick Start

In the attached 'sales_report.xlsx', update the value in cell B5 to '150000'.

Frequently Asked Questions about xlsx-editor

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

FAQPage Schema
How do I edit Excel files while keeping formulas and formatting intact?

Excel editing with AI preserves formulas, formatting, and structure across multiple tabs during edits. This skill analyzes your workbook before making changes, then validates formulas, sort order, and cross-sheet references afterward to ensure data integrity and dependencies remain unbroken.

Can I update data in multi-tab Excel workbooks without breaking cross-sheet formulas?

Yes. This skill edits existing Excel workbooks while maintaining merged cells, conditional formatting, and cross-sheet formula references. It guarantees multi-tab completeness by validating all dependencies after modifications, so linked data and calculations stay consistent.

What's the best way to add data to existing Excel tables and preserve sort order?

Use AI-assisted editing to insert data into specific cells or ranges within your existing tables. The skill preserves sort order, merged cells, and formatting patterns during insertion, then validates the updated structure to confirm all dependencies and formatting rules remain intact.

How do I modify specific cells in an Excel file without manually opening it?

Target cell editing lets you update specific cells, ranges, or columns by providing simple instructions. The skill locates the target data, applies your changes, and validates the result—ideal for quick updates to values or formulas in large or complex workbooks.

Does this work with complex Excel files that have multiple sheets and interdependent data?

Yes. The skill handles multi-tab workbooks with interdependent formulas and formatting. It enforces pre-edit analysis to understand your workbook's structure, applies changes while preserving patterns, and validates cross-sheet references and formula integrity after edits complete.

What happens to conditional formatting and merged cells when I edit an Excel file?

Conditional formatting and merged cells are preserved during editing. The skill maintains all existing formatting patterns and cell structures before, during, and after modifications, ensuring your workbook layout and visual rules remain unchanged.