Guides

Problem-solving guides for common data tasks

Each guide starts with a real task, explains the issue, shows a small example, and links into a free DataXForge tool that runs in your browser.

Cleaning

Fix Invalid JSON OnlineFind broken JSON syntax, understand the error, and fix the payload in your browser without uploading private data.Use Fix Broken JSON
Remove Duplicate CSV RowsFind duplicate rows in a CSV and produce a cleaner dataset before importing, analyzing, or sharing it.Use Remove Duplicate Rows
Clean Messy CSV OnlineTrim whitespace, remove empty rows, normalize values, and prepare a CSV for analysis in the browser.Use CSV Cleaner
Detect Outliers in CSVFind numeric outliers in CSV columns before charts, reports, and model training.Use Outlier Detector
Remove Duplicate Rows OnlineStrip duplicate rows from CSV or JSON. Use Remove Duplicate Rows in your browser with no signup, no daily limit, and no backend processing for tool input.Use Remove Duplicate Rows
Remove Empty Fields OnlineDrop empty cells or null fields. Use Remove Empty Fields in your browser with no signup, no daily limit, and no backend processing for tool input.Use Remove Empty Fields
Trim Whitespace OnlineTrim leading/trailing whitespace in every field. Use Trim Whitespace in your browser with no signup, no daily limit, and no backend processing for tool input.Use Trim Whitespace
Fix Broken JSON OnlineRepair trailing commas, single quotes, comments. Use Fix Broken JSON in your browser with no signup, no daily limit, and no backend processing for tool input.Use Fix Broken JSON
Clean CSV OnlineAuto-detect and fix common CSV issues. Use CSV Cleaner in your browser with no signup, no daily limit, and no backend processing for tool input.Use CSV Cleaner
Normalize Column Names Onlinesnake_case, camelCase, or kebab-case headers. Use Normalize Column Names in your browser with no signup, no daily limit, and no backend processing for tool input.Use Normalize Column Names
Standardize Phone Numbers OnlineConvert phone numbers to a single format. Use Standardize Phone Numbers in your browser with no signup, no daily limit, and no backend processing for tool input.Use Standardize Phone Numbers
Validate Email OnlineBulk-validate a list of email addresses. Use Email Validator in your browser with no signup, no daily limit, and no backend processing for tool input.Use Email Validator
Analyze Data Type Detector OnlineInfer each column's data type. Use Data Type Detector in your browser with no signup, no daily limit, and no backend processing for tool input.Use Data Type Detector
Detect Corrupted Rows OnlineSpot rows with shape or type mismatches. Use Detect Corrupted Rows in your browser with no signup, no daily limit, and no backend processing for tool input.Use Detect Corrupted Rows
Format Inconsistent Data Finder OnlineFlag inconsistent formats inside a column. Use Inconsistent Data Finder in your browser with no signup, no daily limit, and no backend processing for tool input.Use Inconsistent Data Finder
Clean Null Value OnlineReplace, drop, or report null/empty cells. Use Null Value Cleaner in your browser with no signup, no daily limit, and no backend processing for tool input.Use Null Value Cleaner
Analyze Outlier Detector OnlineFlag statistical outliers in numeric columns. Use Outlier Detector in your browser with no signup, no daily limit, and no backend processing for tool input.Use Outlier Detector
Clean JSON Key Renamer OnlineRename keys with rules (snake_case, prefix strip, mapping table). Use JSON Key Renamer in your browser with no signup, no daily limit, and no backend processing for tool input.Use JSON Key Renamer
Clean Missing Value OnlineDetect, drop, fill, or interpolate missing values per column. Use Missing Value Cleaner in your browser with no signup, no daily limit, and no backend processing for tool input.Use Missing Value Cleaner
Analyze Smart Type Detection OnlinePer-column type inference: int, float, date, bool, enum, ID. Use Smart Type Detection in your browser with no signup, no daily limit, and no backend processing for tool input.Use Smart Type Detection
Validate Invalid Row Detector OnlineFlag rows that violate a schema or per-column constraints. Use Invalid Row Detector in your browser with no signup, no daily limit, and no backend processing for tool input.Use Invalid Row Detector
Convert Data Standardizer OnlineNormalize a column to a chosen format (e.g. dates, currencies, casing). Use Data Standardizer in your browser with no signup, no daily limit, and no backend processing for tool input.Use Data Standardizer
Format Phone Number OnlineReformat phone numbers (E.164, national, dashed) in a CSV column. Use Phone Number Formatter in your browser with no signup, no daily limit, and no backend processing for tool input.Use Phone Number Formatter
Convert Date Format Normalizer OnlineParse messy date strings and emit ISO-8601 (or any chosen format). Use Date Format Normalizer in your browser with no signup, no daily limit, and no backend processing for tool input.Use Date Format Normalizer
Convert Currency Standardizer OnlineNormalize currency strings ("$1,200.50" → 1200.50 USD) across rows. Use Currency Standardizer in your browser with no signup, no daily limit, and no backend processing for tool input.Use Currency Standardizer
Format Address OnlineStandardize address strings — case, abbreviations, components. Use Address Cleaner in your browser with no signup, no daily limit, and no backend processing for tool input.Use Address Cleaner

Problem-solving guides for common data tasks

Cleaning

Validation

Formatting

Transformation

Big Data

ETL

Analysis

Visualization

SQL & DB

Schema & Metadata

API

Security

Web & SEO

Spreadsheets

Logs

AI-Assisted

Research

Comparison

Extraction

Workspace

Developer

Calculators

DevOps

PDF

Files

Date & Time

Generators

Network

Email

Formats