Cheers to Lewis and Excel Imports for Backpack!

Hey there!πŸ‘‹ Today, we're are not just diving into the code tutorial but taking a moment to appreciate @redsquirrelstudio (aka Lewis)....

Karan Datwani
Karan Datwani

Hey there!πŸ‘‹ Today, we're are not just diving into the code tutorial but taking a moment to appreciate @redsquirrelstudio (aka Lewis). He has dropped a beautiful "Import Operation" package for Backpack!

This package not only imports Excel but does so with a fancy GUI for column mapping.πŸš€


A Round of Applause for Lewis πŸŽ‰

Let's start this article by giving a big thanks to Lewis! You’ve made lives easier, and for that, we owe you a virtual high-five! πŸ™Œ and a cup of coffee for your incredible contribution.

"With great package comes great responsibility."

Lewis, you’ve embraced that responsibility. You crafted a tool that works and does so with style. The GUI for column mapping? Pure genius. It’s like you knew exactly what we needed before we even knew it ourselves. Kudos!

Let's Get Down to Business: How to Use Import Operation πŸš€


  1. Install the Package:
composer require redsquirrelstudio/laravel-backpack-import-operation
  1. Publish the config & run the migration:
php artisan vendor:publish --tag=laravel-backpack-import-operation-config
php artisan vendor:publish --tag=laravel-backpack-import-operation-migrations
php artisan migrate


  1. Add ImportOperation to your CRUDController;
class ExampleCrudController extends CrudController
    use \Backpack\CRUD\app\Http\Controllers\Operations\ListOperation;    
    use \Backpack\CRUD\app\Http\Controllers\Operations\ShowOperation;
+   use \RedSquirrelStudio\LaravelBackpackImportOperation\ImportOperation;
  1. Configure the columns inside setupImportOperation
protected function setupImportOperation()
        'name' => 'id',        
        'type' => 'number',
        'name' => 'name',
        'type' => 'text',
        'name' => 'gender',
        'type' => 'array',        
        'options' => [ 'male' => 'male', 'female' => 'female',]
        'name' => 'dob',
        'label' => 'Birthday',
        'type' => 'date',
        'name' => 'contacts',
        'type' => 'array',        
        'multiple' => true,
        'options' => 'any'

Boom! You have a working operation to import spreadsheets. No new steps! Simple as other Backpack operations.πŸ§‘β€πŸ’»

Supported columns & customizations

Currently, it comes with Text, Number, Boolean, Date and Array columns. The good thing is you're free to add your custom columns.

You are also free to customize the import process by creating your Custom Import Classes.

This is cool😎 right?

Wait! There's more!... It offers a good set of prebuilt methods to make it fit in your needs:

  • Validating your imports works similarly to validating a create or update method. This validates each row while importing and skips them if they don't pass.
  • Attach an Example File for your user to download. An example spreadsheet with data that you would expect them to upload.
  • Sometimes, you may not want the user to map their columns, or need a fast import. In these cases, you can disable the user mapping step.
  • After completing an import, the uploaded spreadsheet remains in storage by default. Delete the uploaded Excel after import to free up storage.
  • It's better to queue larger imports in the background. This way, the user won't have to wait for the import to happen when they press a button.

To know more in detail, visit the package repo.

A Shoutout to the Backpack Community πŸŽ’

Now, let's shift the spotlight to the Backpack community. We all know that behind every great software package is an even greater community. So, a big shoutout to the Backpack developers for rolling out awesome packages.

If you've got your secret sauce – your custom packages and hacks – we want to hear from you! Share your packages, and tell us your stories. It may get listed on the Backpack add-on page.

Your package stories make us do the happy dance! πŸ’ƒπŸ•Ί

How to create a Backpack add-ons?

It's the express lane to becoming a Backpack maestro. The only limit is your imagination (and maybe a bit of coffee).

In Conclusion: Happy Backpacking! πŸŽ’

So there you have it! Import Operation has landed. Lewis is our hero, and the Backpack community is the heartbeat of our coding adventures. Keep crafting, keep coding, and most importantly, keep smiling.😊

The Laravel journey is an adventure, and each package, each line of code, adds a little sparkle to the magic.

P.S. Lewis, keep up the good work!

Want to receive more articles like this?

Subscribe to our "Article Digest". We'll send you a list of the new articles, every week, month or quarter - your choice.

Reactions & Comments

What do you think about this?

I am excited to use this feature in upcoming projects. Cheers to Lewis!!
Cheers Lewis for this and your Export plugin too :)

Latest Articles

Wondering what our community has been up to?