Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

community creator

How to import data from excel to your database table in Laravel

Chinweuba Elijah Azubuike


I always use this functionality every time I create a POS (point of sale) application because the products to be stored are just too many to be entered one after the other. So in this shot, I will teach you how to import data from an excel sheet and store them into your database table. We would be using the Fast-Excel package.

Package installation

Run the composer command:

composer require rap2hpoutre/fast-excel

After installation, you can implement it in any controller you want, or you can create one like so:

php artisan make:controller ImportController



namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Rap2hpoutre\FastExcel\FastExcel;
use App\User;
use App\Http\Controllers\Controller;

class ImportController extends Controller
   public function index(){
   $users = (new FastExcel)->import('file.xlsx', function ($line) {
    return User::create([
        'name' => $line['Name'],
        'email' => $line['Email']


Import the use Rap2hpoutre\FastExcel\FastExcel; class

  • From the example above, we use the index() function to implement the data import.

  • We first instantiate the FastExcel then we chain the import() method, which receives two-parameters. The first parameter is the excel file you want to import and the second parameter is a callback function.

  • In our callback function, we pass the excel file where we get each column value and store it in the database.


The USER: is the table we are importing data to, therefore we call the create() method, which creates the new data in the database from the excel file (file.xlsx).


From the code above you will only see the result in your database.


community creator


Chinweuba Elijah Azubuike

View all Courses

Keep Exploring