# How to use import for classification ## Before importing A prerequisite when classifying entities using import is having an excel spreadsheet with the data organized in named columns. For this tutorial we have a made three simple spreadsheets containing jackets that already exist as [products](https://docs.struct.com/fundamental-concepts/data-management), that we want to insert into another [category](https://docs.struct.com/fundamental-concepts/data-model).

Spreadsheet to classify using identifier

In this case we are importing to a [category](https://docs.struct.com/fundamental-concepts/data-model) with full path = 'Clothing > Men > Jackets', id = 186 and identifier = 'Men-Jackets', meaning all of these imports are interchangeable and will classify the [products](https://docs.struct.com/fundamental-concepts/data-management) in the same [category](https://docs.struct.com/fundamental-concepts/data-model). ## Starting the import To start importing you choose the excel spreadsheet with the data you want to import, in this tutorial the spreadsheet is called "ClothingForImport.xlsx". Next you need to choose the correct Import type. When importing [categories](https://docs.struct.com/fundamental-concepts/data-model), [products, variants](https://docs.struct.com/fundamental-concepts/data-management), variant groups or [global lists](https://docs.struct.com/tutorials/guides/how-to-use-import/broken-reference) the 'General Excel Import' type is used. While it is possible to include media assets when importing, this will not be covered in this guide. For this reason we leave 'Upload assets' unticked and 'Select media folder' empty.

Having chosen the correct file and import type you can click the "Start upload"-button to start the import. ## Mapping your data Having clicked the "Start upload"-button you are presented with a new page. This is where you will map your excel columns to data fields on entities. In this guide we are classifying [products](https://docs.struct.com/fundamental-concepts/data-management), so we choose 'Products' in the 'Entity type' dropdown.

We choose Name (en-GB) as the key, as that is the column that will map our import to existing [products](https://docs.struct.com/fundamental-concepts/data-management). Now in this tutorial we are showcasing the three ways to map [products](https://docs.struct.com/fundamental-concepts/data-management) to [categories](https://docs.struct.com/fundamental-concepts/data-model) through import. This is done by mapping to the three different fields: * Import classifications (Id) * Import classifications (Full path) * Import classifications (ClothingCategoryId) These fields are built with the following syntax: \[Catalogue name] classifications \[Expected identifier] So for 'Import classifications (Id)' we import to the [catalogue](https://docs.struct.com/fundamental-concepts/data-model) 'Import' and then we map to a [category](https://docs.struct.com/fundamental-concepts/data-model) with the category's internal id. 'Full path' means we map to the full path of the [category](https://docs.struct.com/fundamental-concepts/data-model) we want to classify the [product](https://docs.struct.com/fundamental-concepts/data-management) in. The full path is build of the display names of the [category](https://docs.struct.com/fundamental-concepts/data-model) to insert into and its ancestors seperated by " > ". E.g. "Clothing > Men > Jackets" And finally 'ClothingCategoryId' is an [identifier](https://docs.struct.com/tutorials/guides/how-to-use-import/broken-reference) we have created on the Import [catalogue](https://docs.struct.com/fundamental-concepts/data-model).

## Approve changes At this point you are shown a 'Review changes'-page showing the new classification(s) that has been added to the entities. The classification on the 'Review changes'-page is always shown as the full path.

Having reviewed the changes you can choose to approve the changes you are satisfied with. Only approved records will be commited. When you have approved the records you want to keep, click the "Commit Import"-button in the bottom-right corner to finalize the import.