How to Convert Tables Between CSV, JSON, HTML, Markdown, and SQL

Converting tables between different formats is a common task for developers and data analysts - exporting SQL queries to CSV, turning JSON into Markdown tables, or converting HTML tables to SQL inserts. This guide shows you how to convert tables between CSV, JSON, HTML, Markdown, and SQL online using fixie.tools with instant conversion and format validation.

Step 1: Open the Table Converter

Visit fixie.tools/table-convert in your browser. The tool works on all devices without requiring any signup or installation.

Step 2: Paste or Upload Source Data

Paste your table data in the input area or upload a file. The tool auto-detects the source format (CSV, JSON, HTML table, Markdown table, or SQL INSERT statements). You can also manually select the source format if auto-detection fails.

Step 3: Select Target Format

Choose your desired output format from the dropdown: CSV (spreadsheet-compatible), JSON (array of objects or nested structures), HTML (table element with optional styling), Markdown (GitHub-flavored tables), or SQL (INSERT/CREATE statements).

Step 4: Configure Conversion Options

Set format-specific options: CSV delimiter (comma, tab, semicolon), JSON structure (array vs object), HTML table classes for styling, Markdown alignment (left, center, right), or SQL table name and data types. The tool provides smart defaults based on your data.

Step 5: Copy or Download Converted Table

The converted table appears instantly in the output pane. Copy to clipboard or download as a file (.csv, .json, .html, .md, or .sql). The tool validates output syntax to ensure your converted table is ready to use.

Frequently Asked Questions

Is the table converter free?
Yes, completely free with no signup required. Convert unlimited tables between any supported formats instantly.
What table formats are supported?
Input formats: CSV, JSON (arrays/objects), HTML tables, Markdown tables, SQL INSERT statements. Output formats: CSV, JSON, HTML, Markdown, SQL CREATE/INSERT. The tool handles conversions between any combination.
Can it handle large datasets?
Yes, the tool can process tables with thousands of rows. Processing happens locally in your browser, so there's no upload time. Very large files (>10MB) may be slow depending on your device performance.
Does it preserve data types when converting to SQL?
The tool intelligently infers data types from your data (VARCHAR, INT, FLOAT, DATE, BOOLEAN) when generating SQL. You can manually adjust types in the configuration panel before generating the final SQL output.
What if my CSV has special characters or quotes?
The tool properly handles quoted fields, escaped quotes, and newlines within fields according to RFC 4180 CSV specification. It also supports different delimiters (comma, tab, semicolon) and quote characters.

Related Tools