# Sample Delivery: Spreadsheet Cleanup

Client type:
Small B2B service business preparing a lead list for CRM import

Input:
`sample-leads-raw.csv`

Output:
`sample-leads-cleaned.csv`

Report:
`sample-leads-cleaning-report.txt`

## Before

The raw file included:

- Extra spaces around names, emails, companies, and URLs.
- Mixed header formatting.
- 2 exact duplicate rows.
- 1 fully blank row.
- 3 blank cells that still need client review.

## After

The cleaned file includes:

- Normalized `snake_case` headers.
- Trimmed cell values.
- Exact duplicate rows removed.
- Fully blank row removed.
- Clean CSV ready for review, import prep, or manual enrichment.

## Delivery Note

Hi {client_name}, the cleaned spreadsheet is ready.

I cleaned the CSV, removed exact duplicate rows, normalized the headers, trimmed extra spaces, and included a short report showing row counts, duplicate removals, and remaining blank cells.

Please review the rows with blank values before importing into a CRM or starting outreach.

# Sample Delivery: PDF Table To Excel

Client type:
Small finance or operations team converting PDF invoice tables into Excel for review

Input:
`sample-pdf-table-raw.txt`

Output:
`sample-pdf-table-cleaned.csv`

Report:
`sample-pdf-table-qa-report.txt`

## Before

The raw PDF/OCR text included:

- Columns separated by variable spacing.
- Currency values with commas.
- A total row that did not match the normal row shape.
- Blank fields in the total row that needed buyer review.

## After

The cleaned file includes:

- Normalized `snake_case` headers.
- Preserved invoice number, date, customer, amount, and status columns.
- CSV escaping for comma-formatted currency values.
- One flagged row for review because totals often come from merged PDF cells.
- A QA report listing row counts, column counts, flagged rows, and recommended checks.

## Delivery Note

Hi {client_name}, the PDF table conversion sample is ready.

I converted the extracted table into CSV, preserved the visible row order, kept uncertain total-row fields blank instead of guessing, and included a QA report showing the checks I performed.

Please compare the flagged total row against the source PDF before using the file for accounting, import, or reporting.