This package provides a simple but powerful way to read and write large CSV files using the power of Laravel's lazy collections.

You can install the package via composer:

composer require dutchcodingcompany/csv-collection

You may create a collection using the new keyword or the make method.

CsvCollection::make();

This gives you access to all Collection and Lazy Collection methods.

To open a file and load it's content into a new collection you may use the open method on the collection.

use DutchCodingCompany\CsvCollection\CsvCollection;

CsvCollection::make()
    ->open('path/to/file.csv')
    ->count();

To save the collection items to a file you may use the save method on the collection.

use DutchCodingCompany\CsvCollection\CsvCollection;

CsvCollection::make(static function () {
    yield [
        'key' => 'value',
    ];
})
    ->save('path/to/file.csv');

When exporting models a memory efficient method is to lazily iterate through the models and yield it's content.

use DutchCodingCompany\CsvCollection\CsvCollection;

CsvCollection::make(static function () {
    $models = Model::query()->lazy();
    
    foreach ($models as $model){
        yield $model->only([
            'id',
            //
        ]);
    }
})
    ->save('path/to/file.csv');

The following options are available to suit your needs:

• header, default: true
• delimiter, default: ,
• enclosure, default: "
• escape, default: \\

These options could be passed to the open and save methods, be set using the options method, or be set as the global default using the static defaults method.

The delimiter can be detected for a file by using the detectDelimiter method like this:

CsvCollection::detectDelimiter($path);

When using a header, lines will contain an associated array. Otherwise, lines will contain an indexed array.

// Without header
[
    0 => 'John',
    1 => 'Doe',
]

// With header
[
    'first_name' => 'John',
    'last_name' => 'Doe',
]

Note: When saving a collection to a file the keys of the first element in the collection will be used as the header.

composer test

• Bjorn Voesten
• Dutch Coding Company
• All contributors

The MIT License (MIT). Please see License File for more information.