Guides
JSON guides and tutorials
Step-by-step walkthroughs for the jobs developers and analysts actually do with JSON: turn API responses into spreadsheets, flatten nested data, find errors, and move between formats. Quick answers are on the FAQ page.
- How to Convert Postman JSON to CSVCopy a response from Postman, turn it into a table and download it as CSV in under a minute, including what to do with nested objects and arrays.
- JSON to Excel: A Step-by-Step GuideConvert any JSON file or API response into a real .xlsx workbook with a styled header, filters and typed numbers, without writing code.
- How to Flatten Nested JSONWhat flattening means, how dotted column names work, and how to flatten nested JSON by hand, in code, or with a free browser tool.
- How to Handle Arrays in JSON When Converting to a TableThree ways to turn nested JSON arrays into spreadsheet rows and columns, with a worked order example and advice on choosing between them.
- JSON vs CSV: When to Use WhichA practical comparison of JSON and CSV covering structure, size, types, tooling and a simple rule for choosing the right format.
- Common JSON Errors and How to Fix ThemThe ten JSON syntax errors developers hit most often, what the error messages mean, and exactly how to fix each one.
- How to View Large JSON FilesWhy large JSON files freeze editors and browsers, and practical ways to open, search and explore files from megabytes to gigabytes.
- Postman Tips: Exporting Responses and CollectionsPractical ways to get data out of Postman: copy or save responses, export collections, use test scripts to save data, and turn the results into tables.
- How to Compare Two JSON FilesWhy a plain text diff fails on JSON, and how to compare API responses structurally to see exactly which values were added, removed or changed.
- JSONPath Cheat Sheet and ExamplesA practical JSONPath reference: root, wildcards, recursive descent, slices and filters, with worked examples you can test against your own JSON.
- How to Generate TypeScript Interfaces from JSONTurn an API response into TypeScript interfaces or a JSON Schema, and learn how optional fields, unions and nulls should be modelled.
- How to Generate SQL INSERT Statements from JSONCreate CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite, SQL Server or Oracle from a JSON array, and avoid the common type pitfalls.
- Convert cURL to fetch, Axios and PythonHow to translate a cURL command from API docs or browser dev tools into fetch, Axios, Python requests, Node or PHP, with the flags that matter.
- How to Decode and Inspect a JWT SafelyWhat the three parts of a JSON Web Token contain, how to read claims and expiry, why decoding is not verifying, and how to check a signature.
- How to Open and Explore Large CSV FilesWhy big CSV files crash Excel or show garbled text, and how to open, search, sort and clean them, then convert to JSON or Excel.
- How to Format, Validate and Minify JSONBeautify unreadable JSON, validate it against the spec, minify it for production and sort keys for clean diffs, with the reasons for each.