How to import a .csv file that uses UTF-8 character encoding

How to import a .csv file that uses UTF-8 character encoding

Saptarshi Nath 1 year ago

Hi Kiet, 

I was getting the same issue as yours, I am not sure if my solution will work for you but there's no harm trying. Here is what I suggest: 

1. Go to System > Import/Export > Data Flow profiles 
2. Click on Export All Products 
3. (I assume you already know this since you have tried uploading before) Download the relevant products into the CSV. 
4. Fill the CSV with new information 

Before saving the CSV, do this: 
1. Go to File > Save As 
2. In the drop down, make sure to choose CSV (MS-DOS), by default it is set as CSV (comma delimited) which causes the problem. 
 
3. Next, go to Tools > Web Options (right next to the Save button). 
 
4. In the new popup, go to Encoding and choose UTF-8 from the drop down. 
 

That is it! After saving the file, try to upload it again through Import All Profiles and it _should_ work! Do post here it is works (or doesn't)! 

Thanks, 
Saptarshi

http://collaborate.magento.com/magento/topics/skip_import_row_required_field_sku_not_defined