Data Format Tools

A list of our Data Format tools. Nothing you enter is sent to a server; it is all processed in your browser.

• JSON Formatter

  Formats and minifies JSON data, with clear syntax error messages.

• YAML to JSON Converter

  Converts between YAML and JSON, handy for checking Docker Compose or GitHub Actions config files.

• CSV to JSON Converter

  Converts between CSV and JSON using the header row as keys, with support for comma/tab delimiters and quoted fields.

• CSV/JSON to SQL INSERT Generator

  Generates INSERT statements (optionally with CREATE TABLE) from CSV or JSON, with MySQL/PostgreSQL/SQLite quoting and type inference.

• CSV Viewer (Sort & Filter)

  View CSV as a table, sort by column, filter rows, reorder or remove columns and export again. Virtual scrolling keeps big files fast.

• TOML to JSON/YAML Converter

  Converts between TOML, JSON, and YAML, handy for checking a TOML config file like Cargo.toml or pyproject.toml.

• Markdown to HTML Converter

  Converts Markdown to HTML with a live preview, and HTML back to Markdown. Handy for checking a README or article draft.

• SQL Formatter

  Formats and minifies SQL queries, with support for MySQL, PostgreSQL, SQLite, BigQuery and other dialects, indent width, and keyword case.

• CSS/JS/HTML Minifier

  Formats and minifies CSS, JavaScript, and HTML code, with a selectable indent width.

• JSON to Types Converter

  Generates type definitions from JSON as TypeScript interfaces, C# classes, Go structs, Python dataclasses, or Java records, handling nested objects, arrays, optional and nullable fields.

• JSON Diff

  Compares two JSON documents structurally and lists added, removed, and changed values with their paths. Ignores key order, with an option to ignore array order.

• XML to JSON Converter

  Converts between XML and JSON, handling attributes and text, and reports syntax errors such as unclosed tags with line and column.

• .env to JSON Converter

  Converts between .env files and JSON, handling comments, export prefixes, and quoted values.

• CSV to Excel (XLSX) Converter

  Converts CSV to an Excel .xlsx file and exports xlsx sheets to CSV, with Shift_JIS detection, sheet selection and UTF-8 BOM output.

• CSV/TSV to Markdown Table Converter

  Converts CSV or TSV (including tables copied from Excel) into a Markdown table, with column alignment, padding, and optional header row.

• HTML Table to CSV Converter

  Converts an HTML <table> to CSV or TSV, expanding merged cells, choosing among multiple tables, and adding a BOM for Excel.

• JSON Tree Viewer

  Browse JSON as a collapsible tree, search keys and values, and copy the path (JSONPath or JSON Pointer) of any node.

• JSON Schema Generator

  Generates a JSON Schema from a JSON sample, with draft 2020-12, 2019-09, or 07, required keys, additionalProperties, and format detection.

• JSONL (NDJSON) to JSON / CSV Converter

  Convert JSONL (NDJSON, JSON Lines) to and from a JSON array or CSV, skipping blank lines and reporting the line number of bad records

• JSON5 ⇔ JSON Converter

  Convert JSON5 or JS object literals to JSON and back. Handles comments, trailing commas, unquoted keys and hex numbers, with line and column errors.

• Markdown Table Editor

  Edit a Markdown table in a grid: add, delete and reorder rows and columns, set alignment, copy padded output

• JSON Key Sorter & Flatten

  Sort JSON keys recursively, flatten nested JSON to a.b[0] paths, and unflatten it back.

• XML Formatter & Validator

  Format, minify and validate XML with line and column error positions

• YAML Formatter & Validator

  Format and validate YAML with line and column error positions. Sort keys and handle multiple documents.

• CSV Split, Merge and Remove Duplicates

  Split CSV by rows or file count (ZIP), merge CSVs with header checks, and remove duplicate rows by key column. Runs in your browser.

• Excel Column Letter ⇔ Number Converter

  Convert Excel column letters and numbers (A=1, AZ=52, XFD=16384), split A1 references like $B$3, and count columns in a range.

• Query String ⇔ JSON Converter

  Convert URL query strings to JSON and back, with nested keys and b[] / b[0] / repeated-key array styles.