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


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



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

[deactivated user]

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


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

    [deactivated user]

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


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

      [deactivated user]

        Thank you!


        Wow, this looks super useful – thanks!


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


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


        Wow!! Thank you so much!!


        Great Compilation... Thank you !


        You are amazing. Thank you for that.


        you are such a darling!


        Thanks a lot for sharing this!!!


        I've been making my own spreadsheet, but -- this is so much more organized and helpful for the overall view of how the language works. Thank you so much for sharing this! It's a gold mine of info :D

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