This code is for Magento 1, it won’t work in Magento 2.
Sometime when you need to deal with import of lots of values for a multiple select/drop down attribute. Then manual data entry is not very convenient. The code below will allow you to put all your values into a single text file and import in seconds. First you will need to upload the source code below into a new file manufacturer_import.php in the Magento root directory.
The above code will import Manufacturers into the “manufacturer” attribute, but can be used on any drop-down or multiple select attribute configured in Magento, simply change “manufacturer” at the end of line 6 to the code of the attribute you wish to update.
Next step is to prepare and upload your list of manufactures in a simple text file, one value per line. Save the file as “import.txt”, and upload into Magento root directory, beside the above script.
Apple Banana Pear ...
Navigate to www.example.com/manufacturer_import.php and you sould see the import successful message.
Warning: Your browser is very out-of-date. You should upgrade to a better browser.