Anomaly Check Before Load

Detect anomalies, validate CSV shape, then convert to JSON for loading.

Intermediate~4 mincsvanomalyetl

Use case

Use this before ETL/database import to catch issues early.

Workflow overview3 steps0 / 3 completed~4 min

What to expect

Follow the steps from left to right for a quick overview, then use the inline stepper below to run each tool.

Detect anomalies, validate CSV shape, then convert to JSON for loading.

Current focusStep 1 · CSV Anomaly Detector

0% complete

Step 1csv-tools Waiting

CSV Anomaly Detector

JSON → JSON

Detect anomalies

JSON report with missing values, type errors, outliers, and duplicate keys.

Step 2csv-tools Waiting

CSV Validator

CSV → TEXT

Validate CSV

Status report with column count and any detected errors.

Step 3csv-tools Waiting

CSV to JSON Converter

CSV → JSON

Convert to JSON

JSON generated from the CSV input.

Workflow steps

Run this workflow inline

Work through each tool step here. Running a step automatically prepares the next step with the correct handoff value.

Workflow shortcut

Next unlocked step: Step 1 · CSV Anomaly Detector

Progress is stored locally in this browser.

Step 1Ready to runcsv-tools

CSV Anomaly Detector

Identify data quality issues in CSV: missing values, numeric outliers (IQR), type inconsistencies, and duplicate key rows.

Open full tool

Anomaly detector input (JSON envelope)

Provide { "csv": "...", "numericColumns"?: ["age"], "keyColumn"?: "id" }.

Anomaly report

JSON report with missing values, type errors, outliers, and duplicate keys.

Run this step to process the current input and prepare the next workflow stage.

Step 2Lockedcsv-tools

CSV Validator

Validate CSV syntax and structure — checks column consistency, unclosed quotes, and empty headers.

Open full tool

Complete the previous step first

This step unlocks automatically after all earlier workflow steps are completed successfully.

CSV input

Paste CSV to validate. The original CSV is passed to the next step on success.

Validation result

Status report with column count and any detected errors.

Run this step to process the current input and prepare the next workflow stage.

Step 3Lockedcsv-tools

CSV to JSON Converter

Convert CSV rows with headers into a clean JSON array.

Open full tool

Complete the previous step first

This step unlocks automatically after all earlier workflow steps are completed successfully.

CSV input

Paste CSV rows with a header row.

JSON output

JSON generated from the CSV input.

Run this step to process the current input and prepare the next workflow stage.