CSV Structural Diagnostics

Audit supplied UTF-8 CSV text for duplicate or blank headers, inconsistent row widths, duplicates and edge whitespace. Read-only, evidence-linked findings; no repairs.

Input and output

One comma-delimited UTF-8 text input, at most 1 MB, 5,000 data records and 100 columns. Diagnostics only. No cleaned file, deduplication, inference, imports or certification. Record positions count the header as record 1. Cell-position detail is capped at 1000 findings per category, with exact totals and explicit truncation markers.

Fictional input example:

{
  "csvText": "sku, price\nA, 2.50 \nA, 2.50 \nB,3.00,extra\n"
}

Fictional report example (the dataset returns an array containing this report):

{
  "schemaVersion": "1.0",
  "tool": "csv-diagnostics",
  "audit": {
    "mode": "audit_only",
    "input_sha256": "d0418f6eeb0b5211d6c5c8790b6fc54ade07a9fd5ebd4ca689c25efca4b1542d",
    "input_bytes": 42,
    "data_records": 3,
    "columns": 2,
    "utf8_bom_removal_proposed": false,
    "whitespace_cells_proposed": 3,
    "changed_cell_positions": [
      {
        "record": 1,
        "column": 2
      },
      {
        "record": 2,
        "column": 2
      },
      {
        "record": 3,
        "column": 2
      }
    ],
    "duplicate_normalized_headers": [],
    "inconsistent_width_records": [
      4
    ],
    "empty_records_preserved": [],
    "exact_duplicate_original_records_preserved": [
      [
        2,
        3
      ]
    ],
    "duplicate_after_trim_records_preserved": [
      [
        2,
        3
      ]
    ],
    "apply_blockers": [
      "inconsistent_record_widths"
    ],
    "trimming_exposes_formula_like_cells": [],
    "proposed_output_sha256": "dd2493655fae8a10de89dd5b5a82975b4a15e1baf854a4fd0a8e529b5a3721f4",
    "proposed_output_bytes": 41,
    "preservation": "Record order, empty records, duplicates and string values preserved except approved edge-whitespace trimming and leading file BOM removal. No type conversions.",
    "record_numbering": "CSV records including header=1; quoted multiline fields are one record.",
    "format": "UTF-8 without BOM, comma-delimited, csv.writer quoting and CRLF record endings. Not a byte-preserving rewrite.",
    "import_ready_certification": false,
    "detail_limits": {
      "changed_cell_positions": {
        "total": 3,
        "reported": 3,
        "truncated": false
      },
      "trimming_exposes_formula_like_cells": {
        "total": 0,
        "reported": 0,
        "truncated": false
      }
    }
  },
  "boundaries": "Read-only diagnostics. Cell-position details are limited to the first 1000 findings per category, with exact totals and truncation markers. No cleaned file, deduplication, field mapping, store import, type inference, or import certification."
}

The output is one report item in the default dataset, not one billed item per source row. No external source is fetched. Use authorized nonsensitive or redacted input. Input and results are stored by Apify under its retention/access rules; this is not a browser-local service.

Calling from an agent

After publication, discover this Actor through Apify Store / the Apify MCP server, inspect its input schema and current pricing, then run it with a bounded budget. Retrieve the default dataset only after a successful run. Check review flags; a completed diagnostic report may describe invalid input records. Never assume reviewed data is safe to import or execute.

Pricing and delivery

Trial price: USD 0.05 per completed report, not per input row. Check the current Store pricing before running; that listing is authoritative. One paid event report, with no paid startup/default-dataset events and no platform-usage passthrough. Set a spending budget before starting. Demand and margin remain unvalidated. The adapter supports FREE/unpriced testing and this single-event PPE model and rejects other paid configurations.

Invalid batch input fails before our custom charge. Reports containing row-level review findings are completed reports. Storage and billing are not transactional: a delivery/billing error is marked uncertain where possible and is never retried automatically. Existing dataset/status evidence blocks restarting the same run. Inspect delivery and charges before any manual retry; a new run is a new purchase.

Built by SuperFresh Labs. No customer results, usage or income claimed.