Use case · Table Formatter

Parsing Raw Delimited Text and Generating SQL Migrations for DBAs

How database administrators and ETL engineers convert unstructured pipe, tab, or comma-delimited text dumps into normalized tables and executable SQL INSERT scripts.

Open Table Formatter Add to VS Code

Free · runs in your browser · your files are never uploaded

TLDR

Database administrators and backend engineers frequently receive unstructured text dumps from server logs, support tickets, or emails that need to be seeded into relational databases. Hand-writing SQL INSERT INTO queries for dozens of rows is tedious and prone to syntax errors. GINEXYS Table Formatter (Table IDE) parses raw delimited text into a structured grid and generates executable SQL CREATE TABLE and batch INSERT scripts with automatic quote escaping.

The Persona & The Pain Point

You manage database migrations, seed initial staging tables, or ingest ad-hoc data feeds for PostgreSQL, MySQL, or SQLite.

Colleagues frequently send you unformatted text dumps in Slack or email (pipe-separated values, space-aligned terminal tables, or tab-delimited logs). Manually converting these text blobs into SQL queries requires hand-typing INSERT INTO table VALUES ('val1', 'val2', ...) for every row. A single unescaped apostrophe (like O'Reilly) crashes the entire migration transaction.

The Workflow in Practice

Paste Raw Text Dump: Open Table Formatter in Table Mode and paste your text blob directly into cell A1.
Auto-Split Delimiters: Press Alt+Shift+T to open the delimiter settings. Select your column separator (Pipe |, Tab \t, Comma ,, or Custom) and press Alt+Shift+X.
Review Columns & Clean Headers: The text splits cleanly into discrete table columns. Tag Row 1 as headers and name them with your database column names (item_id, item_name, status).
Auto-Escape Special Characters: Table Formatter automatically trims whitespace and escapes embedded single quotes in string values.
Export Executable SQL Script: Click Export > SQL Script (.sql), enter your target table name (e.g. inventory), and download a complete, executable SQL script containing CREATE TABLE and batch INSERT queries.

Key Benefits for Database Administrators

Task	Manual SQL Scripting	GINEXYS Table Formatter
Delimiter Splitting	Write custom Python or sed/awk regex	1-click shortcut splitting (`Alt+Shift+X`)
String Escaping	Manually escape single quotes (`'` to `''`)	Automatic string quote escaping
Data Type Detection	Manually inspect every column	Auto-detects integer, decimal, and string columns
Output Readiness	High risk of syntax bugs on staging runs	100% compliant SQL `INSERT` statements

Real-World Example & Output

Converting a raw pipe-delimited inventory dump into PostgreSQL migration queries:

-- Generated SQL Migration from Table Formatter
CREATE TABLE inventory (
    item_id VARCHAR(50) NOT NULL,
    item_name VARCHAR(255) NOT NULL,
    quantity INTEGER NOT NULL,
    notes VARCHAR(255)
);
INSERT INTO inventory (item_id, item_name, quantity, notes) VALUES ('SKU-101', 'Microcontroller Unit', 250, 'Standard packaging'), ('SKU-102', 'Resistor 10k 0805', 5000, 'Reel in stock'), ('SKU-103', 'O''Reilly Technical Manual', 12, 'Author review copy');

Ready to try it?

Table Formatter — Clean, reshape, and convert tabular data between HTML, CSV, TSV, SQL, and Markdown.

Open Table Formatter Add to VS Code Source