How to Analyse and Process Data
Validate, transform, query, and compare data with free JSON, CSV, and diff tools — no installation required.
Overview
Data analysis and processing tasks come up constantly in development, data work, and operations. Multi-Toolkit provides free in-browser tools for the most common data workflows.
**Validate and Explore JSON**: The JSON Validator catches errors with line numbers. The JSON Tree Viewer lets you navigate complex nested structures. The JSONPath Tester lets you query specific fields from large JSON documents.
**Transform and Convert**: JSON to CSV for spreadsheet analysis. JSON to YAML for configuration files. JSON Schema Generator to document your data structure.
**Compare Data**: The JSON Diff tool shows exactly which fields were added, removed, or changed between two JSON objects — useful for debugging API version changes or comparing configuration files.
**Count and Measure**: The Word Counter analyses text frequency. The JSON node counter tells you the total number of nodes, objects, arrays, strings, and numbers in a document.
Step-by-Step Guides
- 1Open the JSONPath Tester and paste your JSON data.
- 2Enter a JSONPath expression (e.g., "$.users[*].email" to get all email addresses).
- 3Results update instantly as you type.
- 4Use filters (e.g., "$..products[?(@.price < 50)]") to query by value.
- 1Open the JSON Diff tool.
- 2Paste the original JSON in the left panel and the updated JSON in the right.
- 3View added fields (green), removed fields (red), and changed values (yellow).
- 4Use the diff to identify unexpected changes in API responses.
- 1Open the JSON Tree Viewer and paste or upload your JSON.
- 2Expand and collapse nodes to explore the structure.
- 3Check the stats panel for total node count, depth, and type distribution.
- 4Use the JSONPath Tester to extract specific data subsets.
Recommended Tools
Frequently Asked Questions
What JSONPath syntax is supported?
Standard JSONPath: $ (root), . (child), [] (subscript), * (wildcard), .. (recursive), and filter expressions ?(@.field op value).
Can I convert JSON to a spreadsheet format?
Yes. JSON to CSV converts arrays of objects to CSV files compatible with Excel and Google Sheets.
How do I view deeply nested JSON?
Use the JSON Tree Viewer. It renders JSON as an interactive collapsible tree, letting you navigate to any depth.
What does the JSON diff show?
Added fields (in target but not source), removed fields (in source but not target), and modified values (key exists in both but values differ).