How to Bulk update item categories

I try to bulk update my items sub and main category.
For that I exported all items as xlsx file and updated the cells with the existing names.

While importing the edited xlsx file the error-message "Illegal value specified for a Dropdown field: A-1A" comes up.

What did I do wrong? i dont see a dropdown in my export file.

I haven't found a topic on this yet.

Thank you for a short guide.

Best regards
Patrick

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Patrick
Shireen Farhana

Sticky Posts
[Webinar] Understanding the New Invoice Management Systems
Join industry expert CA Pritam Mahure as he discusses the importance of the new Invoice Management System (IMS) and its impact on taxpayers. Topics Covered: - Concept of IMS and pre-requisites - Applicability and Restrictions on Invoices/Records for IMS
Latest Updates of the 53rd GST Council Meeting & Its Business Implications
Join industry expert CA Venugopal Gella as he discusses the importance of 53rd GST Council Meeting, the latest notifications and changes introduced by the Finance Act 2024. Register Now: https://zoho.to/GST_Webinar
Best practices for financial year-end closing with Zoho Books | Free Webinar
Ready to close your year-end finances like a pro? Join our free webinar and learn how Zoho Books helps you maintain clean accounts, carry forward balances, and get geared up for the new financial year. Register now - https://zoho.to/9f1
Zoho Books will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100
Master the art of budgeting with Zoho Books | Free Webinar | 4th & 5th March 2024
We're thrilled to launch the Zoho Books monthly webinar series! Don't wait to conquer your finances in 2024! Budgeting can be easy with Zoho Books. Join our FREE webinar and learn how to set and track goals, master budgeting, and unlock insights to make