---
description: >-
  https://www.itsolutionstuff.com/post/laravel-9-import-export-excel-and-csv-file-tutorialexample.html
---

# Laravel 9 Import Export Excel and CSV File Tutorial (ok)

## [I have face a problem to install maatwebsite/excel on laravel 8 | php 8?](https://stackoverflow.com/questions/67573930/i-have-face-a-problem-to-install-maatwebsite-excel-on-laravel-8-php-8) ( đã làm trên cmstest.com)

1. I just enable PHP `gd extension` from `php.ini` file
2. installing PHP package `PhpSpreadsheet`

```
delete composer.lock (json) then run below command

composer require phpoffice/phpspreadsheet

composer require maatwebsite/excel
```

Hello,

I am going to show you an example of laravel 9 import export excel. This tutorial will give you a simple example of laravel 9 import export csv. We will look at an example of import export csv file in laravel 9. This article will give you a simple example of laravel 9 import file excel.

we will use maatwebsite/excel composer package for import and export tasks. in this example, i will create a simple form for input where you can upload a csv file and create multiple users. Then I will create an export route that will download all users from the database in an excel file.

so, let's follow the below step to create the import and export function in laravel 9 application. you can export file with .csv, .xls and .xlsx file.

![](https://www.itsolutionstuff.com/upload/laravel-9-import-export-csv.png)

**Step 1: Install Laravel 9**

This step is not required; however, if you have not created the laravel app, then you may go ahead and execute the below command:

```
composer create-project laravel/laravel example-app
```

**Step 2: Install maatwebsite/excel Package**

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

```
composer require psr/simple-cache:^1.0 maatwebsite/excel
```

If, you are using less the laravel 9 versions then use bellow command:

```
composer require maatwebsite/excel
```

Read Also: [Laravel Maatwebsite Excel Set Background Color Example](https://www.itsolutionstuff.com/post/laravel-maatwebsite-set-background-color-of-column-exampleexample.html)

**Step 3: Create Dummy Records**

In this step, we will create some dummy records for users table, so we can export them with that users. so let's run bellow tinker command:

```
php artisan tinker  User::factory()->count(10)->create()
```

**Step 4: Create Import Class**

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

```
php artisan make:import UsersImport --model=User
```

app/Imports/UsersImport.php

```
<?php  namespace App\Imports;  use App\Models\User;use Maatwebsite\Excel\Concerns\ToModel;use Maatwebsite\Excel\Concerns\WithHeadingRow;use Hash;  class UsersImport implements ToModel, WithHeadingRow{    /**    * @param array $row    *    * @return \Illuminate\Database\Eloquent\Model|null    */    public function model(array $row)    {        return new User([            'name'     => $row['name'],            'email'    => $row['email'],             'password' => Hash::make($row['password']),        ]);    }}
```

You can download demo csv file from here: [Demo CSV File](https://www.itsolutionstuff.com/upload/empty.csv).

**Step 5: Create Export Class**

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

```
php artisan make:export UsersExport --model=User
```

app/Exports/UsersExport.php

```
<?php  namespace App\Exports;  use App\Models\User;use Maatwebsite\Excel\Concerns\FromCollection;use Maatwebsite\Excel\Concerns\WithHeadings;  class UsersExport implements FromCollection, WithHeadings{    /**    * @return \Illuminate\Support\Collection    */    public function collection()    {        return User::select("id", "name", "email")->get();    }      /**     * Write code on Method     *     * @return response()     */    public function headings(): array    {        return ["ID", "Name", "Email"];    }}
```

**Step 6: Create Controller**

In this step, we will create UserController with index(), export() and import() method. so first let's create controller by following command and update code on it.

```
php artisan make:controller UserController
```

Now, update code on UserController file.

app/Http/Controllers/UserController.php

```
<?php  namespace App\Http\Controllers;  use Illuminate\Http\Request;use App\Exports\UsersExport;use App\Imports\UsersImport;use Maatwebsite\Excel\Facades\Excel;use App\Models\User;  class UserController extends Controller{    /**    * @return \Illuminate\Support\Collection    */    public function index()    {        $users = User::get();          return view('users', compact('users'));    }            /**    * @return \Illuminate\Support\Collection    */    public function export()     {        return Excel::download(new UsersExport, 'users.xlsx');    }           /**    * @return \Illuminate\Support\Collection    */    public function import()     {        Excel::import(new UsersImport,request()->file('file'));                       return back();    }}
```

**Step 7: Create Routes**

In this step, we need to create routes for list of users, import users and export users. so open your "routes/web.php" file and add following route.

routes/web.php

```
<?php  use Illuminate\Support\Facades\Route;  use App\Http\Controllers\UserController;  /*|--------------------------------------------------------------------------| Web Routes|--------------------------------------------------------------------------|| Here is where you can register web routes for your application. These| routes are loaded by the RouteServiceProvider within a group which| contains the "web" middleware group. Now create something great!|*/ Route::controller(UserController::class)->group(function(){    Route::get('users', 'index');    Route::get('users-export', 'export')->name('users.export');    Route::post('users-import', 'import')->name('users.import');});
```

**Step 8: Create Blade File**

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

resources/views/users.blade.php

```
<!DOCTYPE html><html><head>    <title>Laravel 9 Import Export Excel to Database Example - ItSolutionStuff.com</title>    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet"></head><body>     <div class="container">    <div class="card bg-light mt-3">        <div class="card-header">            Laravel 9 Import Export Excel to Database Example - ItSolutionStuff.com        </div>        <div class="card-body">            <form action="{{ route('users.import') }}" method="POST" enctype="multipart/form-data">                @csrf                <input type="file" name="file" class="form-control">                <br>                <button class="btn btn-success">Import User Data</button>            </form>              <table class="table table-bordered mt-3">                <tr>                    <th colspan="3">                        List Of Users                        <a class="btn btn-warning float-end" href="{{ route('users.export') }}">Export User Data</a>                    </th>                </tr>                <tr>                    <th>ID</th>                    <th>Name</th>                    <th>Email</th>                </tr>                @foreach($users as $user)                <tr>                    <td>{{ $user->id }}</td>                    <td>{{ $user->name }}</td>                    <td>{{ $user->email }}</td>                </tr>                @endforeach            </table>          </div>    </div></div>     </body></html>
```

**Run Laravel App:**

All the required steps have been done, now you have to type the given below command and hit enter to run the Laravel app:

```
php artisan serve
```

Now, Go to your web browser, type the given URL and view the app output:

Read Also: [Laravel 9 PDF | Laravel 9 Generate PDF File using DomPDF](https://www.itsolutionstuff.com/post/laravel-9-pdf-laravel-9-generate-pdf-file-using-dompdfexample.html)

```
http://localhost:8000/users
```

Output:

![](https://www.itsolutionstuff.com/upload/laravel-9-import-export-csv-2.png)

I hope it can help you...
