PHPackages                             crockett/csv-seeder - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. crockett/csv-seeder

ActiveLibrary[PDF & Document Generation](/categories/documents)

crockett/csv-seeder
===================

Database seeding using CSV files

v1.1.1(10y ago)23173.5k↓21%9[2 PRs](https://github.com/andycrockett/laravel-csv-seeder/pulls)MITPHPPHP >=5.4.0

Since Feb 13Pushed 7y ago4 watchersCompare

[ Source](https://github.com/andycrockett/laravel-csv-seeder)[ Packagist](https://packagist.org/packages/crockett/csv-seeder)[ RSS](/packages/crockett-csv-seeder/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (1)Versions (10)Used By (0)

CSV Seeder
----------

[](#csv-seeder)

This package is intended to minimize the time and hassle spent importing CSV-based data. By making a few assumptions about your average CSV file, most users won't need any configuration to start seeding. For those that do, the available configuration options offer plenty of control over your CSV and how the data is inserted into the database.

### Overview

[](#overview)

- [Key Features](#key-features)
- [Installation](#installation)
- [Setup](#setup)
- [Usage Examples](#usage-examples)
    - [Mismatched Columns](#mismatched-columns)
    - [Insert Callbacks](#insert-callbacks)
- [Configuration](#configuration)
- [More Examples](#more-examples)
- [License](#license)

### Key Features

[](#key-features)

- Automatic mapping of CSV headers to the columns in your DB table.
- Aliases allow you to easily adjust a CSV column's name before it's inserted.
- Insert callbacks can be used to directly manipulate the CSV data before it's inserted.
- ORM support - when using a model, common attributes such as `$guarded` and `$fillable` are applied to the CSV.

Installation
------------

[](#installation)

Require this package in your composer.json and run `composer update`

```
"crockett/csv-seeder": "1.1.*"

```

Or just require it directly `composer require crockett/csv-seeder`

Setup
-----

[](#setup)

Here is a typical, single CSV seeder setup:

```
use Crockett\CsvSeeder\CsvSeeder;

class UsersTableSeeder extends CsvSeeder {

    public function __construct()
    {
        $this->filename = base_path('path/to/csv/users.csv');
        $this->table = 'users';
    }

    public function run()
    {
        // runs the seeder - alternatively, you could call $this->runSeeder(); for the same result
        parent::run();
    }
}

```

If you want to seed multiple CSVs in the same seeder, you could do something like this:

```
use Crockett\CsvSeeder\CsvSeeder;

class UsersTableSeeder extends CsvSeeder {

    public function run()
    {
        // seed the users table
        $this->filename = base_path('path/to/csv/users.csv');
        $this->table = 'users';
        parent::run();

        // seed the posts table
        $this->filename = base_path('path/to/csv/posts.csv');
        $this->table = 'posts';
        parent::run();
    }
}

```

As you can imagine, that can get messy very fast. Instead, you could use the helper method `seedFromCSV()` which is just a cleaner way to define your parameters and run the seeder in one go:

```
use Crockett\CsvSeeder\CsvSeeder;

class UsersTableSeeder extends CsvSeeder {

    public function run()
    {
        // seed the users table
        $this->seedFromCSV(base_path('path/to/users.csv'), 'users');

        // seed the posts table
        $this->seedFromCSV(base_path('path/to/posts.csv'), 'posts');
    }
}

```

Usage Examples
--------------

[](#usage-examples)

Given the following CSV and database table:

```
// users.csv
first_name,last_name,birth_date,password,favorite_color
Joe,Bar,2000-02-10,joePassword,red
Jim,Foo,1990-02-10,jimPassword,blue
Foo,Bar,1980-02-10,fooPassword,green

// users DB table
id, first_name, last_name, birth_date, password, favorite_color

```

You can run the seeder with no further setup:

```
$this->seedFromCSV(base_path('path/to/users.csv'), 'users');

```

You could even go a step further and omit the table name, as the CSV filename is the same as the table name. `CsvSeeder` will automatically try to resolve table and column names when they're not defined. If your CSV doesn't have a header row, you'll need to manually define a `$mapping`, as described in the next section.

### Mismatched columns

[](#mismatched-columns)

Unless you have complete control over your CSVs, the headers won't always match up with your DB columns. For example:

```
// users.csv
first_name, last_name, birth_date, password, favorite_color

// users DB table
id, first_name, last_name, age, password

```

In this case, you can define `$aliases` to rename the `birth_date` column to `age` before it's inserted:

```
$this->aliases = [
    'birth_date' => 'age'
];

$this->seedFromCSV(base_path('path/to/users.csv'), 'users');

```

Alternatively, you can manually define a `$mapping` for your CSV. A mapping allows you to explicitly choose and rename CSV columns. For example:

```
// users.csv
first_name, last_name, birth_date, password, favorite_color

// users DB table
id, first_name, last_name, color, password

// users seeder
$this->mapping = [
    0 => 'first_name',
    1 => 'last_name',
    3 => 'password',
    4 => 'color', // renamed from favorite_color
];

$this->seedFromCSV(base_path('path/to/users.csv'), 'users');

```

When you define a `$mapping`, a header row on your CSV is *not* required. In all other cases, `CsvSeeder` will assume your header row is the first row after `$offset_rows`.

### Insert Callbacks

[](#insert-callbacks)

In some cases, you'll need to manipulate the CSV data directly before it's inserted to the database. Using an `$insert_callback`, it couldn't be easier! Everytime a `$chunk` of rows is read from the CSV, it's passed to the default `$insert_callback`. All you need to do is define your own callback to override it.

Here we'll iterate over individual rows in the chunk and insert them using `Model::create()`:

```
$this->insert_callback = function ($chunk) {
    foreach($chunk as $row) {
        \App\User::create($row->toArray());
    }
};

$this->seedFromCSV(base_path('path/to/users.csv'), 'users');

```

Note, `$chunk` and `$row` are instances of `\Illuminate\Support\Collection` so you can easily manipulate and filter the rows and columns:

```
$this->insert_callback = function ($chunk) {
    foreach($chunk as $row) {
        $user_data = $row->only('first_name', 'last_name', 'password')->toArray();
        \App\User::create($user_data);
    }
};

$this->seedFromCSV(base_path('path/to/users.csv'), 'users');

```

Configuration
-------------

[](#configuration)

- `table` (string) Database table to insert into.
- `model` (string) Instead of a table name, you can pass an ORM model name.
- `model_guard` (bool true) - Respect model attributes such as $fillable and $guarded when resolving table columns with a model.
- `filename` (string) The path to the CSV file.
- `delimiter` (string ,) The CSV field delimiter.
- `offset_rows` (int 0) How many rows at the start of the CSV to skip.
- `skip_header_row` (bool true) Automatically skip the first row if it's determined to be the header. Setting `offset_rows` higher than 0 bypasses this.
- `mapping` (array) Associative array of csvColumnIndex => csvColumnName. See examples for details. If not specified, the first row (after offset) of the CSV will be used as the mapping.
- `aliases` (array) Associative array of csvColumnName => aliasColumnName. See examples for details. Allows for flexible CSV column names.
- `hashable` (string|array 'password') Hashes the specified field(s) using `bcrypt`. Useful if you are importing users and need their passwords hashed. Note: This is EXTREMELY SLOW, large CSVs will take time to import.
- `insert_chunk_size` (int 50) An insert callback will trigger every `insert_chunk_size` rows while reading the CSV.
- `insert_callback` (callable) - Override the default insert callback with your own. Callback must accept a `Collection` of rows ($chunk).
- `console_logs` (bool true) - Show messages in the console. (neglible performance impact)
- `write_logs` (bool false) - Write messages to logs. (recommended off for large CSVs)
- `disable_query_log` (bool true) - Disable the query log. (recommended on for large CSVs)
- `log_prefix` (string) - Customize the log messages

More Examples
-------------

[](#more-examples)

CSV with pipe delimited values:

```
public function __construct()
{
    $this->table = 'users';
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    $this->delimiter = '|';
}

```

Specifying which CSV columns to import:

```
public function __construct()
{
    $this->table = 'users';
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    $this->mapping = [
        0 => 'first_name',
        1 => 'last_name',
        5 => 'age',
    ];
}

```

Using a model instead of a table:

```
public function __construct()
{
    $this->model = \App\User::class;
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    // optionally, disable the $model_guard to ignore your model's guarded/fillable attributes
    $this->model_guard = false;
}

```

Skipping the first row of your CSV (Note: If the first row after the offset isn't the header row, a mapping must be defined):

```
public function __construct()
{
    $this->table = 'users';
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    $this->offset_rows = 1;
    $this->mapping = [
        0 => 'first_name',
        1 => 'last_name',
        2 => 'password',
    ];
}

```

Aliasing a CSV column:

```
public function __construct()
{
    $this->table = 'users';
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    $this->aliases = [
        'age' => 'date_of_birth',
    ];
}

```

Aliasing a CSV column defined in `$mapping`:

```
public function __construct()
{
    $this->table = 'users';
    $this->filename = base_path('database/seeds/csvs/your_csv.csv');
    $this->mapping = [
        0 => 'first_name',
        1 => 'last_name',
        5 => 'birth_date', // in the CSV file, this column is named 'age'
    ];
    $this->aliases = [
        'birth_date' => 'date_of_birth',
    ];
}

```

Check out the source of `Crockett\CsvSeeder\CsvSeeder` for more complete information about the available methods.

License
-------

[](#license)

CsvSeeder is open-sourced software licensed under the [MIT license](http://opensource.org/licenses/MIT)

###  Health Score

40

—

FairBetter than 88% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity43

Moderate usage in the ecosystem

Community19

Small or concentrated contributor base

Maturity64

Established project with proven stability

 Bus Factor1

Top contributor holds 57.6% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~91 days

Recently: every ~64 days

Total

9

Last Release

3749d ago

PHP version history (2 changes)v1.0PHP >=5.3.0

v1.1.0PHP >=5.4.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/71c959d0586ddda35d33e6b621619effacbf38fea7bd7a96739f34d6a40847ea?d=identicon)[andycrockett](/maintainers/andycrockett)

---

Top Contributors

[![Flynsarmy](https://avatars.githubusercontent.com/u/334808?v=4)](https://github.com/Flynsarmy "Flynsarmy (19 commits)")[![andycrockett](https://avatars.githubusercontent.com/u/118585780?v=4)](https://github.com/andycrockett "andycrockett (5 commits)")[![mauthi](https://avatars.githubusercontent.com/u/7204559?v=4)](https://github.com/mauthi "mauthi (3 commits)")[![teodortalov](https://avatars.githubusercontent.com/u/2781820?v=4)](https://github.com/teodortalov "teodortalov (2 commits)")[![kvn1234](https://avatars.githubusercontent.com/u/5875166?v=4)](https://github.com/kvn1234 "kvn1234 (1 commits)")[![jackfruh](https://avatars.githubusercontent.com/u/334880?v=4)](https://github.com/jackfruh "jackfruh (1 commits)")[![slakbal](https://avatars.githubusercontent.com/u/4387265?v=4)](https://github.com/slakbal "slakbal (1 commits)")[![fabiosato](https://avatars.githubusercontent.com/u/607586?v=4)](https://github.com/fabiosato "fabiosato (1 commits)")

---

Tags

laravelcsvseedingseederseedseeds

### Embed Badge

![Health badge](/badges/crockett-csv-seeder/health.svg)

```
[![Health](https://phpackages.com/badges/crockett-csv-seeder/health.svg)](https://phpackages.com/packages/crockett-csv-seeder)
```

###  Alternatives

[bfinlay/laravel-excel-seeder

Seed the database with Laravel using Excel, XLSX, XLS, CSV, ODS, Gnumeric, XML, HTML, SLK files

3944.4k](/packages/bfinlay-laravel-excel-seeder)[jeroenzwart/laravel-csv-seeder

Seed the database with Laravel using CSV files

97395.6k2](/packages/jeroenzwart-laravel-csv-seeder)[flynsarmy/csv-seeder

Allows seeding of the database with CSV files

2561.6M1](/packages/flynsarmy-csv-seeder)[initred/laravel-tabula

laravel-tabula is a tool for liberating data tables trapped inside PDF files for the Laravel framework.

1418.6k](/packages/initred-laravel-tabula)[nilgems/laravel-textract

A Laravel package to extract text from files like DOC, XL, Image, Pdf and more. I've developed this package by inspiring "npm textract".

195.2k](/packages/nilgems-laravel-textract)[rgilyov/laravel-csv-importer

Easy and reliable way to import, parse, validate and transform your csv files with laravel

166.1k](/packages/rgilyov-laravel-csv-importer)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)