I created a custom drop down attribute in magento 2 and i hundreds of options to add in the attribute. What is the best way to add in bulk, maybe using a csv file or using direct query.
Your best way is using Direct sql query.
You cant do within csv file to import multiple option of attribute because there are not native code for that using csv.
You have to refer below link to using sql query,
If issue solved, Click Kudos/Accept As Solutions.