How to read a UTF-8 CSV file in Excel 2007?

To read a UTF-8 CSV file into Excel 2007, follow these steps:

  1. Download the exported CSV/XLS file from your website.
  2. Open Excel 2007
  3. Open a new file
  4. Click the Data Menu option
  5. Click "From Text" button
  6. Select the file you downloaded
  7. Make sure "Delimited" is selected and Press Next
  8. Select 65001: Unicode UTF8 and press Next
  9. Check the delimiter characters that you know are in your file like Comma or Tab or whatever is in your case. You can select more than one
  10. Proceed to Next Step and Finish
  11. Your excel file will be ready with all you data displayed correctly