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

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

73 Comments


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

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


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

Great job. Thanks for sharing.


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

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


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

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


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

What a Herculean effort!!! Thanks for posting.


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

This is super. Thank you so much!


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

Thanks! Have a few lingots!


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)


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.


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

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


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

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.


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

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


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!


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

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


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


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!


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

How wonderful. Thank you!


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

Thank you - lingots to you- very generous.


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

nice. you are very altruistic. much appreciated!!


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

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


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

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


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

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


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

Thanks for sharing this.Bless you!


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

This is fantastic! Thank you!!


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

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


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

This is amazing! Thank you for doing this.


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

2 lingots for you! This will really help!


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.


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

Fantastic work. Much appreciated.


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

this is great. thank you for your dedication!


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

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


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

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


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

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


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

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


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

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


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

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.


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

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


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

VIELEN DANK!!!


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

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


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

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


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

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


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

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".


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

You're tha Mann.


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

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


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

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


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

This is very useful! thank you!


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

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?


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

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


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

thank yo so much!


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

Thank you so much, such a great job


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

VIELEN DANK!!!!!


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

Thank you man, so helpful!


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

I was looking for this! Danke!


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

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


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.


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!


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

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


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

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?


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

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.


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

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.