Stock count cleanup
A stock count or inventory export with SKU and Quantity columns, from a warehouse sheet or a stock system.
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 | SKU | Product | Quantity | Location |
|---|---|---|---|---|
| 2 | mug-blue | Blue Mug | 1,200 | Warehouse A |
| 3 | MUG-RED (has spaces at its edges) | Red Mug | 35 (has spaces at its edges) | Warehouse A |
| 4 (removed) | ||||
| 5 | kettle-9 | Kettle | 8 | Shop |
| 6 | tea-01 | Tea Set | 12 | Shop |
Result
| Row | SKU | Product | Quantity | Location |
|---|---|---|---|---|
| 5 | KETTLE-9 (changed) | Kettle | 8 | Shop |
| 2 | MUG-BLUE (changed) | Blue Mug | 1200 (changed) | Warehouse A |
| 3 | MUG-RED (changed) | Red Mug | 35 (changed) | Warehouse A |
| 6 | TEA-01 (changed) | Tea Set | 12 | Shop |
4 rows × 4 columns after the fixes · was 5 × 4 · 6 cells changed
· 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.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Trim spaces in every columnOn the sample: 2 cells changed
- UPPER-case "SKU"On the sample: 3 cells changed
- Read "Quantity" as numbers (decimal mark: dot, 1,234.56); values that are not numbers are left as they areOn the sample: 1 cell changed
- Sort the rows by "SKU" (A to Z); blank and unreadable values go lastOn the sample: 3 rows moved
Your file needs these columns, spelled exactly: SKU, 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.