The blog
Everything about working with JSON.
Clear, practical articles on JSON structure, merging strategies, and the day-to-day workflows that make data wrangling painless.
How to Compare JSON Files: JSON Diff, Key Order & Nested Changes
Learn how to compare JSON files the right way - use a JSON diff that ignores whitespace and key order, highlights nested changes, and keeps private data in your browser.
Read article →How to Convert CSV to JSON: Output Shapes, Types & Delimiters Explained
Convert CSV to JSON the right way — choose the output shape, infer types correctly, handle quoted fields and odd delimiters, and do it online, in Python, or with Node.
Read →How to Convert Excel to JSON: Sheets, Dates & Output Shapes Explained
Convert Excel (.xlsx) to JSON the right way — handle multiple sheets, get real dates instead of serial numbers, and pick the output shape. Online, in Python, and in Node.
Read →How to Convert JSON to a Table: View, Sort & Export (CSV, Excel, Markdown)
Turn JSON into a readable table you can sort, filter, and export to CSV, Excel, HTML, or Markdown — online, in Python, and in JavaScript. Handle nested data the right way.
Read →How to Convert JSON to Base64
Learn how to convert JSON to Base64, decode Base64 back to JSON, use URL-safe Base64, create JSON data URIs, wrap Base64 lines, and minify before encoding.
Read →How to Convert JSON to CSV: A Practical Guide (Nested Data, Delimiters & Excel)
Learn how to convert JSON to CSV the right way — flatten nested objects, handle arrays, pick a delimiter, and open the result in Excel. Online, in Python, and with jq.
Read →How to Convert JSON to Excel: Real XLSX, Multiple Sheets & Nested Data
Convert JSON to Excel the right way — produce a real .xlsx with typed cells, split arrays into multiple sheets, and handle nested objects. Online, in Python, and in Node.
Read →How to Convert JSON to HTML Table: Plain, Styled, Bootstrap & Tailwind
Convert JSON to HTML table the right way - create plain or styled HTML tables, handle nested JSON with sub-tables, and use Bootstrap or Tailwind classes.
Read →How to Convert JSON to JSONL or NDJSON
Convert JSON to JSONL the right way - turn a JSON array into newline-delimited JSON, strip pretty-print formatting, validate records, and download .jsonl.
Read →How to Convert JSON to Markdown Table: GitHub Tables, Pipes & Alignment
Convert JSON to Markdown table the right way - generate GitHub-flavored Markdown, escape pipes, align columns, and handle nested JSON safely.
Read →How to Convert JSON to SQL: CREATE TABLE + INSERTs Across Dialects
Convert JSON to SQL the right way — generate CREATE TABLE with inferred types and batched INSERTs for MySQL, PostgreSQL, SQLite, or SQL Server. Online and in Python.
Read →How to Convert JSON to TypeScript Interfaces
Convert JSON to TypeScript the right way - generate interfaces or type aliases, detect optional fields, handle arrays and nulls, and name nested types cleanly.
Read →How to Convert JSON to XML: Attributes, Arrays & Clean Markup
Convert JSON to XML the right way — map keys to attributes vs elements, name the root and array items, and keep it private. Online, in Python, and in JavaScript.
Read →How to Convert JSON to YAML: Clean Output for Kubernetes & CI
Convert JSON to YAML the right way — pick indentation and quote style, handle multiline strings, and produce idiomatic config. Online, in Python, and on the command line.
Read →How to Convert XML to JSON: Attributes, Arrays & Namespaces
Convert XML to JSON the right way — handle attributes, turn repeated tags into arrays, deal with namespaces, and infer types. Online, in Python, and in JavaScript.
Read →How to Convert YAML to JSON: Multi-Doc, Anchors & Types
Convert YAML to JSON the right way — handle multi-document streams, anchors and aliases, comments, and type inference. Online, in Python, and on the command line.
Read →How to Escape a JSON String: Quotes, Newlines & Unicode
Learn how to JSON escape a string for safe embedding - handle quotes, backslashes, newlines, tabs, control characters, and optional Unicode escaping.
Read →How to Flatten JSON: Dot Notation, Arrays & Unflattening
Learn how to flatten JSON the right way - choose dot, bracket, slash, or underscore delimiters, handle array indexes, and unflatten flat JSON back to nested data.
Read →How to Generate JSON Schema from JSON
Use a JSON Schema generator to create a schema from sample JSON - choose the draft, infer types, mark required fields, and add examples or an $id.
Read →How to Generate Mock JSON Data
Learn how to generate mock JSON data from a template, use realistic fields like name/email/date, create nested arrays, choose record count, and export JSON with no signup.
Read →How to Repair JSON: Fix Broken, Invalid & AI-Generated JSON
Learn how to repair JSON online - fix trailing commas, single quotes, unquoted keys, comments, Python True/None, smart quotes, and broken AI JSON.
Read →How to Sort JSON Keys Alphabetically
Learn how to sort JSON keys A to Z or Z to A, recursively sort nested JSON objects, preserve or sort arrays, and create stable JSON for diffs and config files.
Read →How to Stringify JSON Online
Learn how to stringify JSON online, escape JSON for embedding in code or database fields, choose quote styles, and unstringify escaped JSON strings back to JSON.
Read →How to Unescape a JSON String: Decode Quotes, Newlines & Unicode
Learn how to JSON unescape a string online - decode escaped quotes, \n, \t, \uXXXX, and double-escaped JSON safely in the browser.
Read →How to Unflatten JSON: Rebuild Nested Data from Flat Keys
Learn how to unflatten JSON from dot notation, bracket notation, slash paths, or underscore keys, rebuild arrays, and convert flat JSON back to nested JSON.
Read →The Best JSON Viewer in 2026: Online, Chrome Extension, or Desktop?
Compare the best ways to view JSON — online JSON viewers, Chrome extensions like JSON Viewer Pro, the Notepad++ plugin, and desktop apps. Find the right tool for your workflow.
Read →How to View JSON Files: 5 Easy Ways (Online, Chrome & Notepad++)
Learn how to open and view JSON files the easy way — with an online JSON viewer, a Chrome extension, Notepad++, VS Code, or the command line. Read large JSON without the headache.
Read →What Is JSONL (NDJSON)? The Format for Streaming JSON Data
JSON Lines and NDJSON store one JSON object per line. Learn what they are, why they beat a giant JSON array for big data, and how to convert and merge them.
Read →Minify vs. Pretty-Print JSON: When to Use Each
Should your JSON be minified or pretty-printed? Learn the difference, the performance and readability trade-offs, and how to convert between the two.
Read →How to Merge JSON Objects in JavaScript (Spread, Assign & Deep Merge)
Merge JSON objects in JavaScript the right way. Compare the spread operator, Object.assign, and a proper recursive deep merge — with code and gotchas.
Read →10 Common JSON Errors and How to Fix Them
Trailing commas, single quotes, unquoted keys, and more — the ten JSON mistakes that break parsers most often, with the fix for each.
Read →JSON vs. XML vs. YAML: Which Data Format Should You Use?
JSON, XML, and YAML all represent structured data, but they shine in different places. Compare their syntax, readability, and ideal use cases.
Read →How to Validate JSON (and Fix the Errors Fast)
Learn how to validate JSON, read parser error messages, and fix the most common syntax mistakes — trailing commas, missing quotes, and more.
Read →Merging JSON Arrays: Concat, Union, Replace & Merge-by-Key
Arrays are the hardest part of merging JSON. Learn the four main strategies — concatenate, union, replace, and merge-by-key — and when to use each.
Read →Deep Merge vs. Shallow Merge: What's the Difference?
Shallow and deep merges produce very different results for nested JSON. Learn exactly how each works, when to use which, and how to avoid silent data loss.
Read →How to Merge JSON Files: 4 Methods (Online, Node, Python, jq)
Need to combine multiple JSON files into one? Here are four reliable ways to merge JSON — using a browser tool, JavaScript, Python, and the jq command line.
Read →What Is JSON? A Beginner's Guide to JavaScript Object Notation
JSON is the universal language of data exchange on the web. Learn what JSON is, how its syntax works, where it is used, and the rules that keep it valid.
Read →