Creating Bilingual Vocabulary Lists using Google Sheets

[@e-genieclimatique]

in brief: In this video, the creator demonstrates how to create bilingual vocabulary lists using Google Sheets and import them into Quizlet. They use English and Spanish as an example, but the method can work for any language. 1-Open a new Google Sheet and set up columns for each language. 2-Copy the vocabulary list from Quizlet or another source and paste it into the sheet. 3-Use the text wrapping settings to improve visibility. 4-Use the GOOGLETRANSLATE formula to translate terms and definitions from one language to another. 5-Combine the original terms with the translated terms using an ampersand and a dash as a divider. 6-Drag the formula across all terms and definitions to create a bilingual list. 7-Copy the new bilingual list and import it into Quizlet by selecting "Create" and "Import from Word, Excel, or Google Docs." 8-Paste the list into the box, click "Import," and then "Create" to have Quizlet cards with bilingual terms and definitions. While this method may not be perfect, it is a useful tool to make vocabulary more accessible for learners of different languages.

[@RS-wz4ef]

Outstanding! Exceptionally clear, complete, and concise. Thank you.

[@laikhandigitalmarketer5256]

Thank you, this way is better then any paid apps for me.

[@mihirchavda7791]

gratitude for sharing your knowledge.

[@alicelord9641]

LOVE IT! this will be so helpful

[@sapphire6442]

awesome😍 thank you

[@edrage8679]

Your spanish list is a mess, i laughed a lot. thanks!

[@alicelord9641]

is there a way to put multiple translations into the translated column? for example, strict in french being "rigide" and "sévère"

[@TeTong89]

Thank you

[@sametdemirtas2516]

when i paste the words they all stay in the a1 part can you help