1. Forum
  2. >
  3. Topic: German
  4. >
  5. THE German course spreadsheet


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



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


Great job. Thanks for sharing.


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


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


What a Herculean effort!!! Thanks for posting.


This is super. Thank you so much!


Thanks! Have a few lingots!


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)


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.


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


Thanks for the quizlets! That looks like a great tool! I might be making my own as the one item that I struggle with is learning the article with the word so I may be making a version that includes that with the German noun.


Your Quizlets are wonderful. May I suggest that you include the appropriate articles for all nouns. Thanks, Cecelia


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


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


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


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!


How wonderful. Thank you!


Thank you - lingots to you- very generous.


nice. you are very altruistic. much appreciated!!


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


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


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


Thanks for sharing this.Bless you!


This is fantastic! Thank you!!


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


This is amazing! Thank you for doing this.


2 lingots for you! This will really help!


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.


Fantastic work. Much appreciated.


this is great. thank you for your dedication!


Thanks a lot, @bright_flash I love what you created and shared with the community, especially the grammar portion.


Wow, this is amazing! Thank you sharing this. Gave away my first Lingot ;)


WOW! So helpful, this is making studying with my grandma THAT much more accessible. Many thanks!


I greatly appreciate this list and all the work you put into it. Thank you for sharing it. I double checked your nouns against the list I was keeping and (I think) the following are missing if you want to update.

Branche Chef Daten Delfin Dokument Erwachsene Innere Kritik Mittag Mittel Pappe Partei Planung Politiker Rechte Umgang Urgroßvater Weise Zeit Zeug


Thank you so much for your help! It seems like I missed some very important words, oops... Gotta add them soon(ish).


OK, I've been checking your list of words right now and can say the following things:

Daten - I have the word Datum in my list, Daten is the plural of that.

Delfin - I have a word for that in my list but it's written as Delphin. As far as I can tell, the form Delphin is more common but I added Delfin as well.

Innere - I have the word Inneres in my list, Innere is an inflected form.

Mittag - good catch, missed that one. In my course it was used only in the context of essen zu Mittag, maybe that's why I forgot to include it.

Rechte - I have the word Recht in my list, Rechte is the plural of that. Rechte can be used as a nominalized adjective meaning "the right side" but it wasn't used in this context in my course.

Zeit - another good catch, don't know how I missed this word. It's added now.

Zeug - another rightful addition to my list.

Apparently, I never encountered all other words you mentioned. I checked the Words section on Duolingo and these words just weren't there. Perhaps they were present in your course, if so, you can add them to your file yourself. :) But since I didn't meet them, I'll not include them.


Thank you for this. I was looking for sources to make my own study spreadsheet so this saved a lot of time.




This is brilliant. Thanks so much for your hard work.


The spreadsheet which I created on MsExcel has 4 columns (masc./ fem./ neuter/ plural). The listing of the German words are kept in alphabetical order. Say, for instance, the word "Kind" (child). The listing of "Kind" would come under Column A. In parenthesis, the meaning appears. This way, every day, I take a column to review. Because I am reviewing, Column A, automatically my mind can recall all the masculine words in that column. This reinforces the appropriate articles for nouns, etc.

Best, Cecelia


This is amazing! Thanyou! Can someone explain me the column with nouns and its class?


Thanks. :) The class column marks the noun's declension paradigm. Basically what forms you should use for all 4 German cases in singular and plural. For further reference see the sheet called "grammar".


You're tha Mann.


Thank you for sharing this. This amazing work. You effort will help others get a better grasp of this beautiful language.


Exactly what I needed, thanks for the same, one lingot from me.


This is very useful! thank you!


Hello, thank you for this list. Is it possible to use it in a research paper? And could you tell me until which levels does it cover?


Sure, you can use it however you want! It should cover everything in the course but I made it almost 2 years ago and some things might have changed since then


thank yo so much!


Thank you so much, such a great job




Thank you man, so helpful!


I was looking for this! Danke!


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


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.


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!


Hallo bight_flash. Das war nur als Ergänzung gemeint...Du schreibst schon sehr gut in deutsch!


I'm a bit lost - is this for the Duolingo German course? Your vocab list looks like you started with all the stuff I ideally would have liked to study with. Unfortunately for me, my beginning trees' nouns are all along the lines of Apfel, Brot, Wasser, Katzen, Hause, Kleid, Mutter.... Dates isn't taught until the 4th tree, and Business 1 is the 8th bubble of the 6th tree :(. I started Duolingo last year too. Did Duolingo really change things up or does anyone know why our trees are placed so differently? Is there some setting to set your Duolingo learning geared towards different goals?


Hello Lion...Yes, it was an answer to a question for the German course. I think, it´s possible to jump forward. Perhaps only , if you pass the next checkpoint well. Checkpoints are the towers with flags. Sorry for my bad english- hope its ok for you. To the best of my knowledge it isn´t possible to set learning to self-chosen goals.


I don't really know what you mean, tbh. This list includes all words that I've seen in my English-German course. Also why is it unfortunate that you start with nouns Apfel, Brot, Wasser etc??? These are some of the most important words to know while learning a different language. Maybe my tree had some differences but I'm sure it was mostly the same.

Learn German in just 5 minutes a day. For free.