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",
Overview
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.
Use Cases
Install Notes
# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/clean-data-xls/SKILL.mdCopy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.
Security Notes
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.
Related Skills
Xlsx
anthropics/skills
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scr...
Experience Lwc Widget Migrate
forcedotcom/sf-skills
Convert a specific existing Lightning web component (LWC) into a declarative HXL / Agentforce widget, end to end. Gates on experience-lwc-widget-assess and stops when a widget cannot serve the LWC's purpose; otherwise hands the derived field shape to platform-widget-generate and wires the widget as the Lightning Typ...
Experience Lwc Widget Assess
forcedotcom/sf-skills
Assess whether a specific Lightning web component can serve its user's purpose as an HXL declarative widget. Use for LWC-to-widget feasibility, portability audits, and candidate screening; use experience-lwc-widget-migrate when the user wants the widget built.
Service De Channel Consent Configure
forcedotcom/sf-skills
Configure consent (opt-in/opt-out) on an Enhanced `MessagingChannel` so activation will accept it. Given a `{CHANNEL_ID}`, sets the channel's `ConsentType` (ImplicitOptIn / ExplicitOptIn / DoubleOptIn) and the `OptInPrompt` / `DoubleOptInPrompt` prompt fields, then creates or updates one `MsgChannelLanguageKeyword`...
3-Statement Financial Model Template Completion
fivetaku/claude-office-skills
Complete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement). Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial
DCF Model Builder
fivetaku/claude-office-skills
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need