Supplier CSV to Amazon Column Mapper
Upload or paste your supplier's CSV, map each column to Amazon flat file fields, and download the transformed output — all in your browser, no data leaves your device.
Part of the Amazon Seller Tools suite
or paste CSV content
Why You Need a CSV Column Mapper
Suppliers send product data in their own format — column names, ordering, and field conventions that don't match Amazon's flat file template. Manually copying data column by column is tedious and error- prone, especially when working with hundreds or thousands of SKUs.
This tool lets you upload your supplier's CSV, visually map each column to the corresponding Amazon field, and download a clean output file ready for Seller Central's inventory loader. Everything runs in your browser — your product data never leaves your device.
Supported Amazon Flat File Fields
The mapper includes the most commonly used Amazon flat file columns: SKU, product name, UPC/EAN, brand, price, quantity, images, bullets, search terms, dimensions, and more. You can also create custom column names for fields not in the preset list.
Tips for Clean Data Mapping
- Clean your supplier data before mapping — remove blank rows, fix encoding issues, and verify UPCs
- Map the
external_product_id_typefield to "UPC" or "EAN" as needed — Amazon requires this to match the ID format - Use the "-- skip --" option for supplier columns you don't need in the Amazon output
- Download and review the output before uploading to Seller Central
Frequently Asked Questions
Is my CSV data sent to a server?
No. All processing happens entirely in your browser using JavaScript. Your CSV data never leaves your device. This is a 100% client-side tool.
What CSV formats are supported?
The parser handles comma-separated and tab-separated files, including quoted fields with commas inside them. Standard CSV files from Excel, Google Sheets, and most supplier systems work out of the box.
Can I map one supplier column to multiple Amazon fields?
This tool maps each supplier column to one Amazon field. If you need to split or duplicate data, export the mapped CSV and make those adjustments in a spreadsheet before uploading to Seller Central.
What is an Amazon flat file?
A flat file is Amazon's spreadsheet-based template for bulk uploading product listings. Each category has its own template with specific required and optional columns. You download the template from Seller Central, fill in your product data, and upload it to create or update listings in bulk.
Powered by HumanCalculations — free online calculators