Set up your spreadsheet
To add multiple categories, you just:
- Use the category, sub-category (and so on, depending on how deep you need to go) columns to specify what category path a product should be in
- Insert new lines in the category fields to add additional categories.
- The key is though that they must line up
- The category paths that go deepest, must go first - e.g. if the first one is 2 subcategories deep, the second one is 3 deep then the second one with 3 categories deep one must go first & so on.
Note that pressing
Alt + Enter allows you to add a new line in the same cell.
E.g.
![](https://lh6.googleusercontent.com/jh4WAeensP85Ud723oGXdhdIsrFhBEIVY9rDzeliNNSdlPUaT9YYNVmpP-1uMttj1fEN1nvFPQcviFQAKFhTnllPNugOFSDeWQNCkh7rWh6wsfqx9H8wbINQzZFXd5fW43F24JmtLtLKZ_NpGwauW0hz3NnxCbafSoa5IO2J-7i_sxL04o__OUU6eoae)
It is important Categories are ordered correctly. Changing the order will result in a bad import and unintended categories. The system will ignore the empty lines and align the fields. In this example. We ended up with a category named Sale/ Active Wear
![](https://lh4.googleusercontent.com/kyNWMjt6EABowqOLILZMNwakRyZc3xVLGp538UbBdlUe-wVi0aejs11g-1H4hsLeVR3n2pECrgf5cMN1VIq1kCqeRHPNuSTcO373FW4SUQP21b7bMXOLrQ7ZGGACELNCtdIZEp5VNjwx60_-kj2-Ord0kxCSGFVLS12O0jHOE5-1EG7ZGv7_1f6IC1GG)