Profile and Detect CSV Anomalies

Profile CSV columns, detect anomalies, then clean flagged data.

Intermediate~4 mincsvanalyzequality

Use case

Use this for quality checks before ingestion when data consistency is uncertain.

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.

Profile CSV columns, detect anomalies, then clean flagged data.

Current focusStep 1 · CSV Column Profiler

0% complete

Step 1csv-tools Waiting

CSV Column Profiler

CSV → JSON

Profile CSV columns

Review the result here before moving to the next step.

Step 2csv-tools Waiting

CSV Anomaly Detector

JSON → JSON

Detect anomalies

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

Step 3csv-tools Waiting

CSV Cleaner

CSV → CSV

Clean CSV

Normalized CSV ready for the next workflow step.

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 Column Profiler

Progress is stored locally in this browser.

Step 1Ready to runcsv-tools

CSV Column Profiler

Profile CSV columns with inferred type, emptiness, uniqueness, top values, and numeric percentiles.

Open full tool

CSV input

Provide csv input for this workflow step.

Column profile report

Review the result here before moving to the next step.

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

Step 2Lockedcsv-tools

CSV Anomaly Detector

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

Open full tool

Complete the previous step first

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

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 3Lockedcsv-tools

CSV Cleaner

Trim whitespace and normalize CSV records before conversion.

Open full tool

Complete the previous step first

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

CSV input

Paste the raw CSV you want to normalize.

Cleaned CSV

Normalized CSV ready for the next workflow step.

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