SkillsLib.ai

Xlsx

Open, edit, create, and transform spreadsheet files in Excel and CSV formats

4.3(46 reviews)
100+ downloads
Updated Nov 2026
Verified SafeSecurity VerifiedThis skill was analyzed by our AI security scanner for harmful content including data exfiltration, system manipulation, credential theft, and prompt injection. No threats were detected.

What You Can Do

This skill lets you handle spreadsheet files as primary inputs and outputs. You can open and read existing Excel or CSV files, edit them by adding columns, computing formulas, and applying formatting, clean up messy or malformed data into proper spreadsheets, create new spreadsheets from scratch or from other data sources, and convert between tabular file formats. Every output file is delivered error-free and production-ready.

Features

Open and read .xlsx, .xlsm, .csv, and .tsv files directly within Claude
Add columns, compute formulas, and apply professional formatting to existing spreadsheets
Clean messy tabular data—fix malformed rows, misplaced headers, and junk data automatically
Create new spreadsheets from scratch or convert data between file formats
Generate charts and pivot tables for data visualization
Verify all formulas for errors (#REF!, #DIV/0!, #VALUE!, #N/A) before delivery
Preserve existing template styles and conventions when updating files
Apply industry-standard color coding for financial models (blue for inputs, black for calculations)

Example Output

Example 1: Data Cleanup Input: Messy CSV with duplicate rows, missing headers, and inconsistent formatting Output: Clean .xlsx file with proper headers, deduplicated data, consistent formatting, and a summary tab showing row counts before/after

Example 2: Financial Model Input: Existing quarterly budget template Output: Updated spreadsheet with new Q4 data, formulas linked to input cells (color-coded blue), calculation cells (black), and a summary dashboard with charts

Example 3: Format Conversion Input: Multiple .csv files from different sources Output: Single consolidated .xlsx workbook with separate sheets for each source, consistent formatting, and a master index sheet

What's Included

  • SKILL.md: Complete instructions for triggering and executing spreadsheet tasks
  • Formula validation checklist: Step-by-step process to eliminate errors before delivery
  • Professional formatting template: Font, color, and style standards for Excel outputs
  • Data cleaning workflow: Systematic approach for handling messy or malformed tabular data
  • Color coding guide: Industry-standard conventions for financial models and input/output cells

Who It's For

  • Data analysts — preparing datasets for analysis and visualization
  • Financial professionals — building and maintaining budget, forecast, and valuation models
  • Business administrators — organizing and consolidating operational data
  • Researchers — cleaning and structuring survey or experimental data
  • Operations managers — converting raw reports into actionable spreadsheets

Best For

  • Opening and editing Excel files with formulas and formatting intact
  • Converting between .xlsx, .csv, and .tsv file formats
  • Cleaning messy data with inconsistent formatting, duplicates, or missing headers
  • Building financial models with color-coded inputs and calculated outputs
  • Creating new spreadsheets from raw data or combining multiple data sources

You might also like

Shapely Compute
$30
Shapely Compute

You can construct geometric objects (points, lines, polygons, multigeometries), execute boolean operations (intersection, union, difference), apply spatial predicates (contains, intersects, within), calculate measurements (area, length, distance, centroid), and transform geometries through translation, rotation, and scaling. This skill handles geometry validation, invalid geometry repair, and complex spatial analysis tasks.

ETL Pipeline Design & Optimization
$25
ETL Pipeline Design & Optimization

Analyze your data pipeline architecture, identify performance bottlenecks, and receive detailed optimization strategies. You'll get architectural recommendations for scalability, data quality assurance patterns, and concrete implementation guidance for improving throughput and reducing latency in your ETL workflows.

Music Licensing Rights Clearance Advisor
$25
Licensing4.2(11)
Music Licensing Rights Clearance Advisor

You can systematically identify all licensing requirements for a musical work across multiple territories, coordinate approvals from rights holders and collection societies, and generate legally compliant clearance letters and license terms. This skill maps composition rights (mechanical, performance, synchronization) and sound recording rights (master use, digital performance) while accounting for territory-specific regulations like EU directives, UK post-Brexit rules, and jurisdiction-specific collection society requirements.

Product Self Knowledge
$25
Tier 24.0(28)
Product Self Knowledge

This skill prevents you from providing incorrect information about Anthropic's products by routing you to official documentation. You'll verify details about Claude API (models, rate limits, function calling, batch processing), Claude Code (installation, Node.js requirements, MCP integration), and Claude.ai (subscription tiers, feature limits) before answering user questions. Use it whenever you're uncertain about product specs, pricing, or capabilities.

Data Extraction From Documents
$35
Data Extraction From Documents

You can systematically extract key information from multiple documents and normalize it into consistent, schema-enforced formats. Claude identifies entities (people, organizations, dates, products), maps relationships between them, standardizes values (currencies, units, date formats), and flags data quality issues—all while maintaining accuracy across batches of similar or diverse document types.

Data Pipeline Architect
$40
Data Pipeline Architect

You can design complete data pipeline architectures that reliably move data from source systems to analytical or operational destinations. This skill helps you choose between ETL vs. ELT patterns, select appropriate orchestration tools (Airflow, Prefect, dbt), map complex data flows, handle schema evolution, embed data quality checks, and create maintainable pipeline specifications that scale with your organization.

Pdf Reading
$35
Pdf Reading

You can read PDFs directly from disk, extract text and embedded content, identify document structure (text-based vs. scanned), list images and attachments, and choose the right extraction strategy based on document type. This skill helps you understand what's in a PDF before processing it, diagnose extraction issues, and pull specific content like tables, forms, and embedded files.

File Reading
$45
Backend4.4(50)
File Reading

When a user uploads a file to Claude, you can intelligently detect its type and read it using the appropriate method. Instead of blindly running cat on binary files or loading massive CSVs into context, this skill routes each file type to the right tool, reading only what's needed to answer the user's question. You'll extract text from PDFs, parse structured data from CSVs and JSON, process images, and decompress archives—all without wasting context or producing garbage output.

$45.00