SkillsLib.ai

Xlsx

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

4.3(46 reviews)
100+ downloads
Updated Sep 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

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.

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.

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.

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.

Querying Indonesian Gov Data
$30
Querying Indonesian Gov Data

You can query over 50 Indonesian government APIs and data sources to build applications with authoritative Indonesian data. Verify halal certification status through BPJPH, check food/drug/cosmetic registration via BPOM, confirm financial entity legality through OJK, retrieve real-time weather and earthquake data from BMKG, access economic statistics from BPS, get exchange rates from Bank Indonesia, and look up Indonesian laws and regulations. The skill handles authentication, CSRF tokens, session management, and IP blocking workarounds so you can focus on building.

Pdf
$25
Backend4.4(48)
Pdf

You can perform end-to-end PDF operations including extracting text and metadata from documents, merging multiple PDFs into a single file, splitting PDFs by page ranges, filling fillable forms programmatically, and adding text overlays to non-fillable PDFs. This skill handles both simple read operations and complex document workflows, making it essential for document processing, form automation, and PDF batch operations.

Mechanical License Compliance Auditor
$45
Mechanical4.0(34)
Mechanical License Compliance Auditor

You can systematically verify licensing compliance across music compositions, calculate accurate mechanical royalties against current statutory rates, and generate audit-ready documentation that satisfies internal controls and external audit demands. This skill consolidates manual spreadsheet workflows into a structured, repeatable process with built-in error detection and cross-referencing against NMPA rates, licensing agreements, and regulatory requirements.

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.

$45.00