Importing CSV Files Into Excel

In this article, you'll learn how to import Yotpo CSV template files into Microsoft Excel so you preserve the UTF-8 encoding.

If you open the file directly in Excel, any special characters, such as ®, will be lost.

Importing the CSV file

1. Open Excel and create a new, blank workbook.
2. Click Data to open the Data tab.
3. Click From Text.
4. Browse to the Yotpo template file you downloaded.
5. Click Import.
6. In the Text Import Wizard - Step 1 of 3 dialog box, select the following options:
   • Delimited
   • File origin: 65001 - Unicode (UTF-8)
   • My data has headers - not checked
7. Click Next.
8. In the Text Import Wizard - Step 1 of 3 dialog box, select the following options:
   • Delimiters: Select Comma; deselect all other options
   • Text qualifier: "
     
9. Click Next.
10. In the Text Import Wizard - Step 3 of 3 dialog box, select Column data format: General:
    
11. Click Finish.
12. In the Import Data dialog box, select Existing worksheet:
    
13. Click OK.