I am trying to import product through Magento 2 Admin Panel using CSV file. My CSV file looks like below

enter image description here

I have categories like All Category/Bikes, Scooters & Ride-Ons and All Category/Fashion Accessories, All Category/Fashion Accessories/Ladies.

If I import this CSV file I got categories like.

  • All Category/Bikes
  • Scooters & Ride-Ons
  • All Category/Fashion Accessories
  • All Category/Fashion Accessories/Ladies

I tried with below CSV file.

enter image description here

I got below result.

enter image description here

How can I solve this issue ?

2 Answers 2


Well, I have got a solution for this. Use , in category name and in CSV. It will look the same on frontend as well as admin as shown in the attached image:enter image description here

enter image description here

  • Terrible answer. It's a hack, and will almost certainly cause more problems in the future.
    – WackGet
    Nov 29, 2017 at 19:17

The commas in your category names must either be within a double-quote enclosed string ("All Category/Bikes, Scooters & Ride-Ons") or escaped. See https://stackoverflow.com/questions/769621/dealing-with-commas-in-a-csv-file

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.