Steven Zahm@ omar
So not put the quotes in. The column header for categories should be Category not ” category”.
The category value should be Almond not “Almond” or ‘ Almond’
This has nothing to do with your theme, you need to structure the data correctly.
When you enter your data in Excel or LibreOffice you do not add the quotes. When you export the CSV file from those applications they will properly added the quotes (well, LibreOffice does it correctly all the time … Excel can mangle it which is why I suggested using LibreOffice.
When you are working in a spreadsheet application you are not creating the CSV file you are creating a spreadsheet file. You only get a CSV file by exporting/saving as the spreadsheet as a CSV file. During this save process from the spreadsheet to CSV file, the application will automatically add the quotes, you do not add them when creating the spreadsheet.
When saving from LibreOffice. Save it as a CSV file. Use the settings shown in the attached screenshot.
When importing, the quotes are imported because different applications will quote the values differently. You can find out how the app quoted the values by opening the CSV file in a text editor like Notepad++.
The settings in the CSV Import page apply only to the CSV file not how the data is entered in the spreadsheet.
The only time you would add the quotes yourself is if you are manually creating a CSV file.
If you want to learn me about CSV files, read this page. I skimmed over it, it seems like a pretty thorough resource to learn from.
Hope that helps.