Data Tools

Free in-browser data tools for working with CSV and JSON — sort rows, extract or reorder columns, deduplicate, convert between CSV, TSV and JSON, query by path, and compute quick column statistics, all processed locally.

Convert table formats

⇄

TSV ⇄ CSV

Convert between tab-separated and comma-separated values.

🔗

JSON to CSV (Flatten Nested)

Convert a JSON array of objects to CSV, flattening nested keys to dot-notation columns.

}⏎

JSON ⇄ JSON Lines

Convert between a JSON array and NDJSON / JSON Lines.

⊞c

HTML / Markdown Table to CSV / JSON

Paste an HTML <table> or a Markdown table and extract it to CSV or JSON.

▮c

Fixed-Width to CSV

Convert fixed-width, mainframe or COBOL column-position text into CSV by defined field widths.

📗

CSV to Excel (XLSX) Converter

Convert CSV to a real .xlsx workbook, or export an Excel sheet back to CSV — all in your browser.

Clean and reshape tables

⇅c

CSV Sorter

Sort CSV rows by a chosen column, with automatic numeric ordering.

|c|

CSV Column Extractor

Keep and reorder CSV columns by index or header name.

≣r

Duplicate Row Remover

Remove duplicate lines while preserving the original order.

⤢c

CSV Transpose

Swap the rows and columns of a CSV grid — pivot it so the first column becomes the header row.

⇆c

Split / Combine Columns

Split one CSV column into many by a delimiter, or combine several columns into one with a joiner.

🔀

CSV Merge / Join

Append two CSVs or database-style join them on a shared key column.

▓c

CSV Data Anonymizer / Masker

Detect and mask, hash, fake or drop PII columns to produce a demo-safe CSV — all in your browser.

Explore, query and compare data

🔎

CSV Viewer & Explorer

Open a CSV in a sortable, filterable, paginated table right in your browser.

⛁

Query CSV with SQL

Load a CSV and run real SQL (SELECT, WHERE, GROUP BY, JOIN) over it — 100% in your browser.

Σc

CSV Column Statistics

Compute count, sum, mean, median, min and max for a CSV column.

▦

Pivot Table Generator

Summarize a CSV by row and column fields with sum, count, average, min or max.

📊

CSV Chart / Graph Maker

Turn CSV data into bar, line, area, pie or scatter charts and export SVG or PNG.

$.x

JSON Path Extractor

Extract values from JSON using a simple dot path with wildcards.

Δc

CSV Diff / Compare

Compare two CSVs and see added, removed and changed rows with cell-level highlighting.

Generate test data and SQL

⚄c

Random CSV Generator

Generate sample CSV test data with chosen column types.

🎲

Mock / Test Data Generator

Build a schema of typed fields and generate realistic mock data as CSV, JSON or SQL.

🗄

CSV to SQL INSERT Generator

Generate CREATE TABLE and escaped INSERT statements from CSV with type inference.

No tools match that.