laravel-model-export

A lightweight Laravel package to export Eloquent model data to CSV, excel, with support for low-memory, lazy exports and a clean API via an Exportable trait and query macro.

📦 Features

Export model data to CSV using a simple method call
Export via query chaining (User::where(...)->exportToExcel())
Low memory usage via lazyById()
Customizable export paths

🚀 Installation

composer require php-dominicana/laravel-model-export

🛠 Usage

Export all records (static call)

User::exportToExcel(); // uses default filename and $exportable columns

Export filtered data via query

User::where('active', true)
    ->orderBy('name')
    ->exportToExcel(); // exports only active users

Export to custom path

User::exportToExcel(storage_path('exports/users.csv'));

📁 File Output

Files are exported to /storage/app by default unless a custom path is provided.
Filenames follow this format: export_ModelName_TIMESTAMP.csv

Export to browser

User::streamDownload();

Export to JSON

User::exportToJson();

Export to PDF

User::exportToPDF();

Customize the PDF View (Optional)

To let users override your default PDF view, instruct them to publish it:

php artisan vendor:publish --tag=model-export-views

🧠 How It Works

The Exportable trait adds a static exportToExcel() method for convenience.
A macro is registered on Eloquent\Builder so that you can chain ->exportToExcel() on queries.
Under the hood, Spatie’s SimpleExcelWriter handles the CSV generation.
Memory-efficient thanks to Laravel’s lazyById().

php-dominicana/laravel-model-export

Development

Runtime