# Clean a recurring invoice CSV before analytics

**Use case:** 

Coerce invoice totals and dates, enforce status rules, remove duplicate invoices, and export a validation report.

## Input

```json
{
  "csvText": "Invoice ID,Customer,Total,Issued At,Status\nINV-1001,Acme North,1499.95,2026-07-01,paid\nINV-1001,Acme North,1499.95,2026-07-01,paid\nINV-1002,Example Retail,-25,2026-07-04,pending\nINV-1003,Sample Studio,850,bad-date,unknown",
  "format": "auto",
  "normalizeColumnNames": true,
  "trimWhitespace": true,
  "emptyAsNull": true,
  "columnRules": [
    {
      "column": "invoice_id",
      "type": "string",
      "required": true
    },
    {
      "column": "total",
      "type": "number",
      "required": true,
      "min": 0
    },
    {
      "column": "issued_at",
      "type": "date",
      "required": true
    },
    {
      "column": "status",
      "type": "string",
      "required": true,
      "allowedValues": [
        "paid",
        "pending",
        "overdue"
      ]
    }
  ],
  "deduplicateBy": [
    "invoice_id"
  ],
  "duplicateAction": "remove",
  "caseInsensitiveDuplicates": true,
  "maxRows": 1000
}
```

## Output

```json
{
  "_sourceRow": {
    "label": "Source row",
    "format": "integer"
  },
  "_isValid": {
    "label": "Valid",
    "format": "boolean"
  },
  "_isDuplicate": {
    "label": "Duplicate",
    "format": "boolean"
  },
  "_issueCount": {
    "label": "Issues",
    "format": "integer"
  },
  "_issues": {
    "label": "Validation findings",
    "format": "array"
  }
}
```

## About this Actor

This example demonstrates how to use [CSV & Excel Data Quality Cleaner](https://apify.com/automation-lab/csv-excel-data-quality-cleaner) with a specific input configuration. Visit the [Actor detail page](https://apify.com/automation-lab/csv-excel-data-quality-cleaner) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/automation-lab/csv-excel-data-quality-cleaner.md

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).