How do I import my CSV file into magento successfully?

Posted by:

If the data appears clean when you look at it in a spreadsheet program (column headers are the proper attribute names, the columns appear “tidy” with the right values in the right columns, etc.) then I would suggest try opening the .csv file in a text editor, and use the options in “save as” (or perhaps in a format menu) to confirm that the character encoding is UTF-8. The text and file should appear the same to your eye. This has solved problems similar to yours for me many times, and I never could figure out where the change occurred in the process, so this is just one of those things that I check when we are having problems.


Add a Comment