How to Fill the Amazon.in Product Upload Template
Fill Amazon's product template (.xlsm) right: Data Definitions, red and orange fields, valid values, GTIN Exempt, images and the processing report.
By the CatalogNest team (AngGate Tech Solution) · Published · 8 min read
Key takeaways
- Download the template for your category from Seller Central: Catalog > Add Products via Upload.
- Required cells turn red and conditionally required or recommended cells turn orange once you pick a Product Type in a row.
- Use exactly the values in the Valid Values tab; a missing or invalid required value stops the product being added.
- Amazon recommends a first upload of 15 or fewer products, then checking the processing report.
- Images go in as URLs in the sheet, or through the image upload tool after the sheet, named SKU.MAIN.jpg and SKU.PT01.jpg.
Amazon's product upload template is an Excel file (.xlsm) you download for your category from Seller Central under Catalog > Add Products via Upload. You fill one row per product in the Template tab, using the Data Definitions tab to see which fields are required and the Valid Values tab for allowed values, then upload the file on the same page and check the processing report for errors. Amazon recommends testing with 15 or fewer products first.
Which tabs are in the Amazon template?
| Tab | What it is for |
|---|---|
| Instructions | How to create, validate and upload the file |
| Images | Amazon's image standards |
| Data Definitions | Every field, its accepted values, an example, and whether it is Required, Conditionally Required, Recommended or Optional |
| Template | Where you enter one product per row |
| Browse Data | Browse nodes for Recommended Browse Nodes, e.g. Home & Kitchen > Home & Décor > Candles > Tea Lights |
| Valid Values | The allowed values for dropdown fields, per product type |
How do I know which fields are required?
Pick the Product Type in a row first. Amazon's Instructions say required cells are then highlighted in red, conditionally required and recommended cells in orange, and cells that do not apply to that product type are greyed out. Required fields are the minimum to create the product: failure to enter a valid value in a required field will prevent your product from being added to the catalogue. Conditionally required fields become required based on what you enter elsewhere, for example a package length needs its unit.
In the Candles and Candle Holders template, Data Definitions mark eight fields as Required for every row:
- SKU
- Item Name (keep it within 75 characters)
- Brand Name
- Product Id Type (and the Product Id itself unless the product is GTIN Exempt)
- Product Description
- Bullet Point
- Country of Origin
- Dangerous Goods Regulations
What is GTIN Exempt?
Product Id Type asks for the barcode type of your product: EAN, GTIN, UPC or ASIN. The template's own definition says: if the product is exempt from external ID, select GTIN Exempt. Sellers whose products have no barcode, such as small handmade brands, apply for a GTIN exemption for their brand in Seller Central first; once it is approved, those rows use GTIN Exempt and leave Product Id empty.
How do I add images to the template?
Amazon gives two options. Either enter a public URL for each image in the Main Image URL and Other Image URL cells, or submit the sheet without image cells and then upload a zip of images with the image upload tool. Amazon suggests naming each file with the SKU followed by the view: SKU.MAIN.jpg for the main image and SKU.PT01.jpg to SKU.PT08.jpg for up to eight more. Until an image is supplied, the SKU will not be buyable.
| Image rule (Images tab) | Requirement |
|---|---|
| MAIN background | Pure white (RGB 255, 255, 255) |
| MAIN content | No graphics, text, logos, watermarks, inset images or unshipped props |
| Fill | The product fills 85% or more of the image |
| Size | 1000 px or more on one side for zoom; under 500 px on the longest side is rejected |
| Format | JPEG (preferred), TIFF or GIF |
How do I upload and check the file?
- Save the whole workbook as Excel, or the Template tab alone as tab-delimited text.
- Upload it under "Upload your spreadsheet" on Add Products via Upload.
- Download the processing report from Spreadsheet upload status and fix every error it lists.
- Start with 15 or fewer products, as Amazon recommends, then upload the rest.
If you upload an outdated template, Amazon generates an updated version with your data pre-filled and links to it from Spreadsheet upload status. Some templates also carry a row that says it was pre-filled from your Preference Profiles; Amazon asks you not to delete that row.
Sources
- Amazon.in product template for Candles and Candle Holders (CANDLE_CANDLE_HOLDER.xlsm), Instructions, Images and Data Definitions sheets, downloaded from Seller Central on 21 October 2026
- Amazon Seller Central: Add Products via Upload
- Amazon Seller Central: product image requirements (help page 1881)
Frequently asked questions
Where do I download the Amazon product upload template?
In Seller Central, under Catalog > Add Products via Upload. Pick your product categories and Amazon generates the spreadsheet.
Why are some cells red or orange in the Amazon template?
After you select a Product Type, required cells are highlighted red and conditionally required and recommended cells orange. Greyed-out cells do not apply to that product type.
How many products should I upload first?
Amazon recommends first uploading 15 or fewer products to test, then the rest once that upload succeeds.
Can I use ® or © in the Amazon template?
No. The template's Instructions say high ASCII characters such as ® and © and HTML tags are not allowed.