SQL to Table Converter
Extract data from SQL INSERT statements and render it as a live, sortable table right in your browser. Click any column to sort, then export as CSV, Markdown, or JSON.
Recommended Settings
Pro Tips
- •Click a column header to sort ascending, click again to sort descending, and a third click clears sorting
- •Works with a single INSERT statement with many VALUES tuples, or multiple separate INSERT statements for the same table
- •Escaped single quotes ('') inside string values are automatically unescaped
- •If an INSERT statement doesn't list column names, generic column1, column2... headers are generated
- •Export as CSV or Markdown for docs and spreadsheets, or as JSON to keep the current sort order
Most Popular
Most users paste a batch of INSERT statements and sort by a key column before exporting to CSV
When to Use This Tool
Paste INSERT statements from a database export or seed file and instantly see the data as a sortable table, making it easy to spot outliers, duplicates, or missing fields.
Sort extracted SQL data by a column - like date, amount, or name - directly in the browser, then export the sorted result as CSV or Markdown.
Convert raw SQL INSERT statements into a readable, sortable table for teammates who'd rather scan a spreadsheet-like view than parse SQL.
Render seed script data as a table to quickly verify row counts, column values, and data quality before running it against a database.
How It Works
Split the SQL input into individual statements, respecting semicolons inside quoted strings
Filter to statements starting with INSERT INTO, and parse each one's table name, optional column list, and VALUES section
Extract each parenthesized VALUES tuple, correctly handling nested parentheses and commas inside quoted string values
Parse each value into its proper type and render the combined rows as a live, styled HTML table directly on the page
Click any column header to sort the table, then copy or download it as CSV, Markdown, or JSON
100% Private
Files never leave your device. All processing happens locally in your browser.
Lightning Fast
Powered by Pure JavaScript for optimal performance on modern browsers.
Secure
No data collection, no tracking, no sign-up required.
Frequently Asked Questions
How is this different from the SQL to CSV or SQL to HTML tools?
This tool renders the extracted SQL data as an interactive table directly on the page, so you can sort it and inspect it visually before exporting. The SQL to CSV, JSON, and HTML tools instead generate raw text or code output.
What SQL syntax does this tool support?
It parses standard INSERT INTO table (columns) VALUES (...), (...); statements, including statements without an explicit column list. CREATE TABLE statements and other SQL are ignored.
Can I convert multiple INSERT statements at once?
Yes. Paste any number of INSERT statements - whether they're multiple separate statements or one statement with many VALUES tuples - and all their rows are combined into a single table.
How does sorting work?
Click a column header to sort ascending, click again for descending, and a third click returns to the original order. Numbers and booleans sort numerically, and everything else sorts alphabetically. Sorting only affects display and export - your original SQL input isn't modified.
Which export format should I use?
Use CSV for spreadsheets like Excel or Google Sheets, Markdown for documentation and READMEs, and JSON if you want to keep the current sort order as structured data.