CSV Listings Import – Multiple Categories

Hi,

I am trying to import some listings data using an Excel sheet saved as a Windows CSV file (as I’m using a Mac) but I’m having problems because most of my listings are assigned to more than one category.

Where I have more than one category for a listing, I am using commas to separate them within the category field, but the data then gets out of line on import because (I guess) the commas are being read a field separators.

Would appreciate the help if anyone can advise on the correct format for entering multiple categories in the category filed of a csv…

Thanks,
Ken