How to import excel file in laravel 8

Import Laravel Excel

Import CSV Files into Laravel 8

Today I am Going To Explain to you how you can import Excel / CSV Files into Laravel.

I am going to use Tech-Admin Panel for this.

For importing excel files i am using Laravel Excel.

Step 1 - Installation

To Install the Laravel Excel Package via composer run command below.

composer require maatwebsite/excel

Next to export config file you need run command below.

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config

Step 2 - Create an Import Class inside `app/Imports`

Create Import Class by using artisan command

php artisan make:import UsersImport --model=User

Step 3 - Update UsersImport Class

In order use CSV/Excel Files with heading we have to implement WithHeadingRow, UsersImport Class will look like.

<?php

namespace App\Imports;

use App\Models\User;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class UsersImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new User([
            "first_name" => $row['first_name'],
            "last_name" => $row['last_name'],
            "email" => $row['email'],
            "mobile_number" => $row['mobile_number'],
            "role_id" => 2, // User Type User
            "status" => 1,
            "password" => Hash::make('password')
        ]);
    }
}

Step 4 - Handle Uploaded Excel/CSV File

public function uploadUsers(Request $request)
{
        Excel::import(new UsersImport, $request->file);

        return redirect()->route('users.index')->with('success', 'User Imported Successfully');
}

You can watch the explanation video for more clarity.

https://www.youtube.com/watch?v=-h2wpwATsXw

In Next part i will explain about Export Users.

Thank You for Reading!

Reach Out To me. Twitter Instagram YouTube

How to import excel CSV files into Laravel 8

Comments

More from this blog

How to insert Bulk Fake Data in Laravel 9 using Factory & Seeder.

Laravel Passwordless Login with Magic Link

Laravel Login with OTP

How to Login with USERNAME instead of Email in Laravel 9?

How to upload an Image In Laravel 9?

Import CSV Files into Laravel 8

Step 1 - Installation

Step 2 - Create an Import Class inside `app/Imports`

Step 3 - Update UsersImport Class

Step 4 - Handle Uploaded Excel/CSV File

Command Palette

Comments

More from this blog

Import CSV Files into Laravel 8

Step 1 - Installation

Step 2 - Create an Import Class inside app/Imports

Step 3 - Update UsersImport Class

Step 4 - Handle Uploaded Excel/CSV File

Step 2 - Create an Import Class inside `app/Imports`