🧹

Data Cleaning

18 tools

Clean, deduplicate, transform, and analyze CSV and spreadsheet data.

Category Overview

Data Cleaning covers CSV cleanup and tabular data prep for analysts, ops teams, marketers, and anyone fixing exported spreadsheet or CSV data. The data-cleaning set is built for profiling, standardizing, splitting, merging, filtering, anonymizing, and validating structured data.

Inside this category you can move between tools for csv profile, data profiling, deduplicate, and remove duplicates without losing context. That makes the page useful as both a discovery hub and a quick bookmark for repeat workflows.

Popular Tasks in This Category

CSV Profiler: Profile CSV data: types, nulls, unique values, and statistics

Deduplicate Rows: Remove duplicate rows by selected key columns

Split CSV Column: Split a CSV column by delimiter into multiple columns

Merge CSVs: Merge multiple CSV files by a common key column

Pivot Table: Create pivot table summaries from CSV data

Filter & Sort Export: Filter, sort, and export data with a visual interface

Good Fit For

People who want a tighter browser workflow for CSV cleanup and tabular data prep instead of digging through multiple unrelated tools.

Teams that need faster turnaround on one-off tasks, cleanup jobs, format changes, validation checks, or export preparation.

Tasks that benefit from browser-side processing, easier handoff, and fewer unnecessary steps between input and output.

Browse All Data Cleaning

📊

CSV Profiler

Profile CSV data: types, nulls, unique values, and statistics.

🧹

Deduplicate Rows

Remove duplicate rows by selected key columns.

✂️

Split CSV Column

Split a CSV column by delimiter into multiple columns.

🔗

Merge CSVs

Merge multiple CSV files by a common key column.

📊

Pivot Table

Create pivot table summaries from CSV data.

🔽

Filter & Sort Export

Filter, sort, and export data with a visual interface.

📅

Date Format Normalizer

Normalize mixed date formats into a consistent format.

📈

Detect Outliers

Detect statistical outliers using IQR and z-score methods.

📊

Histogram Generator

Generate histogram charts from CSV column data.

🔄

JSON to CSV Converter

Convert nested JSON data to flat CSV format.

🔄

CSV to JSON Converter

Convert CSV data to structured JSON format.

🔒

Anonymize Dataset

Anonymize sensitive columns by masking data.

🎲

Synthetic Data Generator

Generate synthetic datasets with configurable schemas.

✅

Validate Email/Phone Columns

Validate email and phone number format in CSV columns.

❌

Bad Rows Extractor

Extract and explain bad/invalid rows from datasets.

📝

Column Rename & Reorder

Rename and reorder CSV columns with drag and drop.

📏

Unit Converter for Columns

Convert units in CSV columns (km↔mi, kg↔lb, etc.).

🔧

Fix Encoding

Remove BOM and fix character encoding issues in files.

Frequently Asked Questions

What can I do in the Data Cleaning category?

Clean, deduplicate, transform, and analyze CSV and spreadsheet data. Typical tasks include csv profile, data profiling, deduplicate, and remove duplicates and other related jobs that share the same workflow context.

How should I choose the right data cleaning page?

Start with the specific result you need, such as csv profiler or deduplicate rows. Then pick the page whose description matches your exact input, output, and review requirements.

Why use a dedicated data cleaning page instead of a generic app?

Dedicated pages are easier to rank, easier to revisit, and clearer for repeat work because each one focuses on a single outcome instead of forcing every task into a broad interface.