How to Save an Excel File as CSV With UTF-8 Encoding

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on August 27, 2023

This tutorial demonstrates how to save a file with a .csv extension and UTF-8 encoding from Excel.

save as utf-8 csv final data

Save a File as CSV UTF-8

CSV files can have some useful differences over XLSX, but saving an Excel file in basic CSV format can cause a problem if there are special characters or foreign letters in the workbook. In that case, when you open a CSV file it won’t be able to recognize and display those characters; they’ll be shown as question marks. Say you have the following list of special characters in several languages.

save as utf-8 csv initial data

If you save this file as CSV (comma delimited) and open it in any text editor, all special characters (foreign letters) are displayed as question marks. See below for the CSV file (without UTF-8) opened in Notepad.

excel save as csv

If you want to display all characters in CSV as they are displayed in the Excel file, save it as a CSV UTF-8 file. UTF-8 format enables text editors to properly interpret and display special characters.

  1. In the Ribbon, go to File > Save a Copy (or Save as).

excel save as csv

  1. In the new window, on the right side, choose CSV UTF-8 (Comma delimited (*.csv)) file format and click Save.

save as csv utf-8

As a result, the CSV file is saved in the same folder where the Excel file is stored, and all special characters are displayed properly when the CSV file is opened.

save as csv utf-8 2

AI Formula Generator

Try for Free

See all How-To Articles