# Rename categories in bulk **URL:** \ **Category:** Rules\ **Created:** [June 24, 2022, 12:46pm UTC](https://forum.mergado.com/t/rename-categories-in-bulk/489 "2022-06-24T12:46:56Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![petrmindl](https://forum.mergado.com/user_avatar/forum.mergado.com/petrmindl/32/25_2.png) [@petrmindl](https://forum.mergado.com/u/petrmindl)\ **Post date:** [June 24, 2022, 12:46pm UTC](https://forum.mergado.com/t/rename-categories-in-bulk/489/1 "2022-06-24T12:46:56Z")
_Description_ * * * Many e-shops use own category tags, but some search engines indicate a clear specification of the CATEGORYTEXT element content. This rule makes editing easier for you. For ease of work, this rule allows you to add multiple categories of pairs. Thanks to the added lines, everything can be saved as one rule, which saves a lot of work. _Use_ * * * For example, if you have your _Cups_ category, which is an incomplete path, type it in the left column. The word completion will recommend you the exact specification of the category according to your feed content. Start to type in the right column and the word completion will automatically recommend you the available categories of a particular search engine. In the case of Google Shopping, the word completion will advise you the category: _Home & Garden \> Kitchen & Dining \> Tableware \> Drinkware \> Coffee & Tea Cups_ . **Tip** An incomplete entry category can also be used - for example, you have several categories for USB Flash Drives in the e-shop according to their size, but the search engine has just one category for these discs. Your categories are: - USB Drives | 4GB, - USB Drives | 8GB and so on. You will set _USB Drives_ as the entry category in this rule. Mergado will find you all the categories relating to it. The output value will be: _Electronics \> Electronics Accessories \> Computer Components \> Storage Devices \> USB Flash Drives_ . ---
**Author:** ![petrmindl](https://forum.mergado.com/user_avatar/forum.mergado.com/petrmindl/32/25_2.png) [@petrmindl](https://forum.mergado.com/u/petrmindl)\ **Post date:** [June 24, 2022, 12:47pm UTC](https://forum.mergado.com/t/rename-categories-in-bulk/489/2 "2022-06-24T12:47:14Z")
---
**Author:** ![veronika\_kusalikova](https://forum.mergado.com/user_avatar/forum.mergado.com/veronika_kusalikova/32/430_2.png) [@veronika\_kusalikova](https://forum.mergado.com/u/veronika_kusalikova)\ **Post date:** [August 27, 2025, 10:48am UTC](https://forum.mergado.com/t/rename-categories-in-bulk/489/3 "2025-08-27T10:48:37Z")
## **Smart Insert Mode in the Bulk Category Renaming Rule** This rule now allows you to use the so-called **Smart Insert Mode** , where data from the clipboard (CTRL + C) is inserted into the rows below it. **Procedure:** 1. Check the option ![image](https://forum.mergado.com/uploads/default/original/2X/a/a3250f2efce34b570058dbe3a3432c5e27d9ad3c.png) 2. You can fill in the left row **from almost any text file** that contains data below it → this way it will be inserted below it: ![2-chytre-vlozeni-hodnov-tabulka](https://forum.mergado.com/images/transparent.png) 3. You can also take the data from Excel or CSV, where you have it ready (e.g. the image below). ![image](https://forum.mergado.com/uploads/default/original/2X/1/1c15cfac7a3c3001a79c8437f3699aeb024fee50.png) 4. Select “Copy values”. 5. Then insert the values ​​into the rule. 6. How everything looks in Mergado after insertion: ![image](https://forum.mergado.com/uploads/default/original/2X/e/e9caf35d23e651b317423922c49366a169de2494.png) **REMEMBER:** If you want to copy and paste data into both columns of smart insert, simply take the separated data (e.g. , ) and paste it into the Editor. Excel: ![image](https://forum.mergado.com/uploads/default/original/2X/f/f977ddfe4957e0d3c5c46720654fd640f3a481ef.png) 1. After inserting into Mergado, the values ​​are divided into both columns: ![image](https://forum.mergado.com/uploads/default/original/2X/2/231a38d7d67e59687a966d6bb1842d38f4e6925d.png)