---
name: prospect-list-cleanup
description: >-
  Normalizes and improves the consistency of prospect-list data. Use
  when the user provides a messy prospect or lead export and wants
  standardized records, flagged issues, and a cleanup summary.
license: MIT
metadata:
  author: ProfileSpider
  version: "1.0"
  category: data-cleanup
  source: https://profilespider.com/resources/prospect-list-cleanup
---

# Prospect List Cleanup

## Purpose

Normalize and improve the consistency of prospect-list data before outreach or import.

## When to use this skill

- Preparing an export for CRM or outreach import
- Standardizing names, casing, and formats
- Flagging incomplete or broken rows
- Producing a defensible cleanup audit

## When not to use this skill

- You need verified emails or enrichment, not cleanup
- The file has no consistent columns to normalize
- You want hard de-duplication (use Duplicate Record Review)

## Required inputs

- A prospect or lead list

## Optional inputs

- A target column schema
- Formatting conventions (casing, phone format)
- Fields that are mandatory

## Rules

1. Standardize formatting; do not invent missing values.
2. Flag incomplete and suspect rows rather than deleting them.
3. Record every change in normalization notes.
4. Preserve the original value when flagging an error.
5. Apply the same conventions to every row.

## Process

1. Profile the columns and detect formats.
2. Normalize casing, names, companies, and formats.
3. Flag incomplete and suspected-error rows.
4. Record normalization notes.
5. Produce a cleanup summary with counts.

## Output format

Return the cleaned list plus a summary with the following fields:

- standardized_records
- incomplete_records
- suspected_errors
- normalization_notes
- cleanup_summary

## Validation

- Confirm no values were invented.
- Confirm flagged rows retain their original data.
- Confirm the summary counts match the records.

## Limitations

- It standardizes formatting, not factual accuracy.
- Suspected errors are heuristics and should be reviewed.

## Source and license

Source: https://github.com/spiralcrew-ou/profilespider-agent-skills/blob/6c65d0507687364704a180476613b72467028e87/prospect-list-cleanup/SKILL.md

MIT License

Copyright (c) 2026 SpiralCrew

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.