Greetings Guest
home > library > journal > view_article
« Back to Articles » Journal
Import your lexicon (from Excel)
1▲ 1 ▼ 0
This public article was written by [Deactivated User], and last updated on 13 Apr 2015, 04:25.

13. Pronouns
Menu 1. The process CWS supports importing your already existing data from an excel spreadsheet (if you use this method of database) to save you manually inputting huge amounts of data.

IMPORTANT #1: when you import, and you see words with odd characters like this: �, or similar gibberish, then you need to ensure that your *.csv file was saved using UTF-8 encoding. This is not always the default, but will cause issues with your CWS import if set to anything else.

IMPORTANT #2: It is not recommended to import a large amount of lexicon into CWS when you already have a dictionary with substantial lexicon. The reason for this is that if for some reason the import fails, your only option is to painstakingly remove each word one at a time, OR purge (delete) your entire dictionary and start over. If you are importing into an existing CWS dictionary, it is recommended that you export your lexicon first in order to back this up.

VERY IMPORTANT #3: It is vital that the parts of speech in your *.csv file match the codes used on CWS. The reason for this is otherwise the CWS database will not know how to interpret your parts of speech. We use one uniform code system for these in order to avoid ambiguity (for example, would "a" be adjective, adverb, or adposition?). Excel has a find and replace feature you make use of to ensure that your file uses the same codes.

Please be aware that if you import words into the dictionary using non-standard codes and they're NOT updated (you will have a green notification banner warning you of this), they will be marked for deletion after 28 days (4 weeks), and no backups will be made.

You can find a reference of the codes here.

[top]The process

First, you need to convert your excel spreadsheet to a *.csv file. You can do this from within excel by going 'File' > 'Save As' and using the drop down at the bottom of the Save As dialogue to select *.csv (comma-separated values). This should save your excel spreadsheet to a format like this:

"word1","definition1","other information1", ...etc
"word2","definition2","other information2", ...etc
"word3","definition3","other information3", ...etc

Then, if you go to the 'Dictionary' page (under the green menu) and click the '> Import' button and follow the instructions on screen, you can import your *.csv lexicon to CWS. The instructions on the import page may be a little confusing but there are help bubbles - the blue squares with ? on them - designed to give you more information.
[link] [quote] [move] [edit] [del] 13-Sep-22 09:03 [Deactivated User]
the import function only adds the words, not their english translation or part of speech information. how do I fix this without editing each of the thousands of words one by one?
[link] [quote] [move] [edit] [del] 14-Aug-20 03:15 [Deactivated User]
Please note that nobody is informed when people leave questions on system articles. If you need help, use the forums.
[link] [quote] [move] [edit] [del] 09-Aug-16 01:56 [Deactivated User]

I think you need set those infos for your dictionary first
[link] [quote] [move] [edit] [del] 09-Aug-16 01:28 [Deactivated User]
How do I add "other information"? How will CWS know which column is the IPA pronunciation and which is the part of speech, for example?
privacy | FAQs | rules | statistics | graphs | donate | api (indev)
Viewing CWS in: English | Time now is 15-Jun-24 20:25 | Δt: 742.6138ms