Simple example of a Laravel Seeder class which seeds a table with data from a .csv file. Dependencies: parsecsv/php-parsecsv

create_csv_migration.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePropertiesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('properties', function (Blueprint $table) {
            $table->id();
            $table->tinyText('name');
            $table->tinyText('address');
            $table->unsignedInteger('price');
            $table->unsignedSmallInteger('bedrooms');
            $table->unsignedSmallInteger('bathrooms');
            $table->unsignedSmallInteger('garages');
            $table->unsignedSmallInteger('frontage');
            $table->tinyText('image');
            $table->boolean('special');
            $table->boolean('featured');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('properties');
    }
}

LaravelCsvSeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use ParseCsv\Csv;
use Illuminate\Support\Facades\Storage;

class PropertySeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        // retrieve file
        $csv = new Csv();
        $file = Storage::get('property-data.csv');
        $csv->parseFile($file);

        // add data to table
        $table = DB::table('properties');
        foreach ($csv->data as $index) {
            $table->insert([
                'name' => $index['name'],
                'address' => $index['address'],
                'price' => $index['price'],
                'bedrooms' => $index['bedrooms'],
                'bathrooms' => $index['bathrooms'],
                'garages' => $index['garages'],
                'frontage' => $index['frontage'],
                'image' => $index['image'],
                'special' => $index['special'],
                'featured' => $index['featured'],
            ]);
        }

    }
}