More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    list clean and compare

    1

    Clean, validate, and compare messy Excel/CSV lists using deterministic Python scripts with full audit logs.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    list clean and compare

    list clean and compare

    Example session with this skill installed

    Profile members_2024.xlsx and tell me what needs fixing. Country code is +44 and the 'Email' column should never be empty.

    • Read your context and instructions
    • Compiled the list clean
    • Generated the document

    I have analyzed members_2024.xlsx. The header was detected at row 1, and I identified 152 rows across 6 columns.

    members_2024.xlsx · ⚠️ 4 things to decide

    Fixed: 42 cells (22 Phone numbers, 12 Date formats, 8 Name casing)
    Duplicates: 2 exact (merge recommended), 5 possible (typos in 'Last Name')
    Problems: 3 invalid emails, 7 missing emails (required field)

    ColumnDetected TypeIssues Found
    First NameTextMixed CAPITALS and lowercase
    Last NameTextExtra trailing spaces
    EmailEmail7 empty cells, 3 malformed addresses
    PhonePhoneMissing +44 prefix, inconsistent separators
    Join DateDateMixed DD/MM/YY and MM-DD-YYYY formats
    Member IDCodeStored as number (leading zeros at risk)

    Next steps

    1. Would you like me to merge the 2 exact duplicates?
    2. Review the 5 "possible" duplicates: 'John Smit' vs 'John Smith' and 'Sara O'Connor' vs 'Sara O Connor'.
    3. Run the clean command to generate the cleaned.xlsx file with the audit log.

    members_2024.xlsx

    PDF · document

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Messy spreadsheets with inconsistent formatting, duplicate entries, and hidden errors waste hours of manual work. This skill automates the tedious process of cleaning Excel and CSV files while ensuring data integrity through deterministic Python scripts and detailed change logs.

    What it does

    • Standardizes formatting by fixing irregular casing, trimming whitespace, and unifying date formats to YYYY-MM-DD.
    • Validates data to identify invalid emails, malformed phone numbers, and missing required values.
    • Detects duplicates using both exact matches and similarity algorithms to catch typos or near-misses.
    • Performs list comparison between two versions to track who is new, who left, and exactly which cells changed.
    • Preserves data by never modifying original files and outputting results to a dedicated directory with full audit trails.

    How it works

    1. Profiling phase where the agent analyzes the file structure to detect headers, column types, and data quality issues.
    2. Cleaning phase where the user provides configuration for phone country codes and required fields to generate a cleaned output.
    3. Deduplication phase where exact matches are merged and potential typos are flagged for human review.
    4. Comparison phase where two lists are mapped and cross-referenced to identify additions, removals, and updates.

    Frameworks & tools

    The skill uses a standalone Python 3.8+ script utilizing the standard library for deterministic processing. It handles .xlsx and .csv formats natively.

    Why this beats prompting it yourself

    Standard LLM prompts often hallucinate data or silently truncate large lists when "cleaning" text. This skill uses executable code to ensure every single row is processed accurately with a permanent log of every change made.

    Use cases

    • Cleaning membership directories for clubs or non-profit associations.
    • Reconciling monthly sales reports to find new leads and churned customers.
    • Normalizing employee contact lists for HR system migrations.

    Known limitations

    Does not support legacy .xls files directly; users must save them as .xlsx or .csv first. Requires a Python 3.8 environment for execution.

    Requires Python 3.8 or higher. Cannot process legacy .xls files directly without conversion to .xlsx or .csv. No network access for external API validation.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    Requires

    Python

    Permissions

    No special permissions declared or detected

    Listed1 month ago

    What's inside

    Frequently Asked Questions

    Unlike standard AI prompts that may skip rows or hallucinate data, this skill uses deterministic Python scripts to ensure every single entry is processed with 100% accuracy and a verifiable audit trail.

    The skill natively supports .xlsx and .csv files; however, legacy .xls files must be saved as .xlsx before processing to ensure compatibility with modern data libraries.

    You will receive the standalone Python cleaning scripts, a configuration guide for custom validation rules, and documentation for integrating the skill into your existing AI agent workflow.

    Yes, the comparison phase allows you to map two different files to identify specific changes, such as new additions, deletions, or cell-level updates between versions.

    The skill requires a Python 3.8+ environment and is designed to be called by any AI agent capable of executing local Python scripts or managing file-based workflows.

    The skill generates a detailed change log in a separate directory, documenting every modification made so you can verify the cleaning process without altering your original source data.

    New in Workflow Automation