How can I create a collection via CSV or TSV upload?

1. Create a CSV (comma-separated values) or TSV (tab-separated values) file.
2. Be sure the file extension is either CSV or TSV.
3. Go to your Dashboard for the language you're learning.

4. Switch to the Collections panel.

   

5. Click the down facing arrow button on "Custom Collections", and then click the "Create" option

   

   
   

6. Customize the new collection as you please.

   

7. You'll see this new custom collection inside your custom lists (Inside the collection menu). Now you'll be able to add sentences by clicking the options button, and then choosing "Add Sentences".

   Then select UPLOAD FILE.

   

   

8. Select the file and click SUBMIT.

   
   

   

IMPORTANT:

Notice that we have the followings instructions as a pop-up before submitting your file.

• IMPORTANT:

• If you're creating a regular excel file, and saving it as CSV, use one cell per "value" (Sentence, Translation Cloze...), and write the fields starting from cell A1 to the right. Then for the next sentence, start from cell A2 to the right, and subsequently (A3, A4, A5...) for as many other sentences.

For "text" CSV documents:

1. Separating "fields" by commas, as per above instructions, but leave no space between the comma and the previous and next character. (Example "HOLA AMIGO,hello friend,friend...")

For uploading sentences from a document in general (CSV, TSV, SRT):

1. The most important thing is making sure that the target and base language are correct. If you input sentences in any other language, the system won't recognize them.

Here's an example on how every line/ sentence should look.

Again, this is following the rule:

If you follow these guidelines, you will see the sentences in an "edit" view before saving each sentence inside the collection.

In the below example, you'll see how the cloze word AQUI, it's between brackets, indicating it'll be the “missing” word for this sentence. The rest of the information, is just “transcribed” from the Excel/ CSV document.

Finally, click “SAVE”, and all the sentences in your document should be added to your custom collection.