clock  Mon - Sun 8.00 AM - 8.00 PM
play store

How to export data in Excel using Laravel

writter  Hariom Prajapati
Date  02 Jul 2022
Language  Laravel
How to export data in Excel using Laravel

How to export data in Excel using Laravel

In this tutorial we will learn how to export  dynamic data in excel file with heading using laravel.

 If you do not know how to install laravel then click here to install laravel .


Step 1- Install Laravel Maatwebsite Excel

Open your CMD and just run this command to install this package.

composer require maatwebsite/excel


Step 2- Now,  go to config\app.php

Link installed package in app.php file

'providers' => [
'aliases' => [
   'Excel' => Maatwebsite\Excel\Facades\Excel::class,


Step 3- Run below command for publish the vendor file

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




Step 4 – Create  'users' table in database



User table data



Step 5- Create model for User 

php artisan make:model User


Then, run this command in CMD to generate UserExport.php file

php artisan make:export UserExport --model=User


Now this file has been created in the app folder, Generated file path is app/export/UserExport.php.


This is our UserExport.php file


namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
class UserExport implements FromCollection ,WithHeadings
    * @return \Illuminate\Support\Collection
    public function collection()
        return User::select('name', 'email', 'age')->get();
    public function headings(): array
        return [
            'Name', 'Email ID','Age'


step 6 – Create route 

Route::get('users_export', 'UserController@export');    


Step 7 – create   controller  

php artisan make:controller UserController



namespace App\Http\Controllers;
use App\Exports\UserExport;
class UserController extends Controller
    Function export(){
        return Excel::download(new UserExport(), 'users.xlsx');


Step 8 – run php artisan serve


Then, go to your browser and simply run the below url





Here users.xlsx file downloaded



Comments 0

Leave a comment

Coursera, Codeacademy, Udacity, W3Schools, Udemy, Alison, TheNewBoston, edX, P.S.Codewars,Freecodecamp, Managing technical debt blog, Scrimba, Codepen, Codepen/challenges, The Odin Project, htmlreference.​io, cssreference.​io, Frontend Mentor, Dev Challenges, MDN, Code Mentor, Coding Dojo, CSS Battle, Codier, Ace Frontend, Can I Use, CSS Tricks, 30 Seconds of Code,tutorialspoint, Neumorphism, Shaddows Brumm, Fancy Border Radius, Glow Generator, Clothoid Corners, Glassmorphism, Clipy, CSS Filters, Base64 Image, Quantity Queries, Animations, Cubic-Bezier, Keyframes, Wait Animate, Transition.Style, graphic design, web design, website design, website builder, web developer, web designer, webdesign, ecommerce website, web design company, website creator, website designer, responsive web design, web development company, best website design, web design software, web page design, build a website, web developer salary, design website, web design courses, how to design a website, web design inspiration, website layout, web designer salary, web application development, ecommerce website design, web agency, software development company, web design tutorial, web programming, design company, website design templates, what is web designing, web developer jobs, website developer, web design agency, freelance web developer, web design services, freelance web designer, graphic design websites, web solutions, ecommerce website development, free website design, web development courses, webdev, web developers, web development tools, website design services, developpeur web, web design london, website design ideas, web designing and programming, design a website, web design and development, web dev, web development services, homepage design, best designed websites, cheap website design, learn web design, web design templates, web design tools, web design jobs, website design inspiration, web design india, flash website, website developers, designer websites, website services, website design cost, good website design, site design, simple website design, cool website designs, modern website design, graphic designer websites, webcode, best web design software, website making, free web design software, mobile website design, learn web development, front end web developer, how to become a web developer, web developer portfolio, web development company in india, python web development, web development tutorial, website company, website design and development, web company, webdesigning, professional website design, affordable web design, best web design company, creative web design, top website designs, website design pricing, web developer tools, how to develop a website