Skills
.Work. You
Rest

clean-data-xls

Official

Clean and normalize spreadsheet data.

Data & Analytics#spreadsheet#excel#deduplication#data cleaning#data preparation#data normalization
Authoranthropics
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill tackles messy, inconsistent, or improperly formatted data within spreadsheets, preparing it for accurate analysis.

Core Features & Use Cases

  • Data Cleaning: Removes leading/trailing whitespace, standardizes casing, converts numbers stored as text, and corrects date formats.
  • Deduplication: Identifies and flags duplicate or near-duplicate rows.
  • Issue Detection: Profiles columns to detect mixed data types, blanks, and encoding errors.
  • Use Case: You've received a sales report with inconsistent customer names (e.g., "Acme Corp", "acme corp", "ACME CORP") and currency symbols mixed with numbers. This Skill will standardize the names and ensure all monetary values are recognized as numbers.

Quick Start

Use the clean-data-xls skill to clean up the data in the attached spreadsheet.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: clean-data-xls
Download link: https://github.com/anthropics/financial-services-plugins/archive/main.zip#clean-data-xls

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.