{"section":"tutorials","requestedLocale":"en","requestedSlug":"importing-and-exporting-product-specifications-using-a-spreadsheet-beta","locale":"en","slug":"importing-and-exporting-product-specifications-using-a-spreadsheet-beta","path":"docs/en/tutorials/beta/catalog-beta/importing-and-exporting-product-specifications-using-a-spreadsheet-beta.md","branch":"main","content":"> ℹ️ This feature is in beta, which means that we are working to improve it. If you have any questions, please contact our [Support](https://supporticket.vtex.com/support).\n\nIn VTEX Admin, you can manage product specification import and export using a spreadsheet, as described in the sections below:\n\n- [Importing product specifications using a spreadsheet](#importing-product-specifications-using-a-spreadsheet)\n- [Exporting product specifications using a spreadsheet](#exporting-product-specifications-using-a-spreadsheet)\n- [Product specification spreadsheet fields](#product-specification-spreadsheet-fields)\n\n## Importing product specifications using a spreadsheet\n\nTo import product specifications using a spreadsheet, follow these steps:\n\n1. In the VTEX Admin, go to **Catalog > Products and SKUs**, or type [Products and SKUs](/en/docs/tutorials/products-and-skus) in the search barat the top of the page.\n2. At the top of the page, click `Import`.\n3. Click `Product specifications`.\n4. Add the spreadsheet with an `.xls` or `.xlsx` extension. You can drag and drop the file onto the designated area, or click the window to select the file locally.\n\n  > ⚠️ To get an import template, [export the product specifications](#exporting-product-specifications-using-a-spreadsheet).\n\n5. Once the file is uploaded, click `Import`.\n\n  > ❗ The import time will depend on the size of the data being processed. Leaving the page won't interrupt the operation.\n\nWhile the operation is running, a message will display indicating that the file is being processed. After the import is complete, the page will display \"Product specifications imported successfully\" and you'll receive a confirmation email.\n\n## Exporting product specifications using a spreadsheet\n\nTo export an `.xlsx` file with the product specification information, follow these steps:\n\n> ℹ️ The exported information corresponds to the fields described in the [Product specification spreadsheet fields](#product-specification-spreadsheet-fields) section.\n\n1. In the VTEX Admin, go to **Catalog > Products and SKUs**, or type [Products and SKUs](/en/docs/tutorials/products-and-skus) in the search bar at the top of the page.\n2. (Optional) If you want to export the product specifications of certain products, apply a [search](/en/docs/tutorials/products-and-skus#searching-for-a-product) or a [filter](/en/docs/tutorials/products-and-skus#filtering-products) as desired. This step isn't required to export all product specifications from your catalog.\n3. At the top of the page, click `Export`.\n4. Click `Product specifications`.\n\nWhile the export is running, a message will display indicating that the file is being processed. Leaving the page won't interrupt the operation. You can [track the export progress in the window](/en/docs/tutorials/importing-and-exporting-products-and-skus-using-a-spreadsheet-beta#tracking-export-process) displayed on the page.\n\nOnce the export is complete, you'll receive an email with a link to download the file. The download link is valid for 24 hours. After that, the link expires. You can also download the file from the window that opens on the page.\n\n## Product specification spreadsheet fields\n\nThe following table describes and includes an example for each field of the product specification import spreadsheet. Required fields are marked with an asterisk (*).\n\n| Field | Description | Example |\n| :--- | :--- | :--- |\n| Product ID* | Unique numeric code identifying the product. | 310117603 |\n| Product Name | Product name shown to customers during the browsing experience. | Cotton t-shirt |\n| Product Reference Code | Unique product reference code, used internally by the store. To complete this field, use a combination of letters and/or numbers. | shirtColor |\n| Brand ID | Numeric code that identifies the product [brand](/en/docs/tutorials/what-is-a-brand). This information can be found in VTEX Admin under **Catalog > Brands** or by using the [Get brand list](https://developers.vtex.com/docs/api-reference/catalog-api#get-/api/catalog_system/pvt/brand/list) endpoint. | 2000003 |\n| Brand | [Brand](/en/docs/tutorials/what-is-a-brand) name of the product. Once this field has a value, it can't be edited. | AOC |\n| Department ID | Numeric code that identifies the highest-level product category. | 1000014 |\n| Department | Name of the product's highest-level category. | Clothes |\n| Category ID | Unique number identifier for the product's lowest-level category. This information can be found in VTEX Admin under **Catalog > Categories** or by using the [Get category tree](https://developers.vtex.com/docs/api-reference/catalog-api#get-/api/catalog_system/pub/category/tree/-categoryLevels-) endpoint. | 1000014 |\n| Category | Name of the product's lowest-level category. | Tops |\n| Field ID | Numeric code that identifies the product specification field for the product. | 493 |\n| Field Name | Product specification field name. | Material |\n| Field Type Name | [Product specification field type](/en/docs/tutorials/adding-specifications-or-product-fields#product-field-types):<ul><li>Text</li><li>Large Text</li><li>Number</li><li>Combo</li><li>Radio</li><li>CheckBox</li><li>Indexed Text</li><li>Large Indexed Text</li></ul>If you're using the beta version of categories, check the field types supported for [attributes](/en/docs/tutorials/creating-or-editing-categories-attributes-and-variations-beta#adding-attributes). | Text |\n| Field Value ID | Numeric code that identifies the field value. | 290 |\n| Field Value Name | Field value name. | Synthetic |\n| Specification Code | Numeric code that identifies the relationship between the field and the product. | 418  |\n| Specification Value | Value assigned to the product specification field. This is the only information that can be edited through the spreadsheet.  | Polyester |\n\n## Learn more\n\n* [Importing and exporting products and SKUs using a spreadsheet (Beta)](/en/docs/tutorials/importing-and-exporting-products-and-skus-using-a-spreadsheet-beta)\n* [Importing and exporting SKU specifications using a spreadsheet (Beta)](/en/docs/tutorials/importing-and-exporting-sku-specifications-using-a-spreadsheet-beta)\n* [Importing and exporting product and SKU images using a spreadsheet (Beta)](/en/docs/tutorials/importing-and-exporting-product-and-sku-images-using-a-spreadsheet-beta)"}