How to create 450 categories in wp

I am having trouble to find a way for how to add categories for all the products.

I have Apple, Samsung, Sony, Xiaomi, Huawei categories and each of there needs subcategories which will stand for models, and also specific part.

example of category tree:
Apple>Iphone 6s>Iphone 6s battery
Apple>Iphone 6s>Iphone 6s replacement screen>
Apple>Iphone 8>Iphone 8 battery
etc

All the products needs to be in separated category so I can show correct item under correct menu item and no other Iphone stuff, only the battery for example.

How do I create 500+ categories which will represent all the items we have got?

I was thinking to export existing database and edit in text editor and write all the categories there as it would be simpler then using category manager inside WordPress cpanel which is very bad for this, as I am getting lost of what is in there and what isn’t.

Do you think it will work this way? Or what do you suggest?
Thanks!

You can try using BulkPress. It allows you to create hundreds of categories very easily. Follow these steps:

1. Install and activate the plugin.
2. In the left side bar, hover your cursor on Bulkpress. Then click
   on Terms.
3. A new page will appear. In Taxonomy field, choose Category.
4. Insert your Categories in the Terms field.
5. Choose your desired Parent, if required.
6. Finally, click on the Add Terms button.