https://www.duolingo.com/profile/bright_flash

THE German course spreadsheet

Here it is: https://drive.google.com/open?id=1nZDwp4zR_SvcGNJK8B126BQot0GkmHyA I was creating this document while doing the course, including any word or phrase I've seen along the way and put an English translation next to it. I did it mostly for myself, such spreadsheets help me to understand the grammar of languages better and remember the words better as well. But I thought others might find it useful as well so I decided to post it.

The first page of the document includes all vocabulary in the course (I hope I haven't missed much). All words are divided into 5 categories: nouns (the biggest one), adjectives, verbs, adverbs and all other stuff (pronouns, numerals, prepositions etc.) + there is an additional category for some quirky phrases that can't be easily broken down to translate it word by word without losing some meaning.

The second page is grammar. There are tables showing the way German declination and conjugation work plus there are exceptions listed. If you want to know how to decline or conjugate any word on the first page, you can find it out here.

The third page is a list of all vowel alternations that regularly occur in German. It's relatively simple in German since there are only 3 of them (I'm not counting the strong verb classes, those are listed on the grammar page).

That's it, I guess. If you have any questions or you find any mistakes I made while making this spreadsheet, please leave a comment here, I’ll read all of them.

[Update 07.25.2019]: Major rework. All grammar tables are now on another page. Noun gender and word classes are now in separate columns. Added a page that lists all vowel alternations. Reworked many notes. Other minor corrections.

[Update 07.27.2019]: Added the conjugations of modal verbs können, müssen, sollen and dürfen. No idea why they weren't included...


The Polish spreadsheet discussion: https://forum.duolingo.com/comment/28339394 The Czech spreadsheet discussion: https://forum.duolingo.com/comment/28367063 The Dutch spreadsheet discussion: https://forum.duolingo.com/comment/33287288

November 5, 2018

38 Comments


https://www.duolingo.com/profile/Yves--

That's a lot of hard work there, and very generous of you to share it with the forum. Karma+++ to you

November 5, 2018

https://www.duolingo.com/profile/jacs0202

What a wonderful resource! Thank you for sharing this. :)

November 5, 2018

https://www.duolingo.com/profile/Galaxy582

Thanks so much for this! I made this list into three Quizlets for easier study. Here are the links: Nouns: https://quizlet.com/_5knbnc Adjectives: https://quizlet.com/_5knd9g Verbs: https://quizlet.com/_5kne4q

(If the author of this post wants me to delete this I will)

November 6, 2018

https://www.duolingo.com/profile/bright_flash

No, that's great! I love it. However, that makes me think if I should write declension/conjugation types in a different column, because without any context those numbers and letters in brackets look... strange.

November 6, 2018

https://www.duolingo.com/profile/Galaxy582

:) Yes I see what you mean. I might remove them from the Quizlets if I have time.

November 6, 2018

https://www.duolingo.com/profile/AlHut

Great job. Thanks for sharing.

November 6, 2018

https://www.duolingo.com/profile/AmberjackCZ

OMFG! You're my hero. I do not give them away easily, but... lingots for you :-)

November 6, 2018

https://www.duolingo.com/profile/az_p
Mod

    Wow!

    November 6, 2018

    https://www.duolingo.com/profile/Jonathan221676

    Thanks

    November 5, 2018

    https://www.duolingo.com/profile/Sencez

    I love this

    November 5, 2018

    https://www.duolingo.com/profile/TimPeterso13

    Thanks so much!!!

    November 6, 2018

    https://www.duolingo.com/profile/Susan242221

    What a Herculean effort!!! Thanks for posting.

    November 6, 2018

    https://www.duolingo.com/profile/ThiagoLech4

    Obrigado, thank you, muchas gracias, merci, ありがとう!

    November 6, 2018

    https://www.duolingo.com/profile/Dessert-Rose

    Wow! That's a lot of work! Vielen, vielen Dank! :D

    November 6, 2018

    https://www.duolingo.com/profile/jamie883760

    youre a god :') ty

    November 5, 2018

    https://www.duolingo.com/profile/Darren_Islar

    This is super. Thank you so much!

    November 6, 2018

    https://www.duolingo.com/profile/Galaxy582

    Thanks! Have a few lingots!

    November 6, 2018

    https://www.duolingo.com/profile/JoieB54

    What an awesome thing to do!! Thank you so much for all your hard work, and for sharing it as well!

    November 6, 2018

    https://www.duolingo.com/profile/Kay596649

    Wow! I can't believe you did all this and are sharing it with us! Thank you so much! I love learning German and this will help so much!

    November 6, 2018

    https://www.duolingo.com/profile/Marie-Gaye

    How wonderful. Thank you!

    November 6, 2018

    https://www.duolingo.com/profile/emma829439

    Thank you - lingots to you- very generous.

    November 6, 2018

    https://www.duolingo.com/profile/Andreas234516

    nice. you are very altruistic. much appreciated!!

    November 6, 2018

    https://www.duolingo.com/profile/praveenrang

    Thank you!!!

    November 6, 2018

    https://www.duolingo.com/profile/Callie69107

    Thanks. This is great. So nice of you to share.

    November 7, 2018

    https://www.duolingo.com/profile/Denaniel

    Sehr sehr hilfreich. Tausend Dank. Ich gebe dir Lingots, natürlich.

    November 7, 2018

    https://www.duolingo.com/profile/Francois8079

    Da real MVP you are Sir. Thank you. As Many Lingots as you need.

    November 7, 2018

    https://www.duolingo.com/profile/donmac34

    Respect!

    November 7, 2018

    https://www.duolingo.com/profile/ClarisaRuc

    Danke sehn, Bright Flash!! Ich bin new bei Duo und das ist toll!!

    November 7, 2018

    https://www.duolingo.com/profile/willne1everlovem

    Thanks for sharing this.Bless you!

    November 7, 2018

    https://www.duolingo.com/profile/Katherine491732

    This is fantastic! Thank you!!

    November 7, 2018

    https://www.duolingo.com/profile/WolfAccada

    This must have taken you 2 YEARS. & thanks for sharing this info with everyone

    November 7, 2018

    https://www.duolingo.com/profile/Simone917527

    This is amazing! Thank you for doing this.

    November 9, 2018

    https://www.duolingo.com/profile/DanielZeli3

    2 lingots for you! This will really help!

    November 10, 2018

    https://www.duolingo.com/profile/Linus0915

    Thanks big bro. This is of great help. I am keep a German course and planned to make a spreadsheet like this by me but just don't know how to start it. Thanks again for sharing it.

    November 10, 2018

    https://www.duolingo.com/profile/ArtWard

    Fantastic work. Much appreciated.

    November 11, 2018

    https://www.duolingo.com/profile/beagoodone

    this is great. thank you for your dedication!

    November 22, 2018

    https://www.duolingo.com/profile/Melle505625

    Grossartige Arbeit! Eine kleine Anmerkung zu: Hand drücken /shake hands: man sagt durchaus jemandem die Hand schütteln, oder jemandem die Hand geben. Jemandem die Hand "drücken" wir eher nicht bei der Begrüßung, sondern eher emotionaler gemeint, z.B. wenn ein Gegenüber getröstet werden soll, das ist nicht das Übliche auf-und-ab-bewegen der Hände bei der Begrüßung.

    July 25, 2019

    https://www.duolingo.com/profile/bright_flash

    Danke für deinen Kommentar! Ich glaube dir dass du die Wahrheit sagt, aber ich habe diese Phrase in meiner Tabellenkalkulation eingeschlossen weil sie so in dem Kurs war. Ich bin (noch) nicht deutschsprachig, also weiß ich keine solche Phrasen und muss dem Kurs vertrauen... Wenn du denkst dass es nicht richtig ist, sollst du den Kursmoderatoren danach fragen.

    P.S. Entschuldigung wenn ich viele Fehler gemacht habe!

    July 26, 2019
    Learn German in just 5 minutes a day. For free.