Change categories in CSV-Product List

Hello, we need a little modification on our CSV-Article list. Attached you will find the category and the article list. These lists are in German, you should only replace the categoryname with the new categoryid. We need this modification import the products in Prestashop. Please replace the data in the column "KATEGORIE" (in the article-list) with the data in "parent ID" (from the category list) for each product. Please make that category wise with the following root categorys: - Aquarienwelt - Gartenwelt - Hundewelt - Katzenwelt - Kleintierwelt - Terrarienwelt - Vogelwelt After replaceing the full root category save them to a new file. We need all root categorys in separated files. To make it easery for you, we sorted all article alphabetically. The blue lines mean, there starts a new root-category. In the column "KATEGORIEN" there can be more then one category( separated with " | "), you have to change all possible categorys.