How to Export Data to CSV?

Looking to quickly export data to CSV using PHP?

Whether you’re building admin reports, creating data backups, or integrating with tools like Excel and Google Sheets, CSV export is one of the most practical features every PHP and WordPress developer should understand.

However, exporting CSV reliably is not just about writing rows to a file. The real challenge is doing it correctly, securely, and in a way that does not break performance as data grows.

This up-to-date guide walks you through multiple ways to export arrays and database data to CSV using PHP 8.x, including complete code, common pitfalls, performance considerations, and real-world fixes.

If you are exporting data from WordPress plugins, WooCommerce, or wp-admin screens, understanding performance implications early will save you from serious issues later.

Before diving in, it’s also worth understanding how inefficient queries can slow down exports. If you haven’t already, read: Optimize WP_Query for Better Performance

What is CSV File?

A CSV (Comma-Separated Values) file is a plain-text file that stores data in a tabular format. Each line represents a row, and values are separated by delimiters, typically commas.

Why CSV Is Widely Used?

• Universal compatibility: Works with Excel, Google Sheets, databases, BI tools, and CRMs
• Lightweight and fast: Easy to generate and process
• Ideal for exports: Reports, backups, migrations, and integrations

CSV is simple by design, but exporting it incorrectly can lead to encoding issues, broken downloads, or performance bottlenecks.

PHP Functions for Exporting CSV

PHP provides reliable native functions that handle most CSV edge cases for you.

1. fputcsv()

The primary function for writing CSV rows. It automatically:

• Escapes special characters
• Handles quoting
• Applies the correct delimiter

Example:

$row = ['Name', 'Email', 'Role'];
fputcsv($fileHandle, $row);

Using fputcsv() avoids many formatting errors that occur when manually concatenating strings.

2. fopen() and fclose()

You need a file pointer to write CSV output.

Example:

$fileHandle = fopen('php://output', 'w');

// Write CSV rows.
fclose($fileHandle);

• php://output sends the CSV directly to the browser
• A file path saves it on the server

3. File vs Direct Download

If your export is triggered inside wp-admin, be mindful of execution time and memory usage. Admin exports are a common cause of slow dashboards.

• Save to file: Useful for background jobs or cron tasks
• Force browser download: Ideal for admin exports and reports

Export Data to CSV: Step by Step Guide

This step-by-step flow ensures your CSV export works reliably across browsers and datasets.

Note: Always adapt the code based on your data source and scale.

Step 1: Start Output Buffering

// Start the output buffer.
ob_start();

Output buffering prevents accidental output (whitespace, notices) from corrupting your CSV file.

Step 2: Set Proper CSV Headers

// Set PHP headers for CSV output.
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=csv_export.csv');

Without these headers, the browser may display the CSV instead of downloading it.

Step 3: Define CSV Headers

// Create the headers.
$header_args = array( 'ID', 'Name', 'Email' );

These headers become the first row of your CSV file.

Step 4: Prepare the Data

Your data should be structured as a multi-dimensional array.

// Prepare the content to write it to CSV file.
$data = array(
    array('1', 'Test 1', '[email protected]'),
    array('2', 'Test 2', '[email protected]'),
    array('3', 'Test 3', '[email protected]'),
);

Important considerations:

• Sanitize and validate all data
• Ensure consistent structure
• Handle special characters and encodings

If your data comes from WordPress or WooCommerce, poorly optimized queries can make exports painfully slow.

Step 5: Clean Output Buffer

// Clean up output buffer before writing anything to CSV file.
ob_end_clean();

This ensures no extra output is included in the CSV file.

Step 6: Create File Pointer

// Create a file pointer with PHP.
$output = fopen( 'php://output', 'w' );

A file pointer allows you to manage and manipulate files in a controlled manner, such as reading from or writing to a file. So, create a file pointer connected to the output stream, which will be used to write the CSV data.

Step 7: Write Headers and Data

fputcsv($output, $header_args);

foreach ($data as $data_item) {
    fputcsv($output, $data_item);
}

fputcsv() automatically handles quoting, delimiters, and line breaks.

Step 8: Close and Exit

// Close the file pointer with PHP with the updated output.
fclose( $output );
exit;

Complete Code: CSV Output for Download

<?php
/**
 * CSV Export using PHP
 * Author: Mehul Gohil
 */

ob_start();

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=csv_export.csv');

$header_args = array('ID', 'Name', 'Email');

$data = array(
    array('1', 'Test 1', '[email protected]'),
    array('2', 'Test 2', '[email protected]'),
    array('3', 'Test 3', '[email protected]'),
);

ob_end_clean();

$output = fopen('php://output', 'w');

fputcsv($output, $header_args);

foreach ($data as $data_item) {
    fputcsv($output, $data_item);
}

fclose($output);
exit;

Best Practices

To enhance the quality of your CSV export implementation, consider these best practices and be aware of potential issues.

• Use UTF-8 encoding consistently
• Add BOM for Excel compatibility when needed
• Stream large datasets instead of loading them into memory
• Avoid running large exports directly inside wp-admin requests

For very large datasets, consider command-line exports.

Common CSV Export Issues in PHP (And How to Fix Them)

Exporting CSV files in PHP looks simple on the surface, but in real-world applications it often fails due to output buffering issues, encoding mismatches, browser behavior, or scale-related constraints. These problems usually appear only after deployment or when handling real data, not during local testing.

Below are the most common CSV export issues developers face, why they happen, and how to fix them reliably.

1. CSV File Is Blank or Not Downloading

This is one of the most frequent issues developers encounter. The CSV download either produces an empty file or nothing happens when the export is triggered.

Why this happens: In most cases, PHP headers are sent too late, output has already started (even a single space), or the output buffer is not handled correctly. CSV exports are extremely sensitive to premature output.

How to fix it: Ensure headers are sent before any output and clean the buffer before writing data.

• Place CSV headers at the very top of the script
• Remove any whitespace outside PHP tags
• Use output buffering correctly
• Always close the file handle

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename="export.csv"');

If needed, clean the buffer explicitly before writing:

ob_clean();
flush();

2. Garbled Characters or Encoding Problems

If special characters, accents, or non-English text appear as question marks or broken symbols, you’re dealing with an encoding issue.

Why this happens: CSV files do not inherently declare encoding, and applications like Excel often fail to auto-detect UTF-8 correctly.

How to fix it: Force UTF-8 encoding and add a BOM for Excel compatibility.

header('Content-Type: text/csv; charset=utf-8');
fwrite($output, "\xEF\xBB\xBF");

Also ensure your database and PHP strings are UTF-8 encoded before exporting.

3. Data Not Separated Into Columns

When opening the CSV, all data appears in a single column instead of being split properly.

Why this happens: This usually occurs when the delimiter used in the CSV does not match what the spreadsheet software expects, or when values contain unescaped commas.

How to fix it: Explicitly define the delimiter when writing CSV rows.

fputcsv($output, $row, ',');

For regions where Excel expects semicolons:

fputcsv($output, $row, ';');

Always rely on fputcsv() instead of manually concatenating strings.

4. Browser Displays CSV as Plain Text

Instead of downloading, the browser opens the CSV file directly in a new tab.

Why this happens: The browser is not instructed to treat the response as a downloadable file.

How to fix it: Use the correct Content-Disposition header and ensure no output is sent beforehand.

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename="export.csv"');

This forces the browser to download the file rather than render it.

5. Large File Export Fails (Timeouts or Memory Errors)

Exports work fine with small datasets but fail or time out when exporting thousands of rows.

Why this happens: Large exports consume memory quickly when data is loaded all at once. PHP execution time limits can also be exceeded.

How to fix it: Stream data row-by-row instead of loading everything into memory.

• Fetch database records in batches
• Write each row immediately using fputcsv()
• Avoid building large arrays in memory

For extremely large exports, consider:

• Background processing
• WP-CLI commands
• Asynchronous jobs

These approaches scale far better than browser-based exports.

Bonus Tip: Debugging CSV Issues Faster

When debugging CSV exports:

• Test with real production-like data
• Open files in both Excel and Google Sheets
• Log export execution time and memory usage
• Avoid mixing HTML output with export logic

Most CSV issues are not PHP bugs, they’re output flow and scale problems.

Conclusion

Exporting data to CSV using PHP is a common requirement, but getting it right requires attention to detail. From setting correct headers and managing output buffers to handling encoding issues and large datasets, small mistakes can lead to broken downloads, corrupted files, or performance problems.

This guide walked through the complete CSV export process step by step, highlighted common errors developers face, and showed practical fixes that work reliably across modern PHP versions. When implemented correctly, CSV exports become predictable, secure, and scalable rather than a recurring source of bugs.

If you are working within WordPress, plugins, or admin-heavy applications, treat CSV exports as part of your system design, not a quick utility. Stream data where possible, validate inputs, and always test with real-world data sizes.

A well-built CSV export improves operational workflows, reduces support issues, and ensures your application can scale without surprises. Getting these fundamentals right pays off across every PHP project you build.