Edit an exported Unicode text file in Excel

You can edit an exported Unicode text file in Microsoft Excel (recommended).
To edit an exported Unicode text file in Excel
  1. Open Excel, and from the
    File
    menu, select
    Open
    .
  2. In the
    Open
    dialog box, make sure that
    All Files
     is selected, select the file you are going to edit, and click
    Open
    . The Text Import Wizard opens.
  3. In Step 1 of the Text Import Wizard, select the following options and click
    Next
    :
    • Choose the file type that best describes your data: Delimited
    • Start import at row: 1
    • File origin: Windows (ANSI)
  4. In Step 2, select the following options and click
    Next
    :
    • Delimiters the data must contain: Tab
       (make sure the other check boxes are cleared.)
    • Treat consecutive delimiters as one
      : clear the check box
  5. In Step 3, for
    Column data format
    , select
    General
    .
  6. Click
    Finish
    .
The first seven lines of the Unicode file explain what you can and cannot change in the file.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal