SQL to HTML Converter

SQL to HTML Converter is a free online tool that turns the rows your SQL query returns into an HTML table. It runs the SQL statements you paste on a lightweight, ephemeral SQL engine and formats the result as table markup. Nothing connects to your production database. Here is how the conversion works:

• Paste your SQL: You provide a SELECT query, or a full CREATE TABLE, INSERT INTO, and SELECT script.
• Run the statements: The tool executes them in order on a lightweight SQL engine, not on your own database.
• Read the result set: The rows returned by your final SELECT become the data for the table.
• Format as HTML: Each column becomes a th header cell and each row becomes td cells inside a table element.
• Copy or download: You copy the generated table markup or download it as an .html file to drop into your web page.

Because the tool executes real SQL, you can paste a plain SELECT, a full database dump ending in a SELECT, or a query built from inline literals, and get clean table markup back every time.

What SQL the converter accepts

The converter runs the SQL you paste and turns the rows your query returns into an HTML table. Give it any statement that produces a result set and it renders the output as table markup you can drop straight into a web page. The two inputs below cover almost every use case.

Paste a SELECT query

The simplest input is a SELECT that returns rows. You can even build the rows inline with literals, without any existing table:

SELECT 1 AS id, 'Ava' AS name, 'ava@example.com' AS email
UNION ALL
SELECT 2, 'Noah', 'noah@example.com';

Convert an INSERT INTO dump

Working from a database dump? Paste the whole script - the CREATE TABLE statement, the INSERT INTO rows, and a SELECT at the end. The converter executes the statements in order and renders the final SELECT:

CREATE TABLE users (id INT, name VARCHAR(50), email VARCHAR(100));

INSERT INTO users (id, name, email) VALUES
  (1, 'Ava',  'ava@example.com'),
  (2, 'Noah', 'noah@example.com');

SELECT * FROM users;

Output

<table>
  <tr><th>id</th><th>name</th><th>email</th></tr>
  <tr><td>1</td><td>Ava</td><td>ava@example.com</td></tr>
  <tr><td>2</td><td>Noah</td><td>noah@example.com</td></tr>
</table>

Pasting only INSERT INTO rows returns a "no such table" error, and a CREATE TABLE with no SELECT returns nothing to display - so always finish with a SELECT to give the tool a result set to render. Once you have the table markup, convert the same data to other formats with our SQL to CSV, SQL to JSON, or SQL to XML tools, or tidy the query first with the SQL Beautifier.

How to generate HTML tables directly within SQL queries

You can also make the database itself emit HTML, which is handy for reports and scheduled jobs. The syntax differs by engine: SQL Server uses FOR XML PATH, while MySQL relies on string functions such as CONCAT and GROUP_CONCAT.

SQL Server (T-SQL) with FOR XML PATH

Alias each column as td and wrap the rows with PATH('tr') and ROOT('table'); the empty '' separators keep the column names out of the markup:

-- SQL Server / T-SQL
SELECT
    td = id,    '',
    td = name,  '',
    td = email
FROM users
FOR XML PATH('tr'), ROOT('table');

MySQL with CONCAT and GROUP_CONCAT

In MySQL, CONCAT builds each row and GROUP_CONCAT stitches the rows into a single string:

-- MySQL
SELECT CONCAT(
  '<table>',
  '<tr><th>id</th><th>name</th><th>email</th></tr>',
  GROUP_CONCAT(
    CONCAT('<tr><td>', id, '</td><td>', name, '</td><td>', email, '</td></tr>')
    SEPARATOR ''
  ),
  '</table>'
) AS html_table
FROM users;

These techniques run inside your own SQL Server or MySQL database. The converter above uses a standard SQL engine, so keep engine-specific tricks like FOR XML PATH for your production database and paste portable SELECT statements here.

How to display SQL database data on an HTML page

For a live page, query the database in your backend and loop the rows into a table. Here are two common patterns.

Python (Flask + Pandas)

Pandas can turn a query straight into an HTML table with a single to_html() call:

# app.py  ->  flask run
from flask import Flask
import sqlite3, pandas as pd

app = Flask(__name__)

@app.route("/users")
def users():
    con = sqlite3.connect("app.db")
    df = pd.read_sql_query("SELECT id, name, email FROM users", con)
    con.close()
    return df.to_html(index=False, border=0)

PHP (PDO)

In PHP, run the query with PDO and echo a table row for each record:

<?php
$pdo = new PDO("mysql:host=localhost;dbname=app", "user", "pass");
$rows = $pdo->query("SELECT id, name, email FROM users");

echo "<table><tr><th>id</th><th>name</th><th>email</th></tr>";
foreach ($rows as $r) {
    echo "<tr><td>" . $r["id"] . "</td>"
       . "<td>" . $r["name"] . "</td>"
       . "<td>" . $r["email"] . "</td></tr>";
}
echo "</table>";

Style the generated table with CSS or a framework like Bootstrap to make it responsive across screen sizes. Prefer a no-code route? Paste your query into the converter at the top of this page and copy the HTML it returns.