This request is actually unrelated to WorldServer
. It is a general file conversion problem. The problem in this case is a general limitation in Microsoft Excel
's capability to read the characters in this format (CSV). This is a well known issue and you can find many articles about this on the Internet.
The easiest method is to use Google Docs
to perform the coversion. Here are the steps to be followed:
- Log in to your Google account (or create one if you do not have one yet)
- On the Drive screen, click on New to create a new file and choose Google Sheet > Blank spreadsheet. A new, empty spreadsheet will open up.
- From the File menu choose Import and click on the Upload tab.
- Now drag and drop your XLSX file into the window
- An Import File window will appear.
- Select the option Replace spreadsheet (which is selected per default).
- Click Import. The file gets imported and is automatically opened. You will see that it displays nicely.
- Go to File > Download > Comma Separated Values (.csv, current sheet)
- The file will be downloaded in CSV format and will be automatically named Untitled spreadsheet - Sheet1.csv. Rename it to your original file name but with the correct CSV extension.
The CSV file created this way preserves the language encoding. If you open it in Microsoft Excel,
you will still not be able to view the proper fonts. As mentioned, this is an Excel limitation.
But if you open the file in Notepad++
or in a free XML Editor like Foxe
(which can be downloaded from here
), you will see that the characters display correctly. The CSV file can now be imported into your WorldServer Term Database