Finance tasks
Clean data xlsExcel financial modeling
Indexedanthropics/financial-services
Clean Spreadsheet DataFinance Skill
Instructions for profiling a sheet, proposing repairs, and applying helper-column formulas with confirmation before destructive changes. The two execution paths are Office JS and Python/openpyxl. Dates need an explicit input convention, and the openpyxl path needs a separate calculation engine to verify formula results; the directory contains no executable cleaner.
- Assessment score
- 80/100
- Snapshot risk
- Medium
- Audit conclusion
- Needs review
How the assessment score works
Pineify weights evidence recorded from the captured files: Skill structure 15%, Instruction clarity 20%, Dependency transparency 20%, Permission transparency 20%, Safety guardrails 15%, Finance task fit 10%. Each signal receives full credit for Yes, one-quarter credit for unknown, and none for No.
The score is not an output accuracy test or user rating. Read the findings and financial assumptions even when the score is high. Risk labels summarize recorded permissions and findings; they do not measure investment risk or certify that installation is safe.
Discovery
What this Skill helps an agent do.
Use the tasks and topics below to judge whether the captured workflow fits your question. Read its findings, dependencies and data requirements before relying on an output.
Domains and assets
Fundamental analysisPublic equities
Topics
clean-data-xlsdata-cleaningspreadsheet-prepnormalizationdeduplicationfinancial-analysis
Trust
Evidence from the captured directory.
This content snapshot assessment does not certify the repository, current files, or installation environment. "Not verified" means the captured files did not support a Yes or No conclusion.
License
Apache-2.0Yes
GitHub reports the repository license as Apache License 2.0.
Review state
- Automated review
- Automated review
- Install tested
- No
- Human reviewed
- Not verified
Snapshot
- Files reviewed
- 1
- Captured
- 2026-07-29 07:31 UTC
- Snapshot ID
- fsh-clean-data-xls-2026-07-29-001
Permissions
FilesystemRead
YesThe workflow reads spreadsheet data to profile columns, detect issues, and inspect cell values.
FilesystemWrite
YesThe workflow writes helper-column formulas and may overwrite in-place with computed values when explicitly requested.
NetworkAccess
NoNo network access or web search is required by the workflow.
ShellExecution
NoNo shell commands or scripts are included or referenced in the captured directory.
CodeExecution
YesThe instructions explicitly use Office JS inside Excel or Python/openpyxl for standalone workbooks; missing bundled scripts does not mean no code execution.
ExternalCredentials
NoNo external credentials or paid data sources are required for spreadsheet data cleaning.
Dependencies
openpyxl
Python library for standalone .xlsx file processing
Python openpyxl library for reading and writing .xlsx files outside Excel.
Data sources named by the Skill
User-provided spreadsheet
The user provides the spreadsheet data to be cleaned.
Snapshot assessment
80/100
Pineify Finance Skill snapshot assessment, version 1.0.0. Generated 2026-10-20 00:00 UTC.
Medium risk · Needs review
Skill structure
80/100Instruction clarity
100/100Dependency transparency
65/100Permission transparency
75/100Safety guardrails
65/100Finance task fit
100/100Audit findings
Medium
Resolve ambiguous dates before conversion
The example 3/8/26 is ambiguous without an input convention. DATEVALUE depends on system date settings. Confirm the intended day/month order before applying conversions, then inspect the resulting dates.
Medium
Writing formulas does not evaluate them
The standalone route uses openpyxl, which stores formulas but does not calculate their results. Verifying helper-column outputs needs a spreadsheet calculation engine; none is bundled with this directory.
Medium
Dependency manifest is absent from the snapshot
No requirements.txt or equivalent manifest is included in the captured directory, though openpyxl is referenced in the instructions.
Low
No financial advice boundary
The workflow prepares data for financial analysis but includes no explicit investment advice disclaimer.
Sources and relations
Context around this Skill.
Repository
anthropics/financial-services
topic
Clean spreadsheet data
agent
Claude Code
collection
Financial analysis
guide
Reviewing finance skills before install
Registry
Read this record as data.
The public record includes the page-safe snapshot, evidence, assessment, taxonomy, and relations. Internal revision fields stay outside the public projection.
- Record ID
- github:anthropics/financial-services:plugins/vertical-plugins/financial-analysis/skills/clean-data-xls
- Snapshot ID
- fsh-clean-data-xls-2026-07-29-001
This page is an informational registry entry, not investment advice or a security guarantee. A high content quality score does not make the Skill safe for every environment. Review current files, permissions, data sources, and financial assumptions before use.