SQL To CSV - Complete Guide

SQL to CSV converter transforms SQL query results into comma-separated values format. CSV is universally supported for data exchange, spreadsheet import, and analysis tools. Essential for reporting, data export, and integration with non-database systems.

How It Works

First row contains column headers from SELECT columns. Each subsequent row contains values, comma-separated. Special characters (commas, quotes, newlines) are escaped by quoting fields. NULL values become empty fields or specified placeholder.

Technical Details

RFC 4180 defines CSV format: CRLF line endings, double-quote escaping, optional header row. Fields containing comma, quote, or newline must be quoted. Embedded quotes become double-quotes (""). Character encoding typically UTF-8.

Common Use Cases

1. Excel/Spreadsheet Export: Export database data for analysis in Excel or Google Sheets.
2. Data Exchange: Universal format for sharing data between systems.
3. Reporting: Generate reports that business users can open in spreadsheets.
4. Backup/Archive: Human-readable data backup format.

Code Examples

SQL to CSV Conversion

function escapeCSV(value) {
  if (value === null || value === undefined) return '';
  const str = String(value);
  // Quote if contains comma, quote, or newline
  if (/[",\n\r]/.test(str)) {
    return '"' + str.replace(/"/g, '""') + '"';
  }
  return str;
}

function sqlToCSV(columns, rows) {
  const header = columns.map(c => escapeCSV(c.name)).join(',');
  const dataRows = rows.map(row =>
    row.map(val => escapeCSV(val)).join(',')
  );
  return [header, ...dataRows].join('\n');
}

// Example
const columns = [{name: 'Name'}, {name: 'Description'}];
const rows = [
  ['Widget', 'A "great" product'],
  ['Gadget', 'Has, multiple, features']
];
sqlToCSV(columns, rows);
// Name,Description
// Widget,"A ""great"" product"
// Gadget,"Has, multiple, features"

Escape fields containing special characters. Quote and double internal quotes.

Tips & Best Practices

• Use UTF-8 encoding
• Quote fields with special characters
• Document NULL handling
• Test with Excel/Sheets import
• Consider CSV library for complex data

Common Mistakes to Avoid

• Not escaping commas in data
• Wrong line endings (CRLF vs LF)
• Encoding issues with special characters
• Inconsistent NULL handling

When to Use This Tool

Use SQL to CSV for spreadsheet exports, data exchange with non-technical users, reporting, and any situation requiring universal data format compatibility.

Frequently Asked Questions

How do I handle NULL values?

Options: empty field (most common), literal "NULL", or custom placeholder. Empty field is standard but may be ambiguous with empty strings. Document your choice.

What about dates and numbers?

Dates: use ISO format or locale-specific. Numbers: avoid thousands separators (commas conflict). Booleans: "true"/"false" or "1"/"0". Be consistent throughout.

How do I escape special characters?

Quote the entire field. If the field contains quotes, double them: "He said ""hello""". Fields with commas, newlines, or quotes must be quoted.

What character encoding should I use?

UTF-8 is standard and handles international characters. Some older tools expect Windows-1252 or Latin-1. Excel may need UTF-8 BOM for proper recognition.

Get Started

Ready to try SQL To CSV? Use the tool now - it's free, fast, and works right in your browser.

---

Last updated: June 27, 2026