Max Power Services

03 / Practical digital delivery

Spreadsheet and CSV cleanup

Clean, traceable data with a clear record of every change.

Send an authorised spreadsheet or CSV export and I will profile its structure, apply your agreed schema and matching rules, standardise safe formatting, and return an import-ready dataset with a visible exception queue. Exact duplicates are logged, conflicting records are not silently merged, and ambiguous dates or missing required values remain flagged for your decision. You receive the cleaned file and a reconciliation report that explains what changed and where every source row went. SMALL PILOT — £60 fixed: one client-supplied file up to 500 rows and 10 columns. I apply agreed formatting and duplicate rules, return a clean CSV/XLSX plus exceptions and reconciliation notes, and include one revision. No scraping, sensitive live-system access or ambiguous automatic deletion. STANDARD PILOT — £250 fixed: up to 5,000 rows across two files and one target schema, with one correction pass. Larger or more complex work is separately scoped after inspection.

Start with a smaller pilot

Small CSV cleanup pilot · £60 fixed

Agreed formatting and duplicate rules only; ambiguous records remain visible.

Scope limits: Files: 1 · Rows: 500 · Columns: 10 · Revisions: 1

Rules: Agreed formatting and duplicate rules only; ambiguous records remain visible.

Included

Not included

The full-service option is also available on this page. We confirm the supplied inputs and acceptance target before production.

What you receive

  • Preserved source reference and source-row/target-row mapping
  • Clean UTF-8 CSV and XLSX workbook in one agreed target schema
  • Uncertain/rejected-row queue retaining raw values, reason codes and proposed next action
  • Reconciliation report covering counts, duplicate decisions, numeric/date rules and traceability
  • One concise handover note for the target-system import preview
  • One correction pass within the agreed schema and row cap

What to send

  • Authorised source export(s) and permission to process them
  • Target system/template and required versus optional fields
  • Stable source identifier and any relationship/key rules
  • Duplicate/matching and survivorship decisions
  • Date locale, accepted date formats, currency and decimal/thousands conventions
  • Named acceptance owner, delivery location and an approved preview/staging path if import preparation is required

Start with a description or a sanitised sample. We agree an appropriate transfer route for private material.

Scope and revisions

One consolidated revision against the agreed brief. New content, extra outputs or a changed direction are scoped separately.

What needs a separate scope
  • Live CRM/API or production-system import without a separate authorised scope
  • More than two files, 5,000 rows or one target schema
  • Bespoke fuzzy entity resolution, data enrichment or invented missing values
  • Unlimited revisions, ongoing support or a guarantee that an external system will accept an import

Timing starts after complete inputs and an agreed production slot. Additional work is agreed before it is started.

See the work

These are original demonstrations, not client commissions or evidence of paid results. The general archive shows related work; it does not imply every service has a public case study.

Read the data-cleanup worked example ↗

Ready to define the job?

Send the outcome you need, available material and target date. You will receive a clear scope and next step.

Discuss this service ↗Browse all eleven services