spreadsheet

Name: spreadsheet
Availability: InStock
Author: diegocamara89

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

3|3|Updated Apr 5, 2026

Search Tags:#pandas #openpyxl #spreadsheet #excel #data-analysis #csv #formula-preservation

Ready to run

npx skills add https://github.com/diegocamara89/ai-skills-hub --skill spreadsheet-diegocamara89

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/diegocamara89/ai-skills-hub/tree/main/all-skills/spreadsheet
Command: npx skills add https://github.com/diegocamara89/ai-skills-hub --skill spreadsheet-diegocamara89

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Reduce manual, error-prone work when creating, editing, and analyzing spreadsheets while preserving formulas, references, and formatting so outputs remain accurate and reviewable.

Core Features & Use Cases

Create and Edit: Build new .xlsx workbooks with formulas, styles, merged headers, and consistent number/date formats.
Analyze & Transform: Use pandas for filtering, aggregation, pivots, and CSV/TSV workflows, then write results back to .xlsx or .csv.
Preserve Integrity: Modify existing files without breaking formulas or references and validate formula presence since openpyxl does not evaluate them.
Render & Review: Optionally render sheets to PDF images for visual checks when LibreOffice and Poppler are available.

Quick Start

Create a new Excel workbook from the provided sales CSV with formatted headers, formulas for totals, and save it to output/spreadsheet/report.xlsx.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema

How do I edit an Excel file without breaking existing formulas and formatting?▼

To edit Excel files without breaking formulas, use openpyxl to modify .xlsx workbooks while preserving formulas, references, and formatting. This approach ensures cell references remain intact and outputs stay reviewable without manual reconstruction.

Can I use pandas to analyze CSV data and export the results to an Excel workbook?▼

Yes, you can use pandas to filter, aggregate, and pivot CSV or TSV data, then write the transformed results back to an .xlsx file. This workflow supports building formatted spreadsheets directly from raw tabular data sources.

Does openpyxl evaluate formulas when modifying spreadsheets?▼

No, openpyxl does not evaluate formulas when modifying .xlsx spreadsheets. It preserves formula strings and validates their presence, but you must open the workbook in a compatible viewer to trigger recalculation and view computed values.

What is the best way to clean and aggregate tabular data across different file formats?▼

The best way to clean and aggregate tabular data is using pandas for transformation across .csv and .tsv files, then leveraging openpyxl to apply merged headers, styles, and number formats when saving to .xlsx.

How do I render a spreadsheet to PDF for visual review?▼

To render spreadsheets to PDF images for visual checks, you need LibreOffice and Poppler installed in your environment. When available, the system can optionally convert sheets to PDF for review purposes.

Can I build a new Excel workbook with formatted headers and formulas from a CSV file?▼

Yes, you can build a new .xlsx workbook from a CSV file by applying consistent styles, merged headers, number and date formats, and inserting formulas for totals while saving the final output to a specified path.