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


[deactivated user]

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

    August 8, 2018


    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


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

      August 8, 2018

      [deactivated user]

        Thank you!

        August 8, 2018


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

        August 9, 2018



        August 8, 2018


        Wow, this looks super useful – thanks!

        August 11, 2018


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

        November 9, 2018


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

        January 13, 2019


        Wow!! Thank you so much!!

        January 25, 2019


        Great Compilation... Thank you !

        January 27, 2019


        Wow! Děkuju!

        January 30, 2019


        You are amazing. Thank you for that.

        September 11, 2019


        Great job! Thanks

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