Is there a fast way to create many (sub-)categories?

Question

I am looking to create more than 100 categories, which would be way too cumbersome through the admin panel. Is there an alternative approach to this?

Answer 1

1.Connect to the database directly

2.export the qa_categories table from database to excel

3.update the excel with categories you need to add

4.import the excel to the qa_categories table  in database,without title of first line

Done,but be careful.