Skip to tool

Support

Categories

File formats / 11 formats, every pair

SQL to JSON converter

Turn SQL into JSON — an array of objects, one per row — in this browser tab. Paste your SQL, copy the JSON: the quoting and escaping JSON needs are applied for you.

On-device prototype

SQL to JSON, worked out

3 rows and 4 columns: 11 lines of SQL become 20 lines of JSON.

SQL in

CREATE TABLE "imported_table" (
  "product" VARCHAR(255),
  "region" VARCHAR(255),
  "units" INTEGER,
  "unit price" DECIMAL(10, 2)
);

INSERT INTO "imported_table" ("product", "region", "units", "unit price") VALUES
  ('Desk lamp', 'EU', 128, 24.50),
  ('Chair', 'R&D', 64, 98.00),
  ('Monitor', 'APAC', 32, 249.99);

JSON out

[
  {
    "product": "Desk lamp",
    "region": "EU",
    "units": "128",
    "unit price": "24.50"
  },
  {
    "product": "Chair",
    "region": "R&D",
    "units": "64",
    "unit price": "98.00"
  },
  {
    "product": "Monitor",
    "region": "APAC",
    "units": "32",
    "unit price": "249.99"
  }
]

JSON result

[
  {
    "product": "Desk lamp",
    "region": "EU",
    "units": "128",
    "unit price": "24.50"
  },
  {
    "product": "Chair",
    "region": "R&D",
    "units": "64",
    "unit price": "98.00"
  },
  {
    "product": "Monitor",
    "region": "APAC",
    "units": "32",
    "unit price": "249.99"
  }
]

Conversions next to this one

Next in this job

Chosen from where these tools sit in the catalogue — the same workbench, the same category, the same words. Nothing here measures what you or anyone else opened.