Separate accepting a file from committing records. Stage into an isolated run, inspect normalized rows, and promote atomically only when validation succeeds. Keep an audit trail and test repeat promotion so retries do not create duplicate writes.
Using a temporary database, run importkit stage, preview, promote, repeat promote, audit and rollback. The actual output below was generated in this order. The generic target table is not an integration into your production ERP.
Actual local test output — synthetic fixtures
csv-full-stage
{"config_hash": "4deb0835aad3680da8a4ee695d5440e6f7f2330a03a7fe6898afbffbbad7c651", "created": "2026-10-16T23:46:12.247Z", "dataset": "example_inventory", "id": "b26c646d9227053ea1d1d0bed56d13bd5bed9972afdfe79e21acd0f30d12667f", "invalid": 0, "skipped": 0, "source_hash": "e977bccc8502aba363f775fc009a16ae4f6d03db805f873d10af342c39e3b5b4", "status": "ready", "total": 2, "valid": 2}
csv-full-preview
[{"data": "{\"active\":true,\"available\":\"2026-10-07\",\"category\":\"hardware\",\"price\":\"19.95\",\"quantity\":12,\"sku\":\"SKU-001\"}", "disposition": "valid", "errors": "[]", "row_hash": "7614f95ca6095da2c8624894fef3da0fb2be553cf843f892db349e155f4133b8", "row_no": 2}, {"data": "{\"active\":false,\"available\":\"2024-02-29\",\"category\":\"software\",\"price\":\"0.1\",\"quantity\":0,\"sku\":\"SKU-002\"}", "disposition": "valid", "errors": "[]", "row_hash": "f21b464b21cb996c20d0977de92719e1b597ed568d4706f8d10355fa1e7c8b59", "row_no": 3}]
csv-full-promote
{"config_hash": "4deb0835aad3680da8a4ee695d5440e6f7f2330a03a7fe6898afbffbbad7c651", "created": "2026-10-16T23:46:12.247Z", "dataset": "example_inventory", "id": "b26c646d9227053ea1d1d0bed56d13bd5bed9972afdfe79e21acd0f30d12667f", "invalid": 0, "skipped": 0, "source_hash": "e977bccc8502aba363f775fc009a16ae4f6d03db805f873d10af342c39e3b5b4", "status": "promoted", "total": 2, "valid": 2}
csv-full-promote
{"config_hash": "4deb0835aad3680da8a4ee695d5440e6f7f2330a03a7fe6898afbffbbad7c651", "created": "2026-10-16T23:46:12.247Z", "dataset": "example_inventory", "id": "b26c646d9227053ea1d1d0bed56d13bd5bed9972afdfe79e21acd0f30d12667f", "invalid": 0, "skipped": 0, "source_hash": "e977bccc8502aba363f775fc009a16ae4f6d03db805f873d10af342c39e3b5b4", "status": "promoted", "total": 2, "valid": 2}
csv-full-audit
[{"at": "2026-10-16T23:46:12.247Z", "detail": "{}", "event": "run_created", "sequence": 1}, {"at": "2026-10-16T23:46:12.248Z", "detail": "{}", "event": "stage_attempt", "sequence": 2}, {"at": "2026-10-16T23:46:12.251Z", "detail": "{\"invalid\":0,\"skipped\":0,\"total\":2,\"valid\":2}", "event": "staged", "sequence": 3}, {"at": "2026-10-16T23:46:12.322Z", "detail": "{\"concurrent_skipped\":0,\"inserted\":2}", "event": "promoted", "sequence": 4}, {"at": "2026-10-16T23:46:12.360Z", "detail": "{}", "event": "promotion_noop", "sequence": 5}]
csv-full-rollback
{"config_hash": "4deb0835aad3680da8a4ee695d5440e6f7f2330a03a7fe6898afbffbbad7c651", "created": "2026-10-16T23:46:12.247Z", "dataset": "example_inventory", "id": "b26c646d9227053ea1d1d0bed56d13bd5bed9972afdfe79e21acd0f30d12667f", "invalid": 0, "skipped": 0, "source_hash": "e977bccc8502aba363f775fc009a16ae4f6d03db805f873d10af342c39e3b5b4", "status": "rolled_back", "total": 2, "valid": 2}
Python source kit with restricted XLSX support. Formula, macro and merged-cell workflows are not promised. Requires configuration and application integration; it is not a finished web UI.