Start with the data format
Choose a group that matches the data in front of you. The available groups cover JSON, JSON Lines, CSV, TSV, Excel, XML, YAML, TOML, tabular data, SQL schemas, Parquet files, cookies, user agents, logfmt lines, and HTML tables. Then select the task, such as cleaning, validation, comparison, conversion, merging, querying, or reshaping.
The group name points to the kind of input it handles. A JSON document belongs with JSON Tools, while a table that needs reshaping belongs with Dataset Tools.
JSON tools for structured data
JSON Tools covers JSON and JSON Lines. Use this group to clean, validate, compare, merge, flatten, or query the document structure.
Choose JSON Tools when the input is JSON or JSON Lines and the document structure is the part you need to inspect or change.
CSV and spreadsheet tools
Spreadsheet Tools covers CSV, TSV, and Excel files. Use it for cleaning, validation, comparison, and conversion.
Dataset Tools focuses on tabular data. Its tasks include profiling, cleaning, reshaping, merging, and generating tabular data. Choose it when the table is the thing you need to work on, regardless of its source format.
XML, config, database, and parser tools
- XML Tools handles XML cleaning, validation, comparison, merging, XPath queries, and conversion to JSON.
- Config File Tools covers YAML and TOML validation, comparison, merging, and conversion. It also extracts environment variables.
- Database Tools runs SQL on CSV and JSON, compares SQL schemas, and compares or converts Parquet files.
- Parser Tools parses cookies, user agents, logfmt lines, and HTML tables into structured data.
Match the task to the group
For a JSON Lines file, start with JSON Tools when you need to clean, validate, compare, merge, flatten, or query the records. Move to Dataset Tools when the records need tabular profiling, reshaping, merging, or another dataset task.
For CSV, TSV, or Excel, use Spreadsheet Tools for file cleaning, validation, comparison, or conversion. Use Dataset Tools when the work concerns the tabular data itself.
Use Config File Tools for YAML or TOML. Use Database Tools for SQL on CSV or JSON, SQL schema comparison, or Parquet comparison and conversion. Parser Tools is the match for copied cookies, user agents, logfmt lines, or HTML tables.
Where to start when the format is unclear
Start with Dataset Tools when you have a table and the source format does not determine the task. Choose Parser Tools for copied cookie text, user-agent strings, logfmt lines, or HTML tables. If the file is clearly JSON, CSV, XML, YAML, TOML, or Parquet, choose the matching group first, then open the section for cleaning, validation, comparison, conversion, merging, querying, profiling, extraction, or transformation.
Frequently asked questions
Which data tools should I use for a CSV file?
Use Spreadsheet Tools for CSV cleaning, validation, comparison, or conversion. Choose Dataset Tools when you need to profile, clean, reshape, merge, or generate tabular data.
Where are the JSON and JSON Lines tools?
JSON Tools is the group for cleaning, validating, comparing, merging, flattening, and querying JSON and JSON Lines.
Which tool converts XML to JSON?
XML Tools handles XML-to-JSON conversion. It also contains XML cleanup, validation, comparison, merging, and XPath query tools.
Where can I compare YAML and TOML files?
Config File Tools is the group for comparing YAML and TOML files. It also covers validation, merging, conversion, and environment-variable extraction.