Home / All tools / Data

Data

CSV, Excel, JSON, SQLite, Parquet, maps and GPS. 11 free tools that run 100% in your browser.

  • Mock Data Generator: Generate realistic fake names, emails, addresses, products and dates as JSON, CSV, SQL inserts, NDJSON or TSV.
  • Data Format Converter: Convert between JSON, YAML, XML, TOML, INI, CSV, NDJSON, MessagePack, CBOR and BSON.
  • CSV & Spreadsheet Editor: Edit CSV and Excel files in a fast grid: sort, filter, dedupe, find and replace, split and merge.
  • SQLite Browser: Open .db and .sqlite files, browse tables, run SQL and export results to CSV or JSON.
  • Parquet / Arrow / Avro Viewer: View, filter and convert Parquet, Arrow, Feather and Avro files to CSV, JSON or Excel.
  • GPS / GIS Converter: Convert GPX, KML, KMZ, GeoJSON, Shapefile, TCX and CSV with a map preview and track stats.
  • JSON Diff: Compare two JSON documents by structure and get a list of changes or a JSON Patch.
  • JSONPath / JSONata Tester: Query and reshape JSON with JSONPath, JSONata or a JavaScript expression, with live results.
  • JSON Schema Validator: Validate JSON against a schema (Draft-07 or 2020-12) and generate a schema from sample data.
  • XML Formatter, XPath & Validator: Format or minify XML, check it is well-formed and test XPath expressions.
  • SQL Table Generator: Create CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server from a CSV or JSON file.

OpenFile runs in your browser. Turn on JavaScript to use the tools.