How to Import and Export CSV File in Laravel

import export excel or csv from the database is a primary requirement for the admin project. In this tutorial, i will show you how to import csv or excel file and export csv or excel files using maatwebsite/excel version 3 in laravel 7 application.

In this export excel or csv from database tutorial, I will simple create import data to csv, xls file and also we can import data to the database using csv files in laravel 7. So if you do not how how to export and import file in laravel then this example is for you.

Step 1 : Install Laravel 8 Project

Here, we need to install Laravel 7 application using the bellow command, So open your terminal OR command prompt and run the bellow command:

composer create-project --prefer-dist laravel/laravel blog

Step 2: Install Maatwebsite Package

In this step we need to install Maat website package via the Composer package manager, so one your terminal and fire the bellow command:

composer require maatwebsite/excel

Now open the config/app.php file and add the service provider and alias.

config/app.php

'providers' => [

	....

	Maatwebsite\Excel\ExcelServiceProvider::class,

],

'aliases' => [

	....

	'Excel' => Maatwebsite\Excel\Facades\Excel::class,

],

Step 3: Add Routes

Paste the below code to

routes/web.php

Route::get('export', 'DemoController@export')->name('export');
Route::get('importExportView', 'DemoController@importExportView');
Route::post('import', 'DemoController@import')->name('import');

Step 4: Create Import Class

In maatwebsite 3 versions provide a way to build an import class and we have to use it in the controller. So it would be a great way to create a new Import class. So you have to run the following command and change the following code on that file:

php artisan make:import UsersImport --model=User

app/Imports/UsersImport.php

namespace App\Imports;
   
use App\User;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
    
class UsersImport implements ToModel, WithHeadingRow
{
    public function model(array $row)
    {
        return new User([
            'name'     => $row['name'],
            'email'    => $row['email'], 
            'password' => \Hash::make($row['password']),
        ]);
    }
}

Step 5: Create Export Class

maatwebsite 3 versions provide a way to build an export class and we have to use it in the controller. So it would be a great way to create a new Export class. So you have to run the following command and change the following code on that file:

php artisan make:export UsersExport --model=User

app/Exports/UsersExport.php

namespace App\Exports;
  
use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
  
class UsersExport implements FromCollection
{
   
    public function collection()
    {
        return User::all();
    }
}

Step 6: Create Controller

In this step, now we should create a new controller as MyController. this controller will manage all importExportView, export and import requests and return responses, so put the below content in the controller file:

php artisan make:controller DemoController

app/Http/ControllersDemoController.php

namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Exports\UsersExport;
use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;
  
class DemoController extends Controller
{
    
    public function importExportView()
    {
       return view('import');
    }
   
    public function export() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
   
    public function import() 
    {
        Excel::import(new UsersImport,request()->file('file'));
           
        return redirect()->back();
    }
}

Step 7:  Create Blade File

In the Last step, let's create import.blade.php(resources/views/import.blade.php) for layout and we will write design code here and put the following code:

Read also : Send Notification to Inactive User with Task Scheduling in Laravel using Custom Command

resources/views/import.blade.php

Hope it will work for you. If you face any problem, then leave a comment.