Navigate to Members - Member Categories select Import Categories:

In the pop-up window select the CSV file to use:

You can find the Category Import template attached to this article. 

To learn more about Member Categories, please visit the following video:

Edit Member Categories - Brilliant Directories

IMPORTANT NOTE: All members can be listed in 1 Top Level / Main Category and multiple Sub Categories