Skip to tool

Support

Categories

File formats / 11 formats, every pair

SQL to XML converter

Turn SQL into XML — a row element per record, a child element per column — in this browser tab. Paste your SQL, copy the XML: the quoting and escaping XML needs are applied for you.

On-device prototype

SQL to XML, worked out

3 rows and 4 columns: 11 lines of SQL become 21 lines of XML.

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);

XML out

<?xml version="1.0" encoding="UTF-8"?>
<rows>
  <row>
    <product>Desk lamp</product>
    <region>EU</region>
    <units>128</units>
    <field name="unit price">24.50</field>
  </row>
  <row>
    <product>Chair</product>
    <region>R&amp;D</region>
    <units>64</units>
    <field name="unit price">98.00</field>
  </row>
  <row>
    <product>Monitor</product>
    <region>APAC</region>
    <units>32</units>
    <field name="unit price">249.99</field>
  </row>
</rows>

XML result

<?xml version="1.0" encoding="UTF-8"?>
<rows>
  <row>
    <product>Desk lamp</product>
    <region>EU</region>
    <units>128</units>
    <field name="unit price">24.50</field>
  </row>
  <row>
    <product>Chair</product>
    <region>R&amp;D</region>
    <units>64</units>
    <field name="unit price">98.00</field>
  </row>
  <row>
    <product>Monitor</product>
    <region>APAC</region>
    <units>32</units>
    <field name="unit price">249.99</field>
  </row>
</rows>

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.