Importing CSV Files Into Excel

      Importing CSV Files Into Excel


        Article summary

        Products


        Reviews
        Supported plans

        N/A

        eCommerce Platform

        N/A

        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.

        Please note:
        This article refers to the latest version of Excel. The procedure may vary slightly for older releases.

        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.

        Was this article helpful?