How to normalise product category values in a product csv
- Step 1List your canonical category names — Decide on the final categories your store or PIM will use.
- Step 2Export the product CSV — Download from your PIM, ERP, or supplier.
- Step 3Add find-and-replace pairs — Map each variant to a canonical value: 'Mens Footwear' → 'Men's Shoes'.
- Step 4Download and import — Use the normalised feed for your storefront or PIM upload.
Frequently asked questions
What if a category name appears in product titles too?+
Limit the replacement to the Category column by selecting only that column in the tool.
Can I use regex patterns for the find value?+
Yes. Enable regex mode to match patterns like 'Men[s\']{0,2} Shoes'.
Is there a limit to the number of replacement pairs?+
No practical limit. Add as many pairs as your category taxonomy requires.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.