202 Free Online Data Tools - JSON, CSV, YAML, XML, SQL

Recommended workflows

Schema MapperMap source fields to a target schema with confidence scores.
Dataset Health AnalyzerScore CSV health across missing values, duplicates, row shape, and type consistency.
Missing Data ReportAnalyze missing values by column and row with CSV, heatmap, and markdown outputs.
CSV CleanerAuto-detect and fix common CSV issues.
JSON FormatterPretty-print, minify, and indent JSON safely.
SQL Query AnalyzerInspect a query: tables, joins, projections, filters.

Popular tools

JSON → CSVConvert a JSON array of objects into clean CSV.
CSV → JSONParse CSV into JSON — with header detection.
JSON ↔ YAMLConvert between JSON and YAML in either direction.
JSON FormatterPretty-print, minify, and indent JSON safely.
JSON ValidatorValidate JSON syntax with helpful error messages.
CSV → ChartsRender quick charts from a CSV.
Universal Data LabDrop in any CSV/JSON/Excel/XML — auto-detect, profile, clean, visualize, export.
JSON WorkspaceOpen any JSON, browse, search, edit, and export — all in one workspace.

All matching tools

Compact list optimized for scanning.

Address CleanerCleaningStandardize address strings — case, abbreviations, components.Open
Aggregation BuilderSQL & DBBuild GROUP BY / HAVING / window aggregations visually.Open
AI Column MapperAI-AssistedMap fields between two datasets with AI.Open
Apache Log ParserLogsParse Apache access logs into structured rows.Open
API Field MapperAPIMap fields between two API shapes.Open
API Response FormatterAPIPretty-print and inspect API JSON.Open
API Schema ExtractorAPIInfer a schema from sample responses.Open
Auto Data Repair SuggestionsAI-AssistedScan a dataset and suggest fixes — types, nulls, formats.Open
Auto Schema DetectorSchema & MetadataInfer a schema (types, nullability, uniqueness) from any sample dataset.Open
Auto-Clean DatasetAI-AssistedOne-click dataset cleaning suggestions.Open
Batch ConverterBig DataConvert many files in one go.Open
Collapsible Tree ViewerBig DataRender any JSON as an interactive collapsible tree.Open
Column AnalysisAnalysisType, range, nulls for every column.Open
Column Relationship DetectorSchema & MetadataSpot foreign-key candidates and 1:1 / 1:N relationships.Open
Column SplitterSpreadsheetsSplit a column by delimiter into multiple.Open
Column StatisticsAnalysisMin/max/mean/median/stddev/quartiles for every numeric column.Open
Conditional FormattingSpreadsheetsGenerate conditional-formatting rules.Open
Convert Data TypesETLRecast columns: string ↔ number ↔ date.Open
Correlation MatrixAnalysisPairwise correlations between numeric columns.Open
Credit Card Format CheckerValidationValidate card number format and Luhn check.Open
CSV → ChartsVisualizationRender quick charts from a CSV.Open
CSV → ExcelTransformationGenerate a downloadable .xlsx workbook from CSV.Open
CSV → JSONTransformationParse CSV into JSON — with header detection.Open
CSV → SQL InsertsTransformationGenerate INSERT statements from CSV rows.Open
CSV → XMLTransformationConvert tabular CSV into XML rows.Open
CSV Chunk SplitterBig DataSplit a huge CSV into manageable chunks.Open
CSV CleanerCleaningAuto-detect and fix common CSV issues.Open
CSV Column AnalyzerAnalysisPer-column types, ranges, uniques, nulls.Open
CSV Column FormatterFormattingAlign CSV columns visually.Open
CSV CompareComparisonRow-level diff between two CSV files.Open
CSV Duplicate FinderAnalysisSurface duplicate rows by chosen key columns.Open
CSV Filter BuilderETLBuild complex row filters across columns visually.Open
CSV MergerETLMerge multiple CSV files into one — header-aware.Open
CSV Row SearchBig DataFull-text search across every cell of a CSV.Open
CSV Sampling ToolBig DataSample N rows / X% / stratified samples from large CSV.Open
CSV SplitterBig DataSplit a large CSV into N files by row count, by value, or by hash.Open
CSV Structure ValidatorValidationCatch ragged rows and quoting issues.Open
CSV ViewerBig DataOpen and browse any CSV — sortable, filterable, searchable.Open
CSV WorkspaceWorkspaceOpen any CSV, profile columns, filter rows, edit cells, export.Open
Currency StandardizerCleaningNormalize currency strings ("$1,200.50" → 1200.50 USD) across rows.Open
Data Dictionary GeneratorSchema & MetadataGenerate a markdown / CSV data dictionary from any dataset.Open
Data Distribution ViewerAnalysisHistograms / KDE per column with quick outlier flags.Open
Data Filter ToolSpreadsheetsBuild complex filters across columns.Open
Data Masking ToolSecurityMask sensitive fields in a dataset.Open
Data StandardizerCleaningNormalize a column to a chosen format (e.g. dates, currencies, casing).Open
Data Type DetectorCleaningInfer each column's data type.Open
Data Validation PipelineETLChain validators on a dataset and surface row-level failures.Open
Dataset Diff CheckerComparisonFind missing or changed records.Open
Dataset Health AnalyzerAnalysisScore CSV health across missing values, duplicates, row shape, and type consistency.Open
Dataset Insight GeneratorAI-AssistedAuto-surface notable findings in a dataset.Open
Date Format NormalizerCleaningParse messy date strings and emit ISO-8601 (or any chosen format).Open
Detect Corrupted RowsCleaningSpot rows with shape or type mismatches.Open
Distribution AnalysisAnalysisSkewness, kurtosis, histogram per column.Open
Drag & Drop Chart BuilderVisualizationDrag a column onto X / Y / color and a chart appears.Open
Duplicate AnalysisAnalysisQuantify exact and near-duplicates.Open
Duplicate FinderSpreadsheetsHighlight duplicate rows in a sheet.Open
Dynamic FiltersVisualizationLive filters across all charts on a multi-chart canvas.Open
Email ExtractorExtractionPull every email address from any text.Open
Email ValidatorCleaningBulk-validate a list of email addresses.Open
ER Diagram GeneratorSQL & DBGenerate an ER diagram from CREATE TABLE statements.Open
Error Log AnalyzerLogsGroup errors and surface hot spots.Open
Error Pattern DetectorLogsGroup log lines by signature; surface error spikes.Open
ETL BuilderETLUpload, transform, map, and export visually.Open
ETL StudioETLDrag-and-drop ETL canvas: upload, transform, map, merge, export.Open
Excel → CSVTransformationConvert .xlsx sheets into CSV — reads every sheet in your browser.Open
Excel → DashboardVisualizationTurn a spreadsheet into a small dashboard.Open
Excel → JSONTransformationRead .xlsx and emit JSON per sheet (objects or arrays).Open
Excel Column ProfilerSpreadsheetsPer-column types, nulls, and uniqueness for every sheet.Open
Excel Multi-Sheet ViewerSpreadsheetsOpen every sheet of an .xlsx file and switch between them.Open
Excel Sheet ViewerSpreadsheetsOpen .xlsx files directly in the browser — sortable, searchable.Open
Excel WorkspaceWorkspaceOpen multi-sheet Excel — browse, profile, visualize, and export each sheet.Open
Fake Data ReplacerSecurityReplace real fields with realistic fakes.Open
Fake Dataset GeneratorSQL & DBRealistic seed data on demand.Open
Filter RowsETLFilter rows by predicate.Open
Fix Broken JSONCleaningRepair trailing commas, single quotes, comments.Open
Formula GeneratorSpreadsheetsBuild Excel & Google Sheets formulas — 30+ functions with parameters and explanations.Open
Formula InspectorSpreadsheetsTrace and explain Excel formulas — functions, references, parse tree, error checks.Open
Frequency DistributionAnalysisValue-count tables for categorical columns.Open
HeatmapsVisualizationVisualize a matrix as a heatmap.Open
HistogramsVisualizationPlot the distribution of a numeric column.Open
Inconsistent Data FinderCleaningFlag inconsistent formats inside a column.Open
Indentation FixerFormattingNormalize indentation across the file.Open
Invalid Row DetectorCleaningFlag rows that violate a schema or per-column constraints.Open
IP Address ValidatorValidationValidate IPv4 and IPv6 addresses.Open
Java Model GeneratorTransformationGenerate Java POJO classes from JSON.Open
JOIN BuilderSQL & DBBuild INNER/LEFT/RIGHT/FULL joins visually with key picker.Open
JOIN VisualizerSQL & DBDiagram inner/outer/left/right joins live.Open
JSON → ChartsVisualizationRender charts directly from JSON data.Open
JSON → CSVTransformationConvert a JSON array of objects into clean CSV.Open
JSON → ExcelTransformationGenerate a downloadable .xlsx workbook from JSON data.Open
JSON → Mongoose SchemaTransformationGenerate a Mongoose schema from a sample JSON document.Open
JSON → SQL SchemaTransformationGenerate SQL DDL from sample JSON.Open
JSON → XMLTransformationConvert JSON to XML.Open
JSON ↔ YAMLTransformationConvert between JSON and YAML in either direction.Open
JSON CompareComparisonSide-by-side diff of two JSON documents with structural alignment.Open
JSON FlattenTransformationFlatten nested JSON to dot-notation keys, or unflatten back.Open
JSON FormatterFormattingPretty-print, minify, and indent JSON safely.Open
JSON Key RenamerCleaningRename keys with rules (snake_case, prefix strip, mapping table).Open
JSON Log ViewerLogsBrowse structured JSON logs by field.Open
JSON MergeTransformationDeep-merge two or more JSON documents with conflict policy.Open
JSON Nested ExtractorTransformationPull a specific nested branch out of a large JSON document.Open
JSON Path TesterTransformationTest JSONPath / jq-style expressions against a JSON document live.Open
JSON Response AnalyzerAPIInspect shape, types, and nesting.Open
JSON Schema GeneratorTransformationInfer a JSON Schema from sample data.Open
JSON Schema ValidatorValidationValidate JSON against a JSON Schema.Open
JSON SearchTransformationSearch keys and values across deeply nested JSON.Open
JSON SplitterTransformationSplit a large JSON array into N chunks or by predicate.Open
JSON ValidatorValidationValidate JSON syntax with helpful error messages.Open
JSON WorkspaceWorkspaceOpen any JSON, browse, search, edit, and export — all in one workspace.Open
Keyword ExtractorExtractionSurface the most relevant keywords.Open
KPI CardsVisualizationShow single-metric KPI cards.Open
KPI Dashboard BuilderVisualizationCompose a small dashboard out of KPI cards + charts on a CSV.Open
Large JSON ViewerBig DataBrowse multi-MB JSON without freezing the tab.Open
Line ChartsVisualizationPlot time series or sequences.Open
Live CSV ParserBig DataStream a huge CSV in chunks and expose pause/resume controls.Open
Live Dashboard PreviewVisualizationEdit data → dashboard updates instantly. Great for QA.Open
Log FormatterLogsPretty-print structured logs.Open
Mean / Median / ModeAnalysisCentral tendency for numeric columns.Open
Memory Usage EstimatorBig DataEstimate browser memory cost of a dataset before loading it.Open
Merge DatasetsETLConcatenate or join two tabular files.Open
Metadata ExtractorSchema & MetadataExtract row count, column types, file size, byte distribution.Open
Minify / Beautify ToggleFormattingSwitch between minified and pretty form.Open
Missing Data HeatmapAnalysisA heatmap that shows where the gaps are in your dataset.Open
Missing Data ReportAnalysisAnalyze missing values by column and row with CSV, heatmap, and markdown outputs.Open
Missing Value CleanerCleaningDetect, drop, fill, or interpolate missing values per column.Open
Mongoose SchemaTransformationGenerate a Mongoose schema from JSON.Open
MySQL → PostgreSQLTransformationTranslate MySQL DDL/DML to PostgreSQL dialect.Open
Natural Language → SQLAI-AssistedGenerate SQL from a plain-English question.Open
NDJSON ViewerBig DataStream and browse newline-delimited JSON.Open
Nested JSON FormatterFormattingFormat and explore deeply nested JSON.Open
Nginx Log AnalyzerLogsSummarize Nginx access logs.Open
Normalize Column NamesCleaningsnake_case, camelCase, or kebab-case headers.Open
Null Value CleanerCleaningReplace, drop, or report null/empty cells.Open
Outlier DetectorCleaningFlag statistical outliers in numeric columns.Open
Phone ExtractorExtractionFind phone numbers in unstructured text.Open
Phone Number FormatterCleaningReformat phone numbers (E.164, national, dashed) in a CSV column.Open
Phone Number ValidatorValidationValidate phone numbers in bulk.Open
Pie ChartsVisualizationBuild a pie chart from any column.Open
PII DetectorSecurityScan tables and text for likely PII.Open
Pivot Table (Power)SpreadsheetsRich pivot tables with row/col/value/agg pickers.Open
Pivot Table BuilderSpreadsheetsBuild pivots without Excel.Open
Prisma SchemaTransformationGenerate a Prisma schema from a sample.Open
Python DataclassTransformationGenerate Python @dataclass code from JSON.Open
Query Dependency GraphSQL & DBShow which tables a CTE / view depends on.Open
Random Product GeneratorSQL & DBCreate fake product records.Open
Random User GeneratorSQL & DBCreate fake user records (name, email, address).Open
Regression PreviewAnalysisQuick linear / polynomial fit + R² for two columns.Open
Remove Duplicate RowsCleaningStrip duplicate rows from CSV or JSON.Open
Remove Empty FieldsCleaningDrop empty cells or null fields.Open
Rename ColumnsETLBulk-rename CSV/JSON columns.Open
Research Dataset VisualizerResearchQuick visualization for research data.Open
Row CountAnalysisCount rows in a dataset.Open
Sankey DiagramVisualizationVisualize flow between source/target columns.Open
Scatter PlotsVisualizationVisualize relationships between two columns.Open
Schema MapperSchema & MetadataMap source fields to a target schema with confidence scores.Open
Sensitive Data ScannerSecurityFlag credit cards, SSNs, tokens, keys.Open
Smart Schema DetectionAI-AssistedDetect schema and types from any sample.Open
Smart Schema MappingAI-AssistedAuto-map source columns to a target schema with confidence scores.Open
Smart Type DetectionCleaningPer-column type inference: int, float, date, bool, enum, ID.Open
Sort DataETLSort by one or more columns.Open
SPSS CSV FormatterResearchReshape CSV for SPSS-friendly import.Open
SQL → JSONTransformationRun a query result mock and emit JSON.Open
SQL → PrismaTransformationGenerate a Prisma schema from CREATE TABLE statements.Open
SQL BeautifierFormattingReformat SQL queries with proper line breaks.Open
SQL Explain VisualizerSQL & DBPretty-render an EXPLAIN plan as a tree.Open
SQL FormatterSQL & DBToken-based SQL formatter (dialect-aware).Open
SQL Optimizer SuggestionsSQL & DBStatic heuristics: missing indexes, SELECT *, cartesian joins.Open
SQL Query AnalyzerSQL & DBInspect a query: tables, joins, projections, filters.Open
SQL Query BuilderSQL & DBBuild SELECT/JOIN queries with a form.Open
SQL Query FormatterSQL & DBFormat ugly SQL into readable layouts.Open
SQL Result CompareComparisonCompare two query result sets.Open
SQL Result ExporterSQL & DBExport a result set to CSV/JSON/Excel.Open
SQL Result VisualizerVisualizationVisualize a SQL query result instantly.Open
SQL Schema VisualizerSQL & DBBrowse tables/columns of a SQL schema interactively.Open
SQL Seed GeneratorSQL & DBGenerate INSERT seed scripts.Open
SQL Syntax ValidatorValidationLint SQL syntax across dialects.Open
SQL Table → JSONTransformationTurn a CREATE TABLE schema into JSON.Open
Standard DeviationAnalysisCompute σ and variance per column.Open
Standardize Phone NumbersCleaningConvert phone numbers to a single format.Open
Structured Data ExtractorExtractionPull tables, JSON-LD, and OpenGraph blocks out of HTML.Open
Survey Data CleanerResearchClean exports from common survey tools.Open
Table Relationship VisualizerSQL & DBVisualize FK relationships across a schema.Open
Thesis Data AnalyzerResearchSummary, charts, and tests for thesis data.Open
Time Series VisualizerVisualizationPlot one or more numeric columns over a date column.Open
Timestamp Log VisualizerLogsPlot log volume over time with a brushable timeline.Open
Tree View FormatterFormattingBrowse JSON/XML as a collapsible tree.Open
TreeMap GeneratorVisualizationBuild a treemap from a hierarchical categorical column.Open
Trend DetectionAnalysisSurface monotonic trends, level-shifts, and seasonality in time series.Open
Trim WhitespaceCleaningTrim leading/trailing whitespace in every field.Open
TSV → CSVTransformationSwitch tab-separated to comma-separated.Open
TypeScript InterfaceTransformationGenerate TS interfaces from JSON.Open
Unique Value CountAnalysisCount distinct values per column.Open
Universal Data LabWorkspaceDrop in any CSV/JSON/Excel/XML — auto-detect, profile, clean, visualize, export.Open
URL ExtractorExtractionExtract all URLs from text or HTML.Open
URL ValidatorValidationBulk URL syntax checker.Open
Visual SQL BuilderSQL & DBBuild SELECT/JOIN/WHERE/GROUP queries with a form.Open
XML → JSONTransformationConvert XML documents to JSON.Open
XML BeautifierFormattingPretty-print XML with proper indentation.Open
XML ValidatorValidationCheck XML well-formedness.Open
YAML BeautifierFormattingTidy YAML structure and indentation.Open
YAML ValidatorValidationCatch YAML syntax errors.Open
Z-Score CalculatorAnalysisPer-row z-scores for any numeric column with outlier highlights.Open

Find the right data tool in seconds.

Recommended workflows

Popular tools

All matching tools

Find the right data tool in seconds.

Recommended workflows

Popular tools

All matching tools