# Data Format Tools > JSON formatting and diffing, CSV / YAML / XML / TOML conversion, JSON to TypeScript or SQL, schemas, binary decoding and tables. - URL: https://qilingtools.com/en/tags/data - Price: Free, no sign-up - Privacy: Runs locally in the browser; files are never uploaded ## Tools (28) - [JSON Formatter](https://qilingtools.com/en/json): Free online JSON formatter: beautify or minify, validate with the exact line and column of any error, browse a collapsible tree, sort keys and escape strings. - [UUID Generator](https://qilingtools.com/en/uuid): Free online UUID generator: create RFC 4122 UUID v4 in bulk with a cryptographic RNG. Options for uppercase, no hyphens and braces, with one-click copy. - [CSV to JSON](https://qilingtools.com/en/csv-json): Free online CSV ⇄ JSON converter: handles quotes, commas and newlines inside fields, auto-detects the delimiter, with a header toggle and type conversion. - [JSON to TypeScript](https://qilingtools.com/en/json-to-ts): Free online JSON to TypeScript converter: interfaces or types from JSON, nested objects split into named interfaces, optional fields inferred, Go structs too. - [Markdown Table Generator](https://qilingtools.com/en/markdown-table): Free online Markdown table generator: edit cells visually, add rows and columns, set per-column alignment, and import from Excel, CSV, TSV or Markdown. - [SQL Formatter](https://qilingtools.com/en/sql-format): Free online SQL formatter: beautify SELECT, JOIN, subqueries, CASE and WITH with clause line breaks and indentation, set keyword case, or minify to one line. - [Image Info Viewer](https://qilingtools.com/en/image/info): Free online image info and EXIF viewer: dimensions, file size, format, bit depth, DPI and ICC profile, plus camera, lens, exposure, date, GPS and a histogram. - [JSON Diff](https://qilingtools.com/en/json-diff): Free online JSON diff: compare two documents ignoring key order, see added, removed and changed paths with old and new values, and export an RFC 6902 patch. - [XML Formatter](https://qilingtools.com/en/xml-format): Free online XML formatter: beautify or minify XML, validate it with line and column errors, keep comments and CDATA, and convert XML to JSON and back. - [YAML to JSON Converter](https://qilingtools.com/en/yaml-json): Free online YAML and JSON converter: multi-document YAML, anchors, aliases and merge keys, errors with line and column, plus indent, sorting and folding. - [JSONPath Tester](https://qilingtools.com/en/json-path): Free online JSONPath tester: query JSON with $.store.book[*], recursive .., slices and filters, listing every matching path and value, plus a cheat sheet. - [PDF Info & Inspector](https://qilingtools.com/en/pdf/info): Free online PDF inspector: version, page count and sizes, metadata, encryption, permissions, fonts, images, form fields and attachments, as a JSON report. - [Mock Data Generator](https://qilingtools.com/en/mock-data): Free online mock data generator: define fields and generate up to 10,000 rows of fake names, emails, addresses, dates and IDs, exported as JSON, CSV or SQL. - [Video Info (MediaInfo Online)](https://qilingtools.com/en/video/info): Free MediaInfo-style video inspector: container, duration, bitrate, per-stream codec, resolution, frame rate, HDR hints, audio layout, subtitles and chapters. - [PDF to Excel](https://qilingtools.com/en/pdf/to-excel): Free PDF to Excel converter: detects ruled and borderless tables, lets you adjust columns, turns numbers into real values and exports XLSX or CSV. Runs locally. - [JSON Schema Generator & Validator](https://qilingtools.com/en/json-schema): Generate a draft 2020-12 or draft-07 JSON Schema from sample JSON (types, required, nesting, formats) and validate JSON with JSON Pointer error paths. Free. - [Online Spreadsheet](https://qilingtools.com/en/sheet): Free online spreadsheet and CSV editor: SUM, AVERAGE and IF formulas with auto-recalc, sort, filter, find & replace, Excel copy-paste, CSV/TSV/JSON export. - [Loudness Meter](https://qilingtools.com/en/audio/loudness): Free loudness meter: integrated LUFS, short-term/momentary max, LRA, true peak, RMS, DC offset and clipping, checked against Spotify, YouTube and EBU R128. - [Config File Converter](https://qilingtools.com/en/config-convert): Convert config files between JSON, YAML, TOML, INI, .env and Java .properties. Auto-detects the format, full TOML 1.0 support, errors with line numbers. - [JSON to SQL Converter](https://qilingtools.com/en/json-to-sql): Convert JSON arrays or CSV to SQL: inferred types and primary key, CREATE TABLE, batched INSERT and UPSERT for MySQL, PostgreSQL, SQLite, SQL Server, Oracle. - [OpenAPI Viewer](https://qilingtools.com/en/openapi-viewer): View OpenAPI 3.x and Swagger 2.0 (JSON/YAML) online: tag-grouped endpoints, search, $ref schema trees, example JSON, curl/fetch snippets and HTML export. - [ASCII Table Generator](https://qilingtools.com/en/text-table): Turn CSV, spreadsheet cells or Markdown into text tables: ASCII, Unicode boxes, Markdown, reST, Org-mode, MySQL style, HTML or LaTeX, CJK-aligned. - [Protobuf, MessagePack, CBOR & BSON Decoder](https://qilingtools.com/en/binary-decoder): Decode raw Protobuf without a schema or with a pasted .proto, plus MessagePack, CBOR and BSON. Tree + JSON views with byte-offset highlighting. - [Hex Viewer](https://qilingtools.com/en/hex-viewer): View any file as hex + ASCII: go to offsets, search bytes or text, decode values, detect 60+ file types, parse PNG/ZIP/PDF/ELF/PE headers and diff files. - [PDF Form Mail Merge](https://qilingtools.com/en/pdf/form-merge): Fill a PDF form from CSV rows: auto-matched fields, checkboxes, radios, dropdowns, CJK text, optional flattening, one PDF per row or combined; export form data. - [SQL on CSV](https://qilingtools.com/en/csv-sql): Run SQL on CSV, TSV and JSON files in your browser: type inference, WHERE, GROUP BY, aggregates, JOINs, CASE, subqueries and functions; export CSV or JSON. - [JSON Graph Visualizer](https://qilingtools.com/en/json-graph): Turn JSON, YAML or CSV into a node graph: objects and arrays as cards linked by edges, with zoom, pan, collapse, search, JSONPath and PNG/SVG export. - [China Phone Number Check](https://qilingtools.com/en/phone-check): Free checker for Chinese mobile numbers: validate the format, identify the carrier by prefix, flag MVNO, IoT and satellite ranges, and export them as CSV.