How to Save CSV in UTF-8

Written by brian valle
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Save CSV in UTF-8
You may use Notepad to encode your CSV files in UTF-8. (Thinkstock/Comstock/Getty Images)

UTF-8 is an encoding set that can contain any unicode character, yet it is as compact as ASCII. For this reason, UTF-8 is appropriate for writing code for cross-platform software. Many people use UTF-8 encoding to send and receive e-mail in various languages. Unfortunately, not all applications can encode files in UTF-8 by default, and Microsoft Excel is one of them. Instead of unicode, Excel encodes CSV files using ANSI. To get around this, you need to change Excel's default character set. If you don't have Excel installed, you may use Notepad to create a UTF-8 version of your file.

Skill level:
Easy

Other People Are Reading

Instructions

    Using Notepad

  1. 1

    Click "Start," enter "notepad" in the Search field, and press "Enter" to launch Notepad.

  2. 2

    Click "File" and then click "Open." Click the drop-down menu beside the "File Name" field, and then choose "All Files."

  3. 3

    Locate the CSV file that you want to convert to UTF-8. Select it and click "Open." This loads your CSV data onto Notepad.

  4. 4

    Open the "File" menu again, and click on "Save As." Enter your preferred file name. Be sure to include the ".csv" file extension.

  5. 5

    Click the drop-down menu beside "Save as File Type," and choose "All Files."

  6. 6

    Go to "Encoding" and select "UTF-8" from the drop-down menu. Click "Save."

    Using Microsoft Excel

  1. 1

    Launch Microsoft Excel. Click the Microsoft Office button, and then choose "Open." Select your CSV file from the list, and click "Open."

  2. 2

    Click the Microsoft Office button, and then click "Save As." Enter your preferred file name.

  3. 3

    Click the drop-down menu beside "Save as File Type," and then choose "CSV (Comma delimited)."

  4. 4

    Click the "Tools" button at the bottom of the window, and then choose "Web Options."

  5. 5

    Go to the "Encoding" tab. Under "Save this document as," click the drop-down menu and choose "Unicode (UTF-8)." Click "OK" and then click "Save."

Tips and warnings

  • Notepad may not be able to open very large files. In that case, use a more powerful text editor such as Notepad++.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.