Importing vocabulary csv file

Hi everyone,

I have just started with LingQ and want to import vocabulary from another program. Fairly large amount - some 22,000 words and translations. However, looking at the form it says I have to label colums as:

term, phrase, tag1, tag2, meaninglanguage1, meaning1, meaninglanguage2, meaning2

However, I only have 1) the term/word/phrase 2) the translation. How should I set out the CSV file? Do I have to include all those columns even if they are empty?

Thanks for any help you can provide

The required fields are:

  • Term
  • Phrase
  • Meaninglanguage1
  • Meaning1

The term is what goes in the phrase. The phrase is necessary so that you can do a fill in the blank vocabulary review activity. You also need the meaning (the translation), and you must indicate the language of the meaning.

Hereā€™s more info: How to import vocabulary

Thanks Shelbina! Presumably if I donā€™t have the phrase for some of the words, the vocabulary will still be imported, I just wonā€™t be able to do the blank vocab review

Btw the admins - just so you are aware this instruction page and the vocabulary upload page currently donā€™t match, so would be worth changing How to import vocabulary

1 Like

@ryan1992 Thatā€™s correct.

Thanks Zoran - a final question: is there a way, when importing vocabulary, to set that the word is already known? I.e. to grade it on the 1-5 system LingQ uses. Thanks for the assistance

Thereā€™s no way to mark a word as Known when importing it. However, you can do a ā€œmass updateā€ to select items from your Vocabulary list once imported. Check the boxes to the left then click More Actionsā€¦

Thank you, itā€™s been updated.

1 Like

Thanks!

Ok so I am having a few problems setting this up correctly. When I try to import a csv file using the rubrics mentioned in the now updated guide, lingq comes back with you need to use: ā€œterm, phrase, tag1, tag2, hintlanguage1, hint1, hintlanguage2, hint2ā€ When I try that instead, I get an internal error.

So any further advice on how to import the vocabulary (or whether this is just an internal error) would be much appreciated!

@ryan1992 Make sure to use the language code instead a full language name under the ā€œhintlanguageā€ column. I see that you are learning German, so make sure to add ā€œdeā€ instead of ā€œgermanā€. I assume thatā€™s the problem, but if not, let me know.

Thanks - this was Latin actually - what is the language code for that?

And just a quick note again, if that is case worth updating this info page once more (where the example shows ā€˜Englishā€™ rather than the code)

Right, just managed to import a csv file for German (this time using the language code and using the headings asked for by the form, not in the newly updated guide). This time, it saved my words but no definitions. Would I be better off emailing technical support?

I canā€™t post screenshots here I think but this latest file used term phrase tag1 tag2 hintlanguage1 hint1 as the headings with my translations under ā€˜hint1ā€™ so I am not sure why those werenā€™t imported.

And (sorry to post so much - just trying to work out what is and isnā€™t working with this system), I tried a second time using those new headings suggested in the support post above (meaning, rather than hint format) and again the file wouldnā€™t upload.

@ryan1992 Sure, feel free to send your CSV file to support(at)lingq.com and Iā€™ll take a look.