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

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

THE Czech course spreadsheet

Here it is: https://drive.google.com/open?id=1_TszDnZHxCNrHSvs_KOIa33SsojjH6fr 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 Czech 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 consonant and vowel alternations that regularly occur in Czech. There are several categories marked with different colors, you can understand what they mean when you go through the tables on the second 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 08.09.2018]: Added a note in the conjugation of být about the irregular negative form of the 3rd person singular present tense form.

[Update 09.23.2018]: Completely changed the conjugation tables. Added the comparative and superlative forms to the adjective declension tables. Classified adjectives with suppletive comparatives and superlatives as irregular. Other minor corrections.

[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 consonant and vowel alternations. Reworked many notes. Other minor corrections.


The Polish spreadsheet discussion: https://forum.duolingo.com/comment/28339394 The German spreadsheet discussion: https://forum.duolingo.com/comment/29535374 The Dutch spreadsheet discussion: https://forum.duolingo.com/comment/33287288

August 8, 2018

15 Comments


[deactivated user]

    Thank you so much for sharing this!!! =)

    August 8, 2018

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

    Wow, was it you who gave me 50 lingots??? There weren't any the last time I checked!

    August 8, 2018

    [deactivated user]

      Yes. In my opinion you deserved it. Enjoy them. ;)

      August 8, 2018

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

      Thank you so much for your generosity. :) Hope you'll find my spreadsheet useful!

      August 8, 2018

      [deactivated user]

        Thank you!

        August 8, 2018

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

        This is so amazing haha. I really appreciate you doing this. Great value! Have more lingots. :D

        August 9, 2018

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

        Amazing!

        August 8, 2018

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

        Wow, this looks super useful – thanks!

        August 11, 2018

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

        Thank you so much for the vocabulary list. This is exactly what I was looking for. Very helpful.

        November 9, 2018

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

        This is so very kind of you, exactly what I need!

        January 13, 2019

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

        Wow!! Thank you so much!!

        January 25, 2019

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

        Great Compilation... Thank you !

        January 27, 2019

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

        Wow! Děkuju!

        January 30, 2019

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

        You are amazing. Thank you for that.

        September 11, 2019

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

        Great job! Thanks

        September 28, 2019
        Learn Czech in just 5 minutes a day. For free.