How to Use TableMorpher to Convert & Clean Tabular Data
TableMorpher is an interactive, browser-based data wrangling workbench that transforms messy tabular datasets between CSV, TSV, JSON, GitHub-Flavored Markdown (GFM), SQL DDL/DML statements, and semantic HTML5 <table> markup. Because every parser and serializer runs 100% locally in your browser's memory, you can safely inspect financial spreadsheets, database dumps, and internal analytics tables without uploading files to third-party servers.
-
Paste or Load Sample Data: Paste your raw dataset into the Multi-Format Data Input box or click one of the 1-Click Sample buttons in the top bar (CSV SaaS Metrics, JSON Cloud Servers, Markdown API Table, or TSV Employee Roster). TableMorpher automatically detects the input structure.
-
Filter, Sort & Edit Cells Inline: Use the Interactive Data Grid Playground to clean your data before exporting. Uncheck column pills to strip unwanted fields, type a search query to filter matching rows, click any column header to sort numerically or alphabetically, or click directly inside any cell to edit values inline.
-
Export or Download in 1 Click: Choose your desired output tab (Markdown, JSON, CSV, TSV, SQL, or HTML), customize format options (such as Markdown column alignment or SQL table name), and click Copy to Clipboard or Download File.
Key Features & Local-First Privacy Benefits
RFC 4180 State-Machine CSV Parser
Correctly handles escaped double quotes (""), embedded commas inside quoted strings, and multi-column TSV pastes from Excel or Google Sheets.
Smart SQL Type Inference
Inspects every column's values to automatically assign INTEGER, DECIMAL(12,2), BOOLEAN, or VARCHAR(255) types in generated CREATE TABLE statements.
Bidirectional Live Sync
Edits made inside the interactive HTML data grid immediately recalculate the exported Markdown, JSON, SQL, CSV, or HTML code without re-uploading.
Zero Cloud Data Retention
Ideal for GDPR, HIPAA, and SOC2-conscious engineering teams—sensitive customer CSV exports and SQL records never leave your local machine.
Technical Guide: Data Serialization Formats & Best Practices
Choosing the right tabular representation is critical for database migrations, technical documentation, REST API payloads, and data science pipelines. Review the format comparison matrix and engineering guidelines below.
1. Tabular Data Format Comparison Cheat Sheet
2. RFC 4180 CSV Escaping & Quoting Rules
A common pitfall in naive CSV converters is splitting lines with row.split(','), which corrupts fields like "Austin, TX" or "1,250.00". According to the IETF RFC 4180 specification:
- Any field containing a comma (
,), double-quote ("), or line break (\r\n) must be enclosed in double-quotes.
- A literal double-quote character inside a quoted field must be escaped by doubling it (e.g.,
"8"" Solid Steel Pipe").
- Automatic numeric coercion should preserve leading zeros on identifiers like ZIP codes (
02139) or SKU strings.
3. Writing Clean SQL Seeds & GitHub Markdown Tables
When generating SQL INSERT INTO statements from untrusted spreadsheet strings, single quotes (') inside text values—such as O'Reilly Media—must be escaped as '' (two single quotes) to prevent syntax errors and SQL injection vulnerabilities. Similarly, when exporting to GitHub-Flavored Markdown (GFM), literal pipe characters (|) inside cell values must be escaped as \| so they do not prematurely terminate a table column. TableMorpher handles both escaping rules automatically.
Frequently Asked Questions (FAQ)
Is my spreadsheet or database data uploaded to any server?
No. TableMorpher runs 100% locally inside your web browser using client-side JavaScript. Your CSV, JSON, TSV, Markdown, and SQL datasets never leave your computer and are never transmitted over the network.
How do I edit cell values or exclude specific columns before exporting?
After your data is parsed into the Interactive Data Grid Playground, click any cell to edit its text directly. To exclude a column from the exported output, simply uncheck its checkbox pill in the column bar above the table.
What is the difference between JSON "Array of Objects" and "2D Array"?
Array of Objects outputs each row as a key-value dictionary using column headers as keys (e.g., [{"id": 1, "name": "Alice"}]), which is ideal for REST APIs. 2D Array outputs a compact array of arrays where the first element is the header list (e.g., [["id", "name"], [1, "Alice"]]), reducing payload size for large datasets.
How does TableMorpher determine SQL column data types?
When generating the CREATE TABLE statement, TableMorpher scans all non-empty values in each column. If all values are whole numbers, it assigns INTEGER; if floating-point numbers, DECIMAL(12,2); if true/false, BOOLEAN; otherwise it defaults to VARCHAR(255).
Can I paste cells directly from Microsoft Excel or Google Sheets?
Yes! Copying a range of cells in Excel or Google Sheets places Tab-Separated Values (TSV) onto your clipboard. Paste directly into the input box and TableMorpher will auto-detect the TSV format and build the interactive table immediately.