Skip to tool

Support

Categories

File formats / 11 formats, every pair

HTML to SQL converter

Turn HTML into SQL — CREATE TABLE and INSERT statements with quoted identifiers — in this browser tab. Paste your HTML, copy the SQL: the quoting and escaping SQL needs are applied for you.

On-device prototype

HTML to SQL, worked out

3 rows and 4 columns: 30 lines of HTML become 11 lines of SQL.

HTML in

<table>
  <thead>
    <tr>
      <th>product</th>
      <th>region</th>
      <th>units</th>
      <th>unit price</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>Desk lamp</td>
      <td>EU</td>
      <td>128</td>
      <td>24.50</td>
    </tr>
    <tr>
      <td>Chair</td>
      <td>R&amp;D</td>
      <td>64</td>
      <td>98.00</td>
    </tr>
    <tr>
      <td>Monitor</td>
      <td>APAC</td>
      <td>32</td>
      <td>249.99</td>
    </tr>
  </tbody>
</table>

SQL out

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

SQL result

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

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.