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 NEW button on the top left corner, and click Upload files option.

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

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

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

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 Options. A new window for web options appears as shown below:

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.

Did this answer your question?