Amazon listings report cleanup
An Amazon Seller Central All Listings or Active Listings report (Inventory → Inventory Reports), a tab-separated file.
Processed locally in your browser. File contents are not uploaded. No account needed.
Before and after
Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.
Original
| Row | seller-sku | price | quantity |
|---|---|---|---|
| 2 | 00123 | 12.50 | 40 |
| 3 (removed) | |||
| 4 | MUG-RED (has spaces at its edges) | 1,014.00 | 5 |
| 5 (removed) | 00123 | 12.50 | 40 |
| 6 | TEA-01 | $30.00 | 0 |
Result
| Row | sku | price | quantity |
|---|---|---|---|
| 2 | 00123 | 12.50 | 40 |
| 4 | MUG-RED (changed) | 1014.00 (changed) | 5 |
| 6 | TEA-01 | 30.00 (changed) | 0 |
3 rows × 9 columns after the fixes · was 5 × 9 · 3 cells changed
6 more columns are not shown; they pass through unchanged.
· marks a space at the start or end of a value. The dots are not in the data; they show spaces you would otherwise not see.
Why
Sellers editing the listings report to upload it again report SKUs losing their leading zeros in Excel and the upload wanting a column named sku, not seller-sku. Every value stays text here, so 00123 stays 00123.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Trim spaces in every columnOn the sample: 1 cell changed
- Read "price", "quantity" as numbers (decimal mark: dot, 1,234.56); values that are not numbers are left as they areOn the sample: 2 cells changed
- Remove duplicates: rows with the same "seller-sku" (blank keys never match), keeping the first of each groupOn the sample: 1 row removed
- Rename "seller-sku" to "sku"On the sample: 1 header renamed
Your file needs these columns, spelled exactly: seller-sku, price, quantity. If one is missing or renamed, the workflow tells you which step it breaks and does not run.
How to use it
Download the workflow
A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).
Open your export
In the Data Workspace, choose your file. It is processed in your browser, not uploaded.
Import, review, run
Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.