Importing large CSV files in MySQL using Laravel - TechvBlogs

Importing large CSV files in MySQL using Laravel

This article will show you how to import a large number of records from a CSV file into a Laravel application using a database seeder.

Suresh Ramani - Author - TechvBlogs
Suresh Ramani

1 year ago

TechvBlogs - Google News

This article will show you how to import a large number of records from a CSV file into a Laravel Application using a database seeder.

When we have thousands or millions of records or CSV files that we want to store in our database, We frequently use cron or queue jobs. We can use the database seeder to import the records if we only want to import the CSV file once.

Because the file is large and the application cannot handle multiple requests at once, it displays the maximum time execution when we use the import functionality to store large amounts of data. So We've added a fantastic example code for inserting a large CSV file into a database using a laravel application in a matter of minutes or seconds.

Importing large CSV files in MySQL using Laravel

Step 1: Install Laravel App

 Installing a fresh new laravel application, so head over to the terminal, type the command, and create a new laravel app.

composer create-project --prefer-dist laravel/laravel large-csv-laravel

or, if you have installed the Laravel Installer as a global composer dependency:

laravel new large-csv-laravel

Step 2: Configure Database Detail

Enter your database login information, including the database name, username, and password, after opening the .env file:


Step 3: Create Migration and Model

The next step is to use the terminal to run the following command to create the model and migration file:

php artisan make:model Product -m

add the following code to the migration file:

public function up()
    Schema::create('products', function (Blueprint $table) {

Open the command prompt and type the following command to create the table in the database:

php artisan migrate

Add the following code into app/Models/Product.php:

namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
    use HasFactory;
    protected $fillable = ['name', 'description'];

Step 4: Create a Database Seeder

To create a seeder file for quickly uploading a massive CSV file into the database, run the following command first:

php artisan make:seeder ProductSeeder

Update the code immediately so that long CSV files may be imported with ease by Laravel apps. The following code has to be included in your database\seeders\CommunitySeeder.php file:


  namespace Database\Seeders;

  use Illuminate\Database\Seeder;
  use App\Models\Product;
  use Illuminate\Support\Facades\DB;
  use Illuminate\Support\LazyCollection;

  class ProductSeeder extends Seeder 
  * Run the database seeds.
  * @return void
  public function run()
    LazyCollection::make(function () {
      $handle = fopen(public_path("products.csv"), 'r');
      while (($line = fgetcsv($handle, 4096)) !== false) {
        $dataString = implode(", ", $line);
        $row = explode(';', $dataString);
        yield $row;

    ->each(function (LazyCollection $chunk) {
      $records = $chunk->map(function ($row) {
        return [
            "name" => $row[0],
            "description" => $row[1],

Step 5: Run Database Seeder

Run the following command to run Database seeder:

php artisan db:seed --class=ProductSeeder

Importing large CSV files in MySQL using Laravel and maatwebsite/Laravel-Excel

If you are using Laravel Excel you may use the chunking feature. Use the following code to import chunks into the database via Chunk Reading:

Excel::filter('chunk')->load(database_path('seeds/csv/products.csv'))->chunk(250, function($results) {
    foreach ($results as $row) {
            'name' => $row->name,
            // other fields

If you are using the Import class in your Laravel App through Laravel Excel then you can use the following methods to import data to the database:


namespace App\Imports;

use App\Models\Product;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithChunkReading;

class ProductImport implements ToModel, WithChunkReading
    public function model(array $row)
        return new Product([
            'name' => $row[0],
            'description' => $row[1],
    public function chunkSize(): int
        return 1000;

Thank you for reading this article.

Read Also: Laravel 9 Import Export Excel & CSV File Example

If you want to manage your VPS / VM Server without touching the command line go and  Checkout this linkServerAvatar allows you to quickly set up WordPress or Custom PHP websites on VPS / VM in a  matter of minutes.  You can host multiple websites on a single VPS / VM, configure SSL certificates, and monitor the health of your server without ever touching the command line interface.

Comments (2)

Tester Tester 11 months ago

Can't use for large file

Jack Sparrow Jack Sparrow 1 year ago

Thank For The help !!


Note: All Input Fields are required.