How to Import Excel File to Database with Mapping Laravel

Importing data from Excel files to databases is a common requirement for many web applications. Laravel, a popular PHP framework, provides an easy and efficient way to import Excel files with mapping to databases. In this guide, we’ll walk through the steps to import an Excel file to a database with mapping in Laravel.

Steps to Import Excel File to Database with Mapping in Laravel:

1. Install the “maatwebsite/excel” package via Composer.
2. Create a new Laravel controller and add code to import the Excel file.
3. Create a new import class to handle the mapping of the Excel file columns to the database table columns.
4. Create a new route in the routes/web.php file to handle the import.
5. Create a form in your view file to allow the user to upload the Excel file.

First, install the “maatwebsite/excel” package via Composer by running the following command in your terminal:

composer require maatwebsite/excel

Next, create a new Laravel controller by running the following command:

php artisan make:controller ExcelController

Open the ExcelController.php file and add the following code to it:

use Maatwebsite\Excel\Facades\Excel;
use App\Imports\YourImportClass;

class ExcelController extends Controller
{
    public function import()
    {
        Excel::import(new YourImportClass, request()->file('file'));

        return redirect()->back();
    }
}

Here, replace “YourImportClass” with the name of your import class that you will create in the next step.

Create a new import class by running the following command:

php artisan make:import YourImportClass

Open the YourImportClass.php file and add the following code to it:

namespace App\Imports;

use Maatwebsite\Excel\Concerns\ToModel;
use App\Models\YourModelClass;

class YourImportClass implements ToModel
{
    public function model(array $row)
    {
        return new YourModelClass([
            'column1' => $row[0],
            'column2' => $row[1],
            'column3' => $row[2],
            // add more columns here as needed
        ]);
    }
}

Here, replace “YourModelClass” with the name of your model class and add the appropriate columns and their mapping as per your Excel file.

Create a new route in your routes/web.php file to handle the import:

Route::post('/import', 'ExcelController@import')->name('import');

Create a form in your view file to allow the user to upload the Excel file:

<form method="post" action="{{ route('import') }}" enctype="multipart/form-data">
    @csrf
    &lt;div class="form-group">
        &lt;label for="file">Select Excel File&lt;/label>
        &lt;input type="file" name="file" class="form-control">
    &lt;/div>
    &lt;button type="submit" class="btn btn-primary">Import&lt;/button>
</form>

Here, replace the “form-group” and “btn” classes with your preferred CSS classes.

That’s it! Now, when the user submits the form, the Excel file will be imported to the database with the specified mapping using Laravel.

Conclusion:

Importing Excel files to databases is a crucial feature for many web applications. Laravel provides an easy and efficient way to accomplish this task with its powerful tools and packages. By following the above steps, you can easily import an Excel file to a database with mapping in Laravel. With this feature, you can streamline your data management process and improve the efficiency of your web application.

Recent Post

• How to Implement PHP PSR in Your Laravel Project
• Exploring Advanced Subdomain Routing Techniques in Laravel: A Complete Tutorial
• How to Simplify Laravel Development with Docker
• Laravel Best Practices: Limiting env Calls to Config Files for Better Performance and Stability
• php artisan make: model, add additional flags to include extra features
• Laravel Request Lifecycle

Follow Laravel.Tips on Instagram

If you found this post informative, we encourage you to share it with your colleagues. We value your feedback and would love to hear your thoughts on our blog and social media posts across platforms such as Instagram, Facebook, LinkedIn, and Twitter.