How to Create an Amazon Flat File — Complete Guide (2025)
A step-by-step walkthrough for creating Amazon flat files from scratch. Learn how to download templates, fill required attributes, handle parent-child variations, and upload to Seller Central without errors.
If you sell on Amazon, you've probably hit the wall of the single-item Add a Product form — it's fine for five SKUs but becomes unmanageable at scale. Amazon flat files solve this by letting you create and update listings in bulk via a spreadsheet. But the templates are complex, the required fields vary by category, and one formatting mistake can reject your entire upload. This guide walks you through the entire process, from downloading the right template to getting your listings live.
What Is an Amazon Flat File?
Definition & Purpose
An Amazon flat file is a tab-separated spreadsheet template that Amazon provides for each product category. You fill in your product data — titles, descriptions, prices, images, and category-specific attributes — and upload it to Seller Central to create or update listings in bulk. Flat files are the primary way to list new products at scale, and they're the only method that supports parent-child variation families and all category-specific attributes that the standard form doesn't expose.
Why Flat Files Matter for Sellers
Flat files matter because they unlock capabilities you can't access through the regular listing flow. You can create hundreds of listings in one upload, structure variation relationships (parent-child) that are nearly impossible to set up manually, and fill category-specific attributes like fabric_type for clothing or wattage for electronics. Without these attributes, your listings get suppressed or buried in search results. For any seller managing more than a handful of products, flat files aren't optional — they're essential.
Step-by-Step: Creating an Amazon Flat File
Follow these four steps to go from zero to a fully uploaded flat file with correct attributes and variations.
Download the Right Template
Log in to Seller Central and navigate to Catalog > Add Products > Upload your inventory file. Click "Download an Inventory File" and you'll see a category tree. Select the exact leaf category for your products — a "Dress" needs the Clothing & Accessories & gt; Women > Dresses template, not a generic Clothing one.
Choose the "Advanced" template type rather than "Lite." The Advanced template includes all category-specific columns and variation support. The Lite version omits critical attributes that Amazon requires for full listing visibility.
Download the template as an Excel file (.xlsx) — it includes two important tabs: the Data Definitions tab that explains every column, and the Template tab where you enter your data. Read the Data Definitions tab first; it tells you which fields are required, which are conditionally required, and what values are accepted.
Fill Required Fields
Every flat file has a set of required fields — item_sku, product_type, item_name, brand, and standard_product_id (UPC or EAN) are almost always mandatory. Beyond these, each category adds its own required attributes. Clothing requires fabric_type and style_name. Electronics requires wattage or connector_type. If you leave a required field blank, Amazon rejects the entire row.
Pay close attention to "conditionally required" fields. These are fields that become required when other fields are present — for example, if you fill in variation_theme, you must also fill in parent_sku and relationship_type. The Data Definitions tab marks these with a "C" indicator.
Use UTF-8 encoding if your file contains special characters (accented letters, symbols). Amazon's system expects UTF-8, and encoding mismatches are one of the most common causes of upload failures for international sellers. Save your file as "Text (Tab-delimited)" when you're ready to upload.
Handle Variations
Variations are where flat files get tricky. A parent-child variation structure means one parent listing (the "buyable" page) and multiple child listings (the specific size/color combinations buyers actually purchase). In your flat file, the parent row has relationship_type set to "Parent" and no price or quantity. Each child row has relationship_type set to "Child", parent_sku pointing to the parent, and a variation_theme like "SizeName-ColorName".
The variation_theme must match one of Amazon's accepted values for your category — you can't make up your own. Common themes include SizeName, ColorName, and SizeName-ColorName. Every child in the same variation family must use the same theme, and the parent_sku must be identical across all children. One typo breaks the entire family.
Don't assign a price or quantity to the parent row — Amazon derives these from the children. The parent row only needs the item_name, brand, and category-specific attributes that apply to all variations. Child-specific attributes (like size or color) go on the child rows only.
Upload to Seller Central
Go back to Catalog > Add Products > Upload your inventory file in Seller Central. Choose your file, select the correct file type (usually "Inventory Files for Non-Media"), and click Upload. Amazon will start processing your file immediately — you'll see a status of "In Progress" in the upload history table.
Processing time depends on file size. Files under 100 rows typically finish in 5–15 minutes. Larger files can take 30 minutes to several hours. You can check progress under "Monitor Upload Status" on the same page. Do not re-upload the same file while the first one is still processing — this creates duplicate listing attempts.
When processing completes, download the Processing Report. This report lists every row that succeeded or failed, with specific error codes and messages. Fix any errors in your original file (don't start from scratch), re-save as tab-delimited, and re-upload only the corrected rows if your file is large. Common errors include missing required fields, invalid UPCs, and encoding issues.
Alternative: Generate with AI
Don't want to wrestle with 100+ column templates? Upload your product CSV to ListingHubs and AI auto-detects your category, maps every field, structures variations, and generates a Seller Central–ready flat file — in minutes, not hours.
Frequently Asked Questions
What is an Amazon flat file?▼
An Amazon flat file is a category-specific spreadsheet template (TSV or Excel) used to create or update product listings in bulk through Amazon Seller Central. Unlike the single-item Add a Product tool, flat files support variations, category-specific attributes, and bulk operations — making them essential for sellers with more than a handful of SKUs.
How do I download the right flat file template?▼
In Seller Central, go to Catalog > Add Products > Upload your inventory file, then click 'Download an Inventory File'. Select your product category from the tree, choose the 'Advanced' template type for the most complete set of columns, and download. Each category has its own template with unique required fields — using the wrong one will cause upload failures.
What is the difference between a flat file and a regular listing?▼
A regular listing is created one at a time through Seller Central's Add a Product form, which is fine for a few items but impractical for bulk uploads. A flat file lets you create dozens or hundreds of listings simultaneously in a spreadsheet, supports parent-child variations, and includes category-specific attributes that the single-item form doesn't expose. Flat files are also the only way to bulk-edit existing listings.
How do I fix flat file upload errors?▼
After a failed upload, Amazon generates a Processing Report that lists each error by row number and column name. Open the report, match the row numbers to your flat file, and fix the flagged values. Common errors include missing required fields, invalid character encoding (use UTF-8), and duplicate SKUs. Fix only the errors, re-save as tab-delimited text, and re-upload — don't change anything that processed successfully.
How long does Amazon take to process a flat file?▼
Small files (under 100 rows) typically process in 5–15 minutes. Larger files (hundreds or thousands of rows) can take 30 minutes to several hours. You can check the status in Seller Central under Catalog > Add Products > Upload your inventory file > Monitor Upload Status. The processing report appears once Amazon has finished evaluating every row.
Skip the manual flat file process
Upload your product CSV and get a category-specific, validated Amazon flat file — with auto-mapped fields, filled attributes, and structured variations — in minutes.
Get Started Free