• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

how to open text files using utf8

Page history last edited by Monica 12 years, 5 months ago Saved with comment

 

Purpose : To display special characters properly, data should be encoded with UTF-8

 



 

How to open .txt files (textual data)

For documents that contain a continuous string of textual data, such as books.

 

Note Pad

  1. Open Note Pad (Programs>Accessories)

  2. File > Open

  3. Navigate to folder containing .txt files

  4. Select file to open

  5. In lower right corner, click on Encoding > UTF-8

  6. Press Open

 

 

Microsoft Word 2007

First setup MS Word preferences to automatically prompt for selecting encoding standard for txt files; see guidelines for Choose an encoding standard when you open a file

 

  1. Open .txt file

  2. Select Convert file > Encoded Text

  1. Select other encoding: Unicode (UTF-8), press OK

 

 

How to open tabular data

For documents that contain data that is organized in rows or columns, such as spreadsheets.

 

  • If file is a .txt format, recommended using Excel's text import wizard. File must be opened from within excel (not through the file manager window).  In the initial import screen,  set file type to delimited and set the file origin to 65001: Unicode (UTF-8) 

 

  • If file is a .csv format, recommended using Use "Calc" (OpenOffice). File must be opened from within Calc (not through the file manager window). At the Import Text window, set Character set to Unicode (UTF-8). File can then be saved as XLS format if desired.
    • Note:

      CSV inherently only supports ASCII text (without special characters).Therefore must change encoding of files to render special characters or diacritics properly. 

 

 

 

 

 

XLS format

Comments (0)

You don't have permission to comment on this page.