Saving CSV/Excel file as UTF-8 Encoded – WooCommerce Product Import Export

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Importing product CSV file must be encoded in UTF-8. It is to make sure that all the product imports made with Product Export Import Plugin for WooCommerce are accurate. During product import, you can avoid unnecessary characters like  ž, ?, etc. If the CSV file is not UTF-8 encoded, then symbols like ™ , ®, ©,etc. gets converted to unwanted characters.

Contents

What is UTF-8 encoding?

A character in UTF-8 can be from 1 to 4 bytes long. UTF-8 can represent any character in the Unicode standard and  it is also backward compatible with ASCII as well. It is the most preferred encoding for e-mail and web pages. It is the dominant character encoding for the world wide web.

Here are two samples:

Spread sheet not UTF-8 encoded
Sample1: Unencoded UTF-8 spreadsheet
Sample2: Spreadsheet not UTF-8 encoded
Sample2: Unencoded UTF-8 spreadsheet

This article explains how to apply UTF-8 encoding with major spreadsheet applications like Microsoft Excel and Notepad for Windows, and Apple Numbers and TextEdit for Mac. Since Google Sheets is a widely used spreadsheet application, this article also explains a UTF-8 encoding with Google Sheets.

How to save CSV file as UTF-8 using Libre Office?

To save a CSV file as UTF-8 encoded, follow the steps below:

  • Open LibreOffice and go to Files from the menubar. Click on open and select the file from the computer that you want to save as a UTF-8 encoded file.
  • After opening the file go to File > Save as. From the dialog box that opens, type the name of the file and select Text CSV (.csv) from the Save as type drop-down.
  • Check the Edit filter settings options.
Save file as CSV
  • Click on Save.
  • From the Export Text File dialog box that appears, select the Unicode (UTF-8) option from the Character set drop-down.
    Set the field and text delimiter as you wish or leave as is.
Encode as UTF-8
  • Click OK.

This will save the file as UTF-8 encoded in Libre Office.

How to save CSV file as UTF-8 using Google Spreadsheet?

To save CSV file as UTF-8 encoded, you can upload the file on Google Drive and easily store it as UTF-8. The steps are as given below:

  1. First, open your Google Drive account. Click on the NEW button on the top left corner, and click Upload files option.
    File upload option in Google Drive
    File upload option in Google Drive
  2. Browse for the required CSV file and start uploading it.
  3. Open the uploaded file with Google Spreadsheet.
  4. Navigate to File > Download as, and select Comma-separated values (.csv, current sheet) option.
    Download as CSV option in Google Sheets
    Download as CSV option in Google Sheets

    The downloaded file gets saved as UTF-8 encoded by default and can be imported correctly when uploaded into our product import export plugin.

How to save the CSV file as UTF-8 in Microsoft Excel?

The steps are as given below:

  1. Open the CSV file with Microsoft Excel sheet.
  2. Navigate to File menu option and click Save As. The window appears as shown below:
    Save As option in Microsoft Excel
    Save As option in Microsoft Excel
  3. Click Browse to select a location to save the file.
  4. The Save As window appears as shown below:
    Save As option in Microsoft Excel
    Save As option in Microsoft Excel
  5. Next, enter the name of the file.
  6. Select the Save as type as CSV (Comma delimited) (*.csv) option.
  7. Click Tools drop-down box and click Web OptionsA new window for web options appears as shown below:
    Web Options
    Web Options
  8. Under Encoding tab, select the option Unicode (UTF-8) from Save this document as: drop-down list.
  9. Finally, click Ok, and save the file.

How to save CSV file as UTF-8 with Notepad?

The steps are as given below:

  1. Open the CSV file with Notepad.
  2. Navigate to File > Save As option. A screenshot of the menu is as shown below:
    Notepad File Menu
    Notepad File Menu
  3. Next, select the location to the file. The Save As window appears as shown below:
    Save As option in Notepad
    Save As option in Notepad
  4. Select the Save as type option as All Files(*.*).
  5. Specify the file name with .csv extension.
  6. From Encoding drop-down list, select UTF-8 option.
  7. Click Save to save the file.

This way, you can save a file as a UTF-8 encoded with Notepad.

How to save CSV file as UTF-8 in Apple Number?

The steps are as given below:

  1. Open the file with Apple Numbers.
  2. Navigate to File > Export To  > CSV. A screenshot of the settings is as shown below:
    Exporting to CSV with Apple Numbers
    Exporting to CSV with Apple Numbers
  3. Under Advanced Options, select Unicode(UTF-8) option for Text Encoding. A screenshot of the settings is shown as below:
    Advanced Options in Apple Numbers
    Advanced Options in Apple Numbers
  4.  Click Next. Further settings appear as shown in the screenshot below:
    Export option in Apple Numbers
    Export option in Apple Numbers
  5. Enter the name of the file and click Export to save your file with the UTF-8 encoding.

How to save CSV file as UTF-8 in TextEdit?

The steps are as given below:

  1. Open the file with TextEdit.
  2. Navigate to Format > Make Plain Text. A screenshot of the menu is as shown below:
    Format menu in TextEdit
    Format menu in TextEdit
  3. Next, navigate to File > Save. It is shown as below:
    File menu in TextEdit
    File menu in TextEdit
  4. From Plain Text Encoding drop-down list, select Unicode(UTF-8).
  5. Finally, click Save to save the file.

For customer query and support answer on this topic, please refer support topic.

To know more about other features of the plugin, read the documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

3 thoughts on “Saving CSV/Excel file as UTF-8 Encoded – WooCommerce Product Import Export

  1. anders says:

    Hello,

    i exported as you explained for excel and still the Swedish characters is showing wrong, any ideas why?

    warm regards Anders

    • Anindo
      Anindo says:

      Hi Anders,

      Kindly let us know which tool are you using to view the csv. Usually microsoft excel is using ANSI encoding format. In that case, you may need to change to Libreoffice or any other office application.

      We request you to do this simple step and let us know.

Leave a Reply

Your email address will not be published. Required fields are marked *