Logo

MySQL to CSV Converter

Transform MySQL database dumps into CSV files with flexible formatting options

MySQL Input

Delimiter Presets

Convert MySQL to other formats

MySQL to ActionScriptMySQL to ASCIIMySQL to AsciiDocMySQL to ASPMySQL to AvroMySQL to BBCodeMySQL to DAXMySQL to Excel

CSV Output

Convert other formats to CSV

CSV to CSVExcel to CSVHTML to CSVJSON to CSVLaTeX to CSVMarkdown to CSVMediaWiki to CSVSQL to CSV

Related Tools

MySQL to DAX

Convert MySQL database dumps to DAX table expressions for Power BI and Analysis Services

MySQL to Excel

Convert MySQL CREATE TABLE and INSERT statements to Excel XLSX format with formatting

MySQL to Firebase

Convert MySQL CREATE TABLE and INSERT statements to Firebase Realtime Database JSON structure

MySQL to HTML

Convert MySQL CREATE TABLE and INSERT statements to HTML table with styling options

MySQL to INI

Convert MySQL CREATE TABLE and INSERT statements to INI configuration file format

MySQL to Jira

Convert MySQL CREATE TABLE and INSERT statements to Jira table markup format

About MySQL to CSV Converter

Convert MySQL database dumps (CREATE TABLE and INSERT statements) to CSV (Comma-Separated Values) format with full control over delimiters, quotes, and formatting options. Perfect for importing MySQL data into spreadsheets, analytics tools, and other databases.

Key Features

  • Custom Delimiters: Comma, semicolon, tab, pipe, or any custom character
  • Quote Control: Customize quote character and escaping behavior
  • Line Endings: Choose between LF (Unix/Mac) or CRLF (Windows)
  • Header Options: Include or exclude header row from MySQL column names
  • Proper Escaping: Automatically quotes fields containing delimiters or newlines
  • RFC 4180 Compliant: Follows CSV standard specifications
  • Smart Parsing: Extracts column names and data from MySQL dumps
  • File Download: Save as .csv file for Excel, Google Sheets, etc.

How to Use

  1. Input MySQL Data: Paste your MySQL CREATE TABLE and INSERT statements or upload a .sql file
  2. Choose Delimiter: Select from presets or enter custom delimiter
  3. Configure Options: Set quote character, line endings, and header inclusion
  4. Review Output: The CSV updates automatically
  5. Download or Copy: Save as .csv file or copy to clipboard

Delimiter Options

  • Comma (,): Standard CSV format (most common)
  • Semicolon (;): European CSV format
  • Tab (\t): TSV (Tab-Separated Values) format
  • Pipe (|): Alternative delimiter for data with commas
  • Custom: Any character or sequence up to 5 characters

Example Conversion

MySQL Input:

CREATE TABLE employees (
  id INT,
  name VARCHAR(100),
  age INT,
  city VARCHAR(50)
);

INSERT INTO employees VALUES (1, 'John Doe', 28, 'New York');
INSERT INTO employees VALUES (2, 'Jane Smith', 34, 'London');

CSV Output (Comma delimiter):

id,name,age,city
1,John Doe,28,New York
2,Jane Smith,34,London

CSV Output (Tab delimiter):

id	name	age	city
1	John Doe	28	New York
2	Jane Smith	34	London

Common Use Cases

  • Excel Import: Convert MySQL data for Microsoft Excel
  • Google Sheets: Import database dumps into Google Sheets
  • Database Migration: Export MySQL data for import into other databases
  • Data Analysis: Convert MySQL data for R, Python, or MATLAB analysis
  • Backup & Archive: Create portable CSV backups of MySQL data
  • Reporting: Generate CSV reports from MySQL query results

CSV Standards

This converter follows RFC 4180 CSV standards:

  • Fields containing delimiters, quotes, or newlines are quoted
  • Quotes within fields are escaped by doubling them
  • Each record is on a separate line
  • Optional header row as first line (from MySQL column names)
  • Consistent number of fields per record

Special Character Handling

  • Delimiters in Data: Automatically quoted
  • Quotes in Data: Escaped by doubling (e.g., " becomes "")
  • Newlines in Data: Preserved within quoted fields
  • NULL Values: Converted to empty strings

Supported MySQL Syntax

  • CREATE TABLE: Extracts column names for CSV headers
  • INSERT INTO: Parses data values from INSERT statements
  • Data Types: Handles all MySQL data types (VARCHAR, INT, DECIMAL, DATE, etc.)
  • Quoted Strings: Handles single and double quotes with proper escaping

FAQ

  • Why do I see extra quotes in some cells?

    Fields containing delimiters, quotes, or newlines must be quoted to produce valid CSV. Any quote character inside a field is doubled according to RFC 4180.

  • Which delimiter should I use for Excel?

    In most locales Excel expects comma-separated values. In some European locales, semicolons are more common. Choose the delimiter that matches your regional Excel settings.

  • How are NULL values handled?

    NULLs are exported as empty fields. If you prefer a literal like "NULL" you can do a simple find/replace after exporting.

  • Can I safely import the output into other databases?

    Yes. The CSV is standard-compliant, so most databases and ETL tools can import it as long as you configure matching delimiter and quote settings.

  • Is any of my SQL data stored or uploaded?

    No. Everything runs in your browser, and your MySQL data is not sent to any server.

Privacy & Security

All conversions happen locally in your browser. Your MySQL data is never uploaded to any server, ensuring complete privacy and security.