QiLing Tools🗃️Data Format Tools
JSON formatting and diffing, CSV / YAML / XML / TOML conversion, JSON to TypeScript or SQL, schemas, binary decoding and tables.
28 tools tagged "Data Formats"
{}JSON FormatterFree 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 GeneratorFree 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 JSONFree online CSV ⇄ JSON converter: handles quotes, commas and newlines inside fields, auto-detects the delimiter, with a header toggle and type conversion.🔷JSON to TypeScriptFree online JSON to TypeScript converter: interfaces or types from JSON, nested objects split into named interfaces, optional fields inferred, Go structs too.📋Markdown Table GeneratorFree online Markdown table generator: edit cells visually, add rows and columns, set per-column alignment, and import from Excel, CSV, TSV or Markdown.🗃️SQL FormatterFree 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 ViewerFree 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 DiffFree 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 FormatterFree 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 ConverterFree online YAML and JSON converter: multi-document YAML, anchors, aliases and merge keys, errors with line and column, plus indent, sorting and folding.🗺️JSONPath TesterFree online JSONPath tester: query JSON with $.store.book[*], recursive .., slices and filters, listing every matching path and value, plus a cheat sheet.🔎PDF Info & InspectorFree online PDF inspector: version, page count and sizes, metadata, encryption, permissions, fonts, images, form fields and attachments, as a JSON report.🧪Mock Data GeneratorFree 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)Free MediaInfo-style video inspector: container, duration, bitrate, per-stream codec, resolution, frame rate, HDR hints, audio layout, subtitles and chapters.📗PDF to ExcelFree 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 & ValidatorGenerate 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 SpreadsheetFree 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 MeterFree 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 ConverterConvert 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 ConverterConvert 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 ViewerView 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 GeneratorTurn 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 DecoderDecode raw Protobuf without a schema or with a pasted .proto, plus MessagePack, CBOR and BSON. Tree + JSON views with byte-offset highlighting.🔦Hex ViewerView 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 MergeFill 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 CSVRun 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 VisualizerTurn 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 CheckFree checker for Chinese mobile numbers: validate the format, identify the carrier by prefix, flag MVNO, IoT and satellite ranges, and export them as CSV.