How to Export CSV file in Laravel Example

Exporting data to CSV is one of the many features most applications should have. Sometimes it would be a report for your marketing or finance team or a list of products in your inventory.

Step 1: Add Route

Route::get('export/customers','[email protected]');

Step 2: Add the below in your Controller

function export() {
        $fileName = 'customers.csv';
        $customers = Customer::all();

        $headers = array(
            "Content-type"        => "text/csv",
            "Content-Disposition" => "attachment; filename=$fileName",
            "Pragma"              => "no-cache",
            "Cache-Control"       => "must-revalidate, post-check=0, pre-check=0",
            "Expires"             => "0"
        );

        $columns = array('Firstname', 'Lastname', 'Email', 'Created At');

        $callback = function() use($customers, $columns) {
            $file = fopen('php://output', 'w');
            fputcsv($file, $columns);

            foreach ($customers as $customer) {
                $row['firstname']  = $customer->firstname;
                $row['lastname']    = $customer->lastname;
                $row['email']    = $customer->email;
                $row['created_at']  = $customer->created_at;


                fputcsv($file, array($row['firstname'], $row['lastname'], $row['email'], $row['created_at']));
            }

            fclose($file);
        };

        return response()->stream($callback, 200, $headers);
    }

Next, go to the browser and access the URL, you will see the file is downloading to your computer.