skills.rest
sagunkayastha
sagunkayasthaCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Updated Mar 15, 2026
Search Tags:#reporting#data analysis#pandas#formulas#spreadsheet#excel#data cleaning
One-click install
npx skills add https://github.com/sagunkayastha/claude_skills_collection --skill xlsx-sagunkayastha
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/sagunkayastha/claude_skills_collection/tree/main/scientific-communication/xlsx
Command: npx skills add https://github.com/sagunkayastha/claude_skills_collection --skill xlsx-sagunkayastha

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, libreoffice, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines your spreadsheet tasks, from creating complex financial models to cleaning messy data, ensuring accuracy and professional presentation.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Data Cleaning & Restructuring: Fix malformed rows, misplaced headers, and messy tabular data.
  • Formula Management: Ensure all formulas are error-free and follow best practices.
  • Use Case: Convert a raw CSV export from your accounting software into a clean, well-formatted Excel report with dynamic formulas for variance analysis.

Quick Start

Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning messy data and formatting Excel spreadsheets?▼

Automate spreadsheet cleaning and formatting by using pandas for data manipulation and openpyxl for applying formulas and styles, fixing malformed rows and misplaced headers to produce well-structured xlsx files.

Can I convert a CSV file to an Excel report with dynamic formulas?▼

Yes, you can convert CSV files to Excel reports with dynamic formulas by loading the tabular data with pandas and writing it to xlsx using openpyxl to inject formulas and formatting.

Does this spreadsheet automation approach require LibreOffice for formula recalculation?▼

Yes, LibreOffice is required for formula recalculation via a dedicated script, ensuring that formulas injected into xlsx or xlsm files are computed correctly when processing data.

What is the best way to restructure tabular data across different spreadsheet formats?▼

The best way to restructure tabular data across formats like xlsx, csv, and tsv is using pandas for data manipulation, allowing you to add columns, compute formulas, and convert between formats.

How do I create a new Excel file with formulas and charts from raw data?▼

Create new Excel files with formulas and charts by processing raw data with pandas to structure the content, then leveraging openpyxl to apply dynamic formulas, formatting, and charting elements.

What spreadsheet formats are supported for data cleaning and conversion tasks?▼

Supported spreadsheet formats for data cleaning and conversion include .xlsx, .xlsm, .csv, and .tsv, allowing you to handle various tabular data structures and convert between them as needed.

Related Skills

Explore More Data & Analytics Skills→
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
bcastelinobcastelino
2

business-analyst

Analyze business data and create dashboards with Tableau and Power BI.

Community
Advanced
gehtalexeygehtalexey

phantom-pre-filter

Filter PhantomBuster CSV exports by blacklist, duration, and title rules.

Community
Intermediate
HaraldeRoesslerHaraldeRoessler

xlsx

Create, edit, and convert Excel, CSV, and TSV spreadsheet files.

Community
Intermediate