How to Import and Export CSV File in Laravel 7?
Import and Export CSV File in Laravel 7
Hey Artisans
Hope you are doing well. Today I am coming up with a new tutorial. Today in this Blogging series I will show you how to import and export CSV(comma separated value) file in Laravel 7. In this, series I will use the matwebsite / Excel Composer package for import and export work.
Import Export Files in Laravel in CSV Format!
These packages are great for exporting and importing the CSV(comma-separated value) file in the Laravel application. If you don’t know how to upload the export and import CSV file into the Laravel application. i am going to show right now step by step
I will show you how to export and import the CSV file and save it in the database as well.
Step 1 : Install Laravel 7 Project
Here, we need install Laravel 5.8 application using bellow command, So open your terminal OR command prompt and run bellow command:
composer create-project --prefer-dist laravel/laravel blog
Step 2: Install Maatwebsite Package
In this step we need to install Maatwebsite package via the Composer package manager, so one your terminal and fire bellow command:
composer require maatwebsite/excel
Now open config/app.php file and add service provider and alias.
config/app.php
'providers' => [ Maatwebsite\Excel\ExcelServiceProvider::class, ], 'aliases' => [ 'Excel' => Maatwebsite\Excel\Facades\Excel::class, ],
Step 3: Create Dummy Records
In this step, we have to require “users” table with some dummy records, so we can simply import and export. So first you have to run default migration that provided by laravel using following command:
php artisan migrate
After that we need to run following command to generate dummy users:
php artisan tinker factory(App\User::class, 20)->create();
Step 4: Add Routes
In this step, we need to create route of import export file. so open your “routes/web.php” file and add following route.
routes/web.php
Route::get('export', 'MyController@export')->name('export');
Route::get('importExportView', 'MyController@importExportView');
Route::post('import', 'MyController@import')->name('import');Step 5: Create Import Class
Now we need to create our import class to create import data in laravel application.
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
{
/**
* @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']),
]);
}
}Step 6: Create Export Class
Now we have to create our export class to create export data in laravel 7 application. so do it.
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 7: Create Controller
Now we have to create a controller to handle our declared route methods so that we can export and import CSV file in laravel 7 application.
app/Http/Controllers/MyController.php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Exports\UsersExport;
use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;
class MyController extends Controller
{
/**
* @return \Illuminate\Support\Collection
*/
public function importExportView()
{
return view('import');
}
/**
* @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 8: Create Blade File
In Last step, let’s create import.blade.php(resources/views/import.blade.php) for layout and we will write design code here and put following code:
resources/views/import.blade.php
<!DOCTYPE html>
<html>
<head>
<title>Laravel 5.8 Import Export Excel to database Example</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
</head>
<body>
<div class="container">
<div class="card bg-light mt-3">
<div class="card-header">
Laravel 5.8 Import Export Excel to database Example
</div>
<div class="card-body">
<form action="{{ route('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>
<a class="btn btn-warning" href="{{ route('export') }}">Export User Data</a>
</form>
</div>
</div>
</div>
</body>
</html> Hope it will work for you. Import and Export CSV File in Laravel 7
About Post Author
