SmartQueryTools

SQL Dump Importer

Upload a SQL file containing CREATE TABLE and INSERT statements. DuckDB executes the SQL locally and lets you export the results as CSV, Parquet, JSON, Excel, and more — no server, no upload.

Loading DuckDB engine…

How to use the SQL Dump Importer

  1. Drop a .sql file that contains CREATE TABLE and INSERT INTO statements, or click the drop area to browse.
  2. The whole script runs in your browser. When it finishes, the tool shows how many tables were created.
  3. If there is more than one table, pick one from the dropdown. You see its row count, column count and the first 200 rows.
  4. Choose an output format: CSV, JSON, Parquet, TSV, NDJSON or Excel.
  5. Click Download. The file is named after the table, for example customers.csv. Select the next table to export it too.

Worked example

You have a small dump, shop.sql, with two tables. You want the customers table as a CSV file you can open in a spreadsheet.

Input (shop.sql)

CREATE TABLE customers (id INTEGER, name VARCHAR, country VARCHAR);
INSERT INTO customers VALUES
  (1, 'Ana', 'PT'),
  (2, 'Ben', 'NZ'),
  (3, 'Chloe', 'FR');

CREATE TABLE orders (id INTEGER, customer_id INTEGER, total INTEGER);
INSERT INTO orders VALUES (10, 1, 40), (11, 3, 25);

Settings

  • Table: customers (2 tables created)
  • Output format: CSV

Output (customers.csv)

id,name,country
1,Ana,PT
2,Ben,NZ
3,Chloe,FR

Both tables are created. Tables are listed alphabetically, so customers is selected first. Switch the dropdown to orders and download again to get the second table.

Frequently Asked Questions

How do I convert a SQL file to CSV without installing a database?

Drop the .sql file here. The statements run in a database engine inside your browser tab, and each table they create can be downloaded as CSV, Excel, JSON or Parquet. There is nothing to install and no server to set up.

Can I import a MySQL dump from mysqldump?

Often not unchanged. The SQL dialect used here is close to PostgreSQL. MySQL-only parts such as ENGINE=InnoDB table options, LOCK TABLES and UNLOCK TABLES, and backtick-quoted names usually need to be removed or replaced with double quotes before the file will run.

What about a PostgreSQL dump from pg_dump?

Export with pg_dump --inserts (or --column-inserts) so the data is written as INSERT statements. The default COPY ... FROM stdin blocks will not run here. Lines such as ALTER TABLE ... OWNER TO or CREATE EXTENSION may also need to be removed.

What happens if the file has an error?

The tool stops and shows the error message from the engine, which usually names the statement or keyword it could not handle. Fix or delete that part of the file and load it again.

Is my SQL file uploaded?

No. The file is read and executed in your browser. Nothing is sent to a server. Very large dumps are limited by the memory available to your browser.

Related tools

SQL Query Tool

Write SQL against CSV, Parquet, JSON and Excel files in your browser.

CSV to SQL

Go the other way: turn a CSV file into CREATE TABLE and INSERT statements.

Excel to SQL

Generate SQL INSERT statements from an Excel sheet.

SQL Formatter

Tidy and indent SQL so a long dump is easier to read and fix.

Data Profiler

Check row counts, null rates and column stats of an exported table.

CSV Viewer

Open the exported CSV and browse it without a spreadsheet app.