Here I will show you half-automatic example for bulk import, this is great for smaller database, up to 1000 categories/locations

I will show you Car Makers And Models import based on file: http://wpdirectorykit.com/uploads/car-models.xls