Free · No account neededYour numbers and images stay on your device
ZabtnaSeller tools العربية

AMAZON SELLER TOOLS / Free · No account needed

Amazon flat file checker

Review CSV, TSV and XLSX: SKUs, duplicates, prices and relationships. Download issues and a safer review copy.

No account · No Amazon connection · Local processing

Choose a product spreadsheet

CSV, TSV or XLSX up to 5 MiB, 10,000 rows and 100 columns. Legacy XLS and protected files are unsupported.

This reviews data quality, not every Amazon category requirement. The copy is for manual review, not an approved upload template: XLSX exports values as TSV without formatting or formulas; formula cells are blanked and flagged. Potential spreadsheet formulas are escaped; other values are preserved. Image URLs are checked syntactically, never opened or checked for availability.

Review the data before sending it to your store.

Choose your file, worksheet and header row. Field mapping determines the checks; nothing is sent to Amazon.

Understand the number before the decision

Choose the data worksheet and header row

Some Amazon templates have instruction worksheets and rows before the column headers. Choose the data worksheet, header row and SKU mapping. Review automatic suggestions; templates differ by category.

Checks you can understand

Checks cover blank and duplicate SKUs, prices in the selected column and image URL syntax without visiting links. If parent/child is mapped, parent references and relationships are checked within the file. Fix the source data and run the checks again.

Download a review copy without changing your store

Download an issue report and a values-only TSV copy. Formula-like prefixes are escaped; missing data is not invented and duplicates are not deleted on your behalf. Excel formatting and formulas are not retained in TSV. No file is submitted to Amazon or claimed valid for every category.

Quick answer

Before uploading a product file, choose its data worksheet, header row and SKU column. Check duplicate codes, prices and selected relationships, then download an issue report and values-only review copy. We do not delete duplicates, change your catalog or submit files to Amazon.

How to use this tool

  1. Choose CSV, TSV or XLSX. For an Excel template, select the data worksheet and column-header row.
  2. Review SKU and optional field mappings, then check data. Skip fields you do not want checked.
  3. Download the issues and TSV review copy. Correct the source, recheck it, then review Amazon’s template and category requirements.

Questions before you start

Can I use it with an Amazon flat file template?

It reads CSV, TSV and XLSX within the stated limits and lets you select a worksheet, header row and fields. Checks cover shared data-quality issues, not every category column, allowed value or GTIN requirement. Upload approval is not guaranteed.

Does the checker automatically remove duplicate SKUs?

No. Duplicate rows are flagged for comparison before editing. Their values or parent relationships may differ, so automatically keeping the first row could lose valid information.

How do I keep leading zeros in SKUs?

The tool preserves text it reads, such as 000123. Import the SKU column into Excel as text. If Excel already converted the stored value to 123, we cannot infer lost zeros. Custom Excel display formatting is not exported here.

Is the TSV review copy ready to upload to Amazon?

No. It is a values-only review copy without Excel formatting or formulas. Formula cells are blanked and flagged, and formula-like text prefixes are escaped. Correct and review your original template before submitting it yourself.

Content reviewed: 17 October 2026

Independent tools by Zabtna; not affiliated with Amazon. Product approval is not guaranteed.

References reviewed: 8 October 2026

Official Amazon references