SQL INSERT to CSV / JSON Converter

Name: Chat2DB
Price: 9.9 USD
Availability: InStock

Paste INSERT statements from mysqldump, pg_dump --inserts, SSMS or any SQL export and get clean CSV, TSV, JSON or a Markdown table back. A real SQL scanner reads the VALUES lists, so quoted strings containing commas, semicolons, parentheses or newlines, '' and backslash escapes, NULL, negative and exponent numbers, hex literals and expressions like NOW() or CAST(... AS ...) all come out right. CREATE TABLE, LOCK TABLES and SET lines are skipped, and each table in the dump gets its own output. Nothing is uploaded: the conversion runs entirely in your browser.

FormatDelimiterNULL asLine endingTable

Backslash escapes (MySQL)Include header rowUTF-8 BOM in downloads (Excel)

SQL INSERT statements

-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `bio` text,
  `balance` decimal(10,2) DEFAULT '0.00',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `bio`, `balance`, `created_at`) VALUES (1,'O\'Brien','Likes "quotes", commas; and semicolons',-12.50,'2026-01-01 09:00:00'),(2,'Ana','Tricky: \'),(\' inside a string',1.5e3,NOW()),(3,'NULL',NULL,0,'2026-02-03 10:30:00');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

# MySQL comment line
INSERT IGNORE INTO `shop`.`orders` VALUES (100,1,'Line one
line two',0x4F4B) ON DUPLICATE KEY UPDATE `status` = VALUES(`status`);

-- PostgreSQL (pg_dump --inserts style)
INSERT INTO "public"."events" ("id", "payload", "tags", "happened_on", "published") VALUES
  (1, '{"a": 1}', ARRAY['x','y'], '2026-01-01'::date, true),
  (2, E'tab\there', ARRAY[]::text[], CAST('2026-03-04' AS date), false)
ON CONFLICT ("id") DO NOTHING;

-- SQL Server
INSERT INTO [dbo].[Products] ([Id], [Name], [Price], [InStock]) VALUES (1, N'Café ''Deluxe''', 9.99, 1);

4 INSERT statements · 4 tables · 7 rows · skipped: DROP TABLE ×1, CREATE TABLE ×1, LOCK TABLES ×1, UNLOCK TABLES ×1

users (3 rows × 5 columns)

id,name,bio,balance,created_at
1,O'Brien,"Likes ""quotes"", commas; and semicolons",-12.50,2026-01-01 09:00:00
2,Ana,"Tricky: '),(' inside a string",1.5e3,NOW()
3,NULL,,0,2026-02-03 10:30:00

shop.orders (1 row × 4 columns)

col1,col2,col3,col4
100,1,"Line one
line two",0x4F4B

public.events (2 rows × 5 columns)

id,payload,tags,happened_on,published
1,"{""a"": 1}","ARRAY['x','y']",'2026-01-01'::date,TRUE
2,tab	here,ARRAY[]::text[],CAST('2026-03-04' AS date),FALSE

dbo.Products (1 row × 4 columns)

Id,Name,Price,InStock
1,Café 'Deluxe',9.99,1

Do more than sql insert to csv / json converter — meet Chat2DB

Chat2DB is an AI-powered SQL client for Windows, macOS and Linux. Write SQL in natural language, format and optimize queries automatically, and manage MySQL, PostgreSQL, Oracle and 20+ other databases in one workspace.

How to use

Paste one or more INSERT INTO ... VALUES statements, or a whole mysqldump / pg_dump --inserts file. Turn off Backslash escapes for PostgreSQL or SQL Server scripts.
Pick the output format (CSV, TSV, JSON or Markdown) and adjust the delimiter, header row, NULL representation and line ending.
Choose a table if the script contains several, then copy the result or download it as a .csv, .tsv, .json or .md file.

Frequently asked questions

How do I convert a mysqldump file to CSV?

Paste the dump (or the part with the tables you need). The converter ignores comments, /*!40101 SET ... */ lines, DROP/CREATE TABLE and LOCK TABLES, reads every INSERT INTO ... VALUES row with MySQL backslash escapes, and gives each table its own CSV you can copy or download. For pg_dump --inserts output, switch Backslash escapes off, since PostgreSQL standard strings treat a backslash as a normal character.

How are NULL, empty strings and the text 'NULL' kept apart?

An unquoted NULL is written with the NULL representation you choose (empty, NULL or \N). If a real string equals that representation, for example the text 'NULL' or an empty string '', it is wrapped in double quotes so importers such as PostgreSQL COPY ... CSV can tell them apart. In JSON, NULL becomes null, numbers stay numbers and TRUE/FALSE become booleans.

Can I export query results straight to CSV instead of converting INSERT statements?

Yes. If you still have access to the database, it is easier to run the query and export the result grid directly. Chat2DB (https://chat2db.ai/download, or the web version at https://app.chat2db.ai) exports any result set or table to CSV, Excel, JSON or SQL INSERT statements for MySQL, PostgreSQL, SQL Server, Oracle and 20+ other databases.