Clean Data

Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet", "normalize this data",

概要

The Clean Data skill, part of the fivetaku/claude-office-skills repository, provides automated data normalization for spreadsheet users interacting with Claude or Claude Code. This utility addresses common data integrity issues by trimming extraneous whitespace, correcting inconsistent text casing, and converting numerical values stored as strings back into numeric formats. It further assists in data preparation by standardizing date formats, identifying duplicate entries, and flagging columns containing mixed data types. By streamlining these repetitive tasks, the skill ensures datasets are properly formatted for subsequent analysis or reporting. This implementation is part of a collection of office-oriented tools that has gained traction on GitHub, currently maintaining over 50 stars for its utility in spreadsheet management.

ユースケース

Normalizing raw CSV exports by removing duplicate rows and trimming leading or trailing spaces.

Standardizing date formats and text casing across large datasets to ensure consistency for reporting.

Converting numbers-stored-as-text and identifying mixed-type columns before performing mathematical analysis.

導入方法

# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/clean-data-xls/SKILL.md

Copy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.

セキュリティ

Users should ensure they have the necessary permissions to process the contents of their spreadsheets through AI agents. As this skill operates on data provided within the chat or file context, sensitive information should be handled according to organizational data privacy policies.