How to Import Excel Data in Laravel and Insert into Database 

Hi, Maatwebsite/Excel package is not more include import options, that library has been change, you can solve this issue changing the package version in your composer.json file, put this: "maatwebsite/excel": "~2.1.0" in the require section on composer.json, then go to console terminal and type this: composer update !!! sorry my english please, am from Colombia, i don´t know much English!

@Karthick V use "maatwebsite/excel": "2.1.30",

same here need fix

how can you solve it ???

You don't need both foreach just one, use this code or comment your second foreach. I apologize for my english, I'm brazilian foreach($data->toArray() as $key => $value) { // foreach($value as $row) { $insert_data[] = array( 'CustomerName' => $row['customer_name'], 'Gender' => $row['gender'], 'Address' => $row['address'], 'City' => $row['city'], 'PostalCode' => $row['postal_code'], 'Country' => $row['country'] ); // } }

Follow this Guide bishrulhaq.com/posts/import-export-excel-to-database-in-laravel Note: load is removed in maatwebsite 3.0, So make sure you copy paste 2.1.3 from site then run composer update. cheers!

@@karlgarcia3039 Hello, I have 2.1 maatwebsite/excel and 5.8 laravel but I still get this error

@@kingrichardguevara4969 follow the post. copy paste the maatwebsite in composer.json under require and run composer update in you cmd. Foklow the blog step 3 carefully. It should work

i have same issue!!! Have you fixed that??

same. and not sound from plugin owner

@@vasagan100 version of excel package, use version 2 instead of version 3

Well, for those who have the same issue, I found the answer already. Here --> stackoverflow.com/questions/54304707/how-to-update-data-in-database-using-import-excel

You don't need both foreach just one, use this code or comment your second foreach. I apologize for my english, I'm brazilian foreach($data->toArray() as $key => $value) { // foreach($value as $row) { $insert_data[] = array( 'CustomerName' => $row['customer_name'], 'Gender' => $row['gender'], 'Address' => $row['address'], 'City' => $row['city'], 'PostalCode' => $row['postal_code'], 'Country' => $row['country'] ); // } }

​@@leandrosalles4799 This procedure is correct: ImportExcelController.php: foreach($data->toArray() as $key => $value) { $insert_data[] = array( 'CustomerName' => $value['customer_name'], 'Gender' => $value['gender'], 'Address' => $value['address'], 'City' => $value['city'], 'PostalCode' => $value['postal_code'], 'Country' => $value['country'] ); }

what version it is?

it is because the version of the excel package, don't use version 3, use version 2

its throw error undefine customer_name

missing customer_name from table just fix in db to solve

Why I still get erorrs after use your code? It say, 'undefined variabel:row'. I apologize for my english,