WebToffee Logo
  • Home
  • Plugins
  • Bundles
  • Blog
  • Documentation
  • Support
Login
0

  • Getting Started
    • Plugin Setup
    • Order Import Export
    • Product Reviews Import Export
    • Product Categories Import Export
    • Product tags Import Export
    • Coupon Import Export
    • Subscription Orders Import Export
    • User Import Export
    • Product Import Export
  • FTP Cron Schedules
    • Scheduled import
    • Scheduled export
    • Editing scheduled cron
    • Create FTP profiles for export and import
    • Server cron and server commands
    • WooCommerce cron import status
  • Advanced Topics
    • Saving CSV/Excel file as UTF-8 encoded
    • Increasing import batch count
    • Custom fields of third party plugins
    • Import with new ID
    • Modifying Import/Export Batch Count and Effects on Performance
  • Troubleshoot
    • Finding PHP Error Logs
    • Resolve ID conflicts on import
    • Common errors on importing product images
  • Third-Party Compatibility
    • Plugins
  • Changelog
    • Version 1.1.8

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

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

Last updated on September 1, 2021

When using the Import Export Suite for WooCommerce plugin, the input CSV file must be encoded in UTF-8 format. This ensures that all your post types, such as products, orders, users, etc., are imported accurately. During import, you can avoid unnecessary characters like ž, ?, etc. If the CSV file is not UTF-8 encoded, then symbols like ™, ®, ©, etc. get converted to unwanted characters.

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.

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 worldwide 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

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

Step 1 – 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.

Step 2 – 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.

Saving file in CSV format
Save file as CSV

Click on Save.

Step 3 – From the Export Text File dialog box that appears, select the Unicode (UTF-8) option from the Character set drop-down.
Step 4 – Set the field and text delimiter as you wish or leave as is.

Encode as UTF-8
Encode as UTF-8

Step 5 – Click OK.

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

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

To save the 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:

Step 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

Step 2 – Browse for the required CSV file and start uploading it.

Step 3 – Open the uploaded file with Google Spreadsheet.

Step 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 Import Export Suite for WooCommerce plugin.

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

The steps are as given below:

Step 1 – Open the CSV file with a Microsoft Excel sheet.

Step 2 – Navigate to the 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

Step 3 – Click Browse to select a location to save the file.

The Save As window appears as shown below:

Save As option in Microsoft Excel
Save As option in Microsoft Excel

Step 4 – Enter the name of the file.

Step 5 – Select the Save as type as CSV (Comma delimited) (*.csv)option.

Step 6 – Click Tools drop-down box and click Web Options. A new window for web options appears as shown below:

Web Options
Web Options

Step 7 – Under the Encoding tab, select the option Unicode (UTF-8) from Save this document as drop-down list.

Finally, click Ok, and save the file.

How to Save a CSV file as UTF-8 with Notepad?

The steps are as given below: Open the CSV file with Notepad.

Step 1 – Open the CSV file with Notepad.

Step 2 – Navigate to File > Save As option. A screenshot of the menu is as shown below:

Notepad File Menu
Notepad File Menu

Step 3 – Select the location for the file.

The Save As window appears as shown below:

Save As option in Notepad
Save As option in Notepad

Step 4 – Select the Save as type option as All Files(*.*).

Step 5 – Specify the file name with .csv extension.

Step 6 – From the Encoding drop-down list, select UTF-8 option.

Step 7 – Click Save to save the file.

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

How to Save a CSV file as UTF-8 in Apple’s Numbers?

The steps are as given below:

Step 1 – Open the file with Apple Numbers.

Step 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

Step 3 – Under Advanced Options, select Unicode(UTF-8) option for Text Encoding. A screenshot of the settings is as shown below:

Advanced Options in Apple Numbers
Advanced Options in Apple Numbers

Step 4 – Click Next.

Further settings appear as shown in the screenshot below:

Export option in Apple Numbers
Export option in Apple Numbers

Step 5 – Enter the name of the file and click Export to save your file with the UTF-8 encoding.

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

The steps are as given below:

Step 1 – Open the file with TextEdit.

Step 2 – Navigate to Format > Make Plain Text.

A screenshot of the menu is as shown below:

Format menu in TextEdit
Format menu in TextEdit

Step 3 – Navigate to File > Save.

It is shown as below:

File menu in TextEdit
File menu in TextEdit

Step 4 – From the Plain Text Encoding drop-down list, select Unicode(UTF-8).

Step 5 – Finally, click Save to save the file.

For customer queries and support, contact WebToffee support.

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

  • Was this article helpful?
  • Yes, thanks!Not really
Get the plugin

On this page

  • What is UTF-8 encoding?
  • How to Save a CSV file as UTF-8 using Libre Office?
  • How to Save a CSV file as UTF-8 using Google Spreadsheet?
  • How to Save the CSV file as UTF-8 in Microsoft Excel?
  • How to Save a CSV file as UTF-8 with Notepad?
  • How to Save a CSV file as UTF-8 in Apple's Numbers?
  • How to save a CSV file as UTF-8 in TextEdit?

This article posted in Advanced Topics, Documentation, Import Export Suite for WooCommerce, Knowledge Base, WooCommerce and tagged Aple Number, csv file, CSV file utf-8 encoded, Google Spreadsheets, MicroSoft Excel, Notepad, TextEdit, utf-8, utf-8 encoding

Written by

WebToffee Team

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

Comments (16)

  1. Sahand

    November 4, 2022

    hey i got about 1500 files that need to be change from UTF 16LE to UTF 8. is there a way to change all of them at the same time?

    Reply
    • Alan

      Alan

      November 16, 2022

      Hi,

      Sorry, we are not sure of any methods that can convert the file format of multiple files at a time. You might have to change the encoding for each file separately.

      Reply
  2. uravf bretagne

    February 16, 2021

    Le tableau s’affiche avec la ligne de chargement ondulée qui reste sans fin
    //////////////////////////////////////

    Reply
    • Alan

      Alan

      March 16, 2021

      Hi,

      Please make sure that you choose the correct delimiter when opening the file. By default the CSV will be exported with comma as the delimiter. Please make sure that your system/spreadsheet application also use the same delimiter. You can also try using spreadsheet applications like LibreOffice to view the file which has proven to be better in handling CSV files in our experience.

      Reply
  3. Ogbonna James Sunday

    September 11, 2020

    Thanks, this have saved me more that four days stress of trying to debug one large file like that. Just by saving it with utf-8 encoded make it work perfectly

    Reply
  4. Vikram Varma

    March 12, 2020

    The Notepad method works perfectly. Thanks

    Reply
  5. DemoniK

    December 11, 2019

    It’s not working for Excel. When you are saving csv, it’s save it with dos866 and it’s not depend on selected coding.

    Reply
    • Alan

      Alan

      December 12, 2019

      Hi,

      Our customers are able to save the CSV file as UTF-8 encoded without any issue using Excel. If you are having issues with saving as UTF-8 encoded using Excel then please try using other spreadsheet applications like LibreOffice.

      Reply
  6. Jake

    September 20, 2019

    Excel (on Windows), at least up to Office 2013, ignores the encoding set in ‘Web Options > Save this document as’ when saving as CSV. See https://stackoverflow.com/questions/508558/what-charset-does-microsoft-excel-use-when-saving-files#answer-2852577 for more information. A workaround might be to change your computer’s Regional and Language settings and restart.

    Reply
    • Mark

      Mark

      September 21, 2019

      Hi,

      We recommend using LibreOffice for the job as it works perfectly and gives the option to choose encoding while saving the file and also while opening the file.

      Reply
  7. shach

    May 6, 2019

    Amazing !!! you save me, thanks alot!

    Reply
  8. info1813

    info1813

    December 17, 2018

    For some reason when I import the file, afterwards, during mapping, it is showing me NO ability to select fields! Something must be going on… it says ‘DO NOT IMPORT’ as the only available options :/ Please help!

    Reply
    • Mark

      Mark

      December 17, 2018

      Hi,

      The issue you are facing might be because the delimiter of importing CSV and the delimiter specified in the plugin import settings are not same. Kindly please make sure that delimiter of the importing CSV and plugin are same. In the import page of the plugin, you have a field to specify the delimiter so that both are same.

      If the issue still persists please reach us via support.

      Reply
  9. anders

    January 5, 2017

    Hello,

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

    warm regards Anders

    Reply
    • Anindo

      Anindo

      January 6, 2017

      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.

      Reply
  10. jim

    Jim Aloye

    October 31, 2016

    This does’t work if you are using Excel for MAC OS X.

    See the article here — https://rothmanshore.com/2013/10/29/solved-editing-a-csv-with-utf-8-encoding-on-a-mac/

    You can do it on MAC but not with Microsoft Excel.

    Reply

Got any query? Please leave a comment or reach out to our support

Cancel reply

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

We develop awesome WordPress plugins & WooCommerce extensions to help build successful online businesses.

© 2023 WebToffee. All rights reserved.

Our plugins

  • GDPR Cookie Consent
  • PDF Invoices & Packings Slips
  • Product Import Export Plugin
  • User & Customer Import Export
  • Import Export Suite
  • Sequential Order Numbers
  • Smart Coupons for WooCommerce
  • URL Coupons for WooCommerce
  • PayPal Express Checkout
  • Stripe Payment Gateway
  • Subscriptions for Woocommerce
  • Product Catalog Sync for Facebook
  • PrintNode for PDF Invoices
  • Order, coupon, subscriptions for WooCommerce
  • WordPress Backup and Migration
View more +

Get Started

  • Plugins
  • Testimonials
  • Affiliates
  • We're hiring

Help & Support

  • Documentation
  • Documentation (Basic)
  • FAQ
  • Support

Company

  • Terms & Conditions
  • Privacy Policy
  • Refund policy
  • Support policy
  • License Activation

© 2023 WebToffee. All rights reserved.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of the basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website, to store user preferences and provide you with content and advertisements that are relevant. Such cookies will be stored on your browser but only upon procuring consent.

You will also have the option to opt-out of these cookies should you want to. But opting out of some of these cookies may have an effect on your browsing experience as per the descriptions elucidated against the respective categories below.

Necessary
Always Enabled
The cookies defined under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.
CookieDescription
__cfruidCloudflare sets this cookie to identify trusted web traffic.
__stripe_midStripe sets this cookie cookie to process payments.
__stripe_sidStripe sets this cookie cookie to process payments.
cookielawinfo-checkbox-advertisementSet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analyticsSet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category .
cookielawinfo-checkbox-necessarySet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category .
cookielawinfo-checkbox-preferencesThis cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
CookieLawInfoConsentRecords the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
PHPSESSIDThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policyThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.
Analytics
Analytics cookies help us understand how our visitors interact with the website. It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.
CookieDescription
_gaThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_ga_BQH8MSKD4MThis cookie is installed by Google Analytics.
_gat_gtagIdentification code of website for tracking visits.
_gidThis cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjAbsoluteSessionInProgressHotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.
_hjFirstSeenHotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.
_hjidHotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSampleHotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.
_hjIncludedInSampleThis cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
_hjIncludedInSessionSampleHotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.
_hjTLDTestTo determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.
CONSENTYouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
has_recent_activityThis cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_aiGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lrThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_orThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qsGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3dThe cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.
Advertisement
Advertisement cookies help us provide our visitors with relevant ads and marketing campaigns.
CookieDescription
_fbpThis cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
frThe cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
VISITOR_INFO1_LIVEA cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSCYSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devicesYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-idYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
Preferences
Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.
CookieDescription
_gh_sessThis cookie is used to preserve users' states across page requests.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
_hjSession_137657130 minutesNo description
_hjSessionUser_13765711 yearNo description
_octo1 yearNo description available.
_zendesk_authenticatedpastNo description
_zendesk_sessionsessionNo description available.
_zendesk_shared_sessionsessionNo description available.
edd_wp_session12 hoursNo description available.
logged_in1 yearNo description available.
m2 yearsNo description available.
Save & Accept