Import into Excel

When importing into Excel, for certain languages, some additional steps may need to be performed so that the characters are properly displayed.

1. Open a new document in Excel.
2. Select the Data tab.
3. In the Get External Data section on the ribbon, click From Text.
   The Import Text File window is displayed.
4. Navigate to the desired csv or text file and click Import.
   The Text Import Wizard is then displayed to guide you through the steps.
5. From the File origin drop-down list, select the option best suited to the language that the file is in.
   Start with the Unicode (UTF-8) setting and check the display of the characters in the preview pane. If this setting does not work, try Unicode (UTF-7) or one of the other encoding options listed under that specific language.
6. Select the Delimited option as the file type and click Next.
7. For a csv file, select the Semicolon check box to set it as the delimiter, and then click Next.
8. Click Finish to complete the import of the file.
   The Import Data dialog box is displayed, where you can select where to place the data in Excel.