This skill provides specialized workflows for editing existing Excel files while preserving their integrity. It addresses the unique challenges of modifying live workbooks: maintaining formula relationships across tabs, preserving formatting and structure, ensuring data insertion maintains sort order, and guaranteeing completeness of multi-tab updates.
Always Analyze Before Editing Never dive directly into making changes. First understand the file's structure, dependencies, and relationships.
Preserve, Don't Replace The existing file has established patterns. Maintain its structure, formulas, and formatting conventions rather than imposing new ones.
Specialized guidance for editing EXISTING Excel files with emphasis on preserving formulas, formatting, and structure across multiple tabs. Use this skill when modifying, updating, or adding data to existing .xlsx files where maintaining integrity is critical—particularly for multi-tab workbooks, complex formulas, formatted tables, and data that must maintain sort order and relationships across sheets. Source: exploration-labs/nates-substack-skills.