CSV file UTF-8 encoding error
The feed file is UTF-8 encoded because UTF-8 can encode any type of character and all the merchants require UTF-8 encoded feed file. So You have to open the CSV file with UTF-8 supported test editor or have to configure Microsoft Excel to open a UTF-8 encoded file. Follow the steps to learn how to solve CSV file UTF-8 encoding error in step by step:
- Openย Microsoft Excel 2007.
- Click on theย Dataย menu bar option.
- Click on theย From Textย icon.
- Navigate to the location of the file that you want to import.ย Click on the filename and then click on theย Importย button.ย Theย Text Import Wizard – Step 1 or 3ย window will now appear on the screen.
- Choose the file type that best describes your data –ย Delimitedย orย Fixed Width.
- Chooseย 65001: Unicode (UTF-8)ย from the drop-down list that appears next toย File origin.
- Click on theย Nextย button to display theย Text Import Wizard – Step 2 or 3ย window.
- Place a checkmark next to the delimiter that was used in the file you wish to import intoย Microsoft Excel 2007.ย Theย Data previewย window will show you how your data will appear based on the delimiter that you chose.
- Click on theย Nextย button to display theย Text Import Wizard – Step 3 of 3.
- Choose the appropriate data format for each column of data that you want to import.ย You also have the option not to import one or more columns of data if you want.
- Click on theย Finishย button to finish importing your data intoย Microsoft Excel 2007.