Flat Files Are Amazon’s Bulk Language
Amazon Seller Central uses category-specific templates and inventory files that look like spreadsheets but behave like strict data feeds. Whether you download an Excel template or work in CSV, the columns and valid values are defined by Amazon—not by your internal PIM habits.
Always start from the current template for your category and marketplace.
Common Amazon File Types
Different jobs, different templates.
| File | Purpose |
|---|---|
| Inventory / listings flat file | Create or update ASINs/SKUs |
| Pricing / inventory feeds | Bulk price and quantity updates |
| Shipping overrides | Business rules by SKU |
| Business reports (Orders, Settlements, etc.) | Analysis in Excel/BI |
| FBA reports | Shipments, returns, reimbursements |
Step-by-Step: Safe Listing Update
Reduce feed error rates before you upload.
- Download the latest category template from Seller Central.
- Copy only the SKUs you intend to change into a working sheet.
- Keep SKU and ASIN fields as text.
- Follow Amazon’s allowed values for enums (condition, bullet fields, etc.).
- Export UTF-8 CSV or the exact format the upload widget expects.
- Upload to the matching feed type; wait for the processing report.
- Fix ERROR/WARNING rows; re-upload a delta file—not the whole catalog blindly.
Encoding, Delimiters, and Excel
Marketplace locales differ. Some European workflows lean on semicolons or Excel macros inside official templates. When you flatten to CSV for internal tools, normalize deliberately and keep a copy of the Amazon-native file you uploaded.
- Preserve leading zeros in SKUs.
- Do not let Excel convert ASINs/FNSKUs to scientific notation.
- Validate UTF-8 if titles include non-English characters.
- Use the Online CSV Editor to inspect reports before pivoting.
Working with Amazon Reports
Order and settlement reports are often tab-separated or CSV downloads. Convert to Excel for finance, or to JSON for internal pipelines—after you confirm the delimiter.
Real-World Examples
Seller operations patterns.
Catalog launch
Brand maps PIM export into Amazon’s flat file, validates required attributes, uploads 50 SKUs, then scales.
Flash sale prices
Pricing feed updates Your Price / Sale Price for a SKU list; processing report confirms acceptance before marketing emails go out.
Month-end finance
Settlement report cleaned to CSV/Excel, fees categorized, reconciled to payouts.
Common Mistakes
Feed errors are usually preventable.
- Using an outdated category template.
- Uploading internal column names Amazon does not recognize.
- Partial rows that clear values unintentionally.
- Wrong marketplace template (UK vs US columns).
- Ignoring the processing report and assuming success.
Best Practices
Operate feeds like releases.
- Version every upload file.
- Change the minimum columns needed.
- Keep SKU as the durable key in your systems.
- Archive processing reports with the upload.
- Preview with Convert CSV Online before internal hand-offs.
Why Use Convert CSV Online?
Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Inspect Amazon report delimiters, convert to Excel for stakeholders, and keep SKUs intact before re-upload. Client-side workflows work on Windows, macOS, and Linux browsers.
Reports → decisions
Turn Seller Central downloads into clean tables your team can filter without breaking IDs.
Conclusion
Amazon Seller CSV and flat-file workflows reward template discipline, text-safe SKUs, and obsessive reading of processing reports. Edit deltas, not guesswork—and verify before you scale.
FAQ
What CSV files does Amazon Seller Central use?
Category listing/inventory flat files, pricing and inventory feeds, and many downloadable business reports in CSV or TSV form.
How do I bulk upload products to Amazon with CSV?
Download the current category template, populate required fields, upload via the appropriate feed tool, and fix errors from the processing report.
Why did my Amazon feed fail?
Common causes include outdated templates, invalid attribute values, missing required fields, or SKU/ASIN problems. Read the processing report line by line.
Are Amazon reports always comma-separated?
Not always—some are tab-separated. Detect the delimiter before converting or importing.
How do I keep SKUs from breaking in Excel?
Treat SKU/ASIN columns as text, or preview/convert with tools that do not auto-number fields.
Can I convert Amazon reports to Excel?
Yes. Clean the download in the Online CSV Editor if needed, then use CSV to Excel for analysis.
References
Convert your CSV in the browser
Preview, clean, and convert CSV files free with Convert CSV Online—no installation and no account required for everyday conversions.