The Import Wizard will allow you to import a CSV or Tab Delimited file of up to 10MB.

Additionally, Cloudingo works with UTF-8 characters. Cloudingo does pick up various characters sets, but there may be some limitations—for example, Cloudingo may not see a match between “e” and “é.” These are “special” characters which we do not normally use in English, although there are Unicode characters for English which would require these two steps.

Example of special characters:

UTF8-1

To import properly you will need to convert to UNICODE using one of two methods in Excel:

Method 1

When Saving in Excel, pick “Unicode Text” as the option and save it. This should preserve those characters.

UTF8-2

Method 2

Save the file as “Unicode text” or:

  1. Open the file in Excel
  2. Highlight all
  3. Copy to the clipboard
  4. Paste into Notepad
  5. “Save As”
  6. Select “Encoding UTF-8” This is essential. You should get a warning if you try to save it as ANSI. The other Unicode formats will work and would be better with non-Roman based alphabets like Japanese or Arabic, but for Roman based scripts, UTF-8 will be the most efficient.
  7. Save with a file name extension of .csv (Yes, we know that it really is not a CSV file, but it works.)
  8. Import this new CSV file into Cloudingo.

 

Additional Information: Below is a set of steps regarding how Excel handles special characters.

JapaneseCharacter_Article