Start a project

Tool 244 of 425 · SQL

CSV/JSON to SQL INSERT Generator

Generates dialect-correct INSERTs, and optionally a CREATE TABLE, from pasted CSV or JSON.

CSV/JSON to SQL INSERT Generator

Your input

Result

SQL

    01

    What it does

    Generates dialect-correct INSERTs, and optionally a CREATE TABLE, from pasted CSV or JSON.

    • PostgreSQL, MySQL, SQLite, SQL Server quoting
    • Multi-row batches
    • Empty cells as NULL
    • CREATE TABLE with guessed types

    02

    Private by design

    Everything happens in your browser. Nothing you type, paste or upload is sent anywhere, and it keeps working offline once the page has loaded.

    03

    What you get

    SQL statements, with a Copy and a Download button on every result.

    • SQL INSERT
    • CSV to SQL
    • Seed data

    Why it matters

    Seeding a database from a spreadsheet or an API response means escaping quotes and getting identifier quoting right for each database.

    This writes it all for you, batched so large imports run fast.

    How to use it

    1. Type or paste your input; the example shows the format.
    2. Press Generate SQL. Results also update as you type.
    3. Read the summary line, then the table, notes or output below it.
    4. Copy or download what you need. Nothing leaves this page.

    FAQ

    Are values escaped?

    Yes, single quotes are doubled. Still review data from untrusted sources.

    How big should batches be?

    100–1000 rows per INSERT is a good balance for most databases.

    Is my input uploaded?

    No. The tool runs in your browser and nothing you type, paste or open is sent anywhere.

    Can I rely on the result?

    It follows the public specification or formula named on this page and says where it simplifies. Check anything critical against the official tool or documentation before you ship it.

    Work with me

    Want a site that gets these right?

    I build fast, accessible websites and web apps that pass these checks from day one. Tell me about your project and I'll reply personally with honest next steps.

    All developer tools · Back to leej.uk