Andrey Listopadov

Hsk 1-6 Vocabulary List Excel Instant

@linux @rant tools ~17 minutes read

Hsk 1-6 Vocabulary List Excel Instant

Title: The Ultimate Tool for Mastery: Why You Need an HSK 1-6 Vocabulary List in Excel (And How to Use It)

Column C: Pinyin (with tone marks)

  • Data: Nǐ hǎo (not Ni hao).
  • Crucial: Avoid files that use numbered tones (Ni3 hao3). Your brain needs visual tone marks.

Additional columns for advanced tracking:

  • Known? (Yes/No checkbox)
  • Review Date (for spaced repetition)
  • Mistakes (count)
  • Tags (e.g., verb, noun, measure word)

Filter 2: The Spaced Repetition (SRS) Queue

  • Filter: Last Reviewed > 7 days ago, Familiarity = 2.
  • Goal: These words are “almost remembered.” Review 20-30 per day.
  • How-to: Sort by “Last Reviewed” (oldest first). Update the date after each review.

Active Recall: Use the "hide" feature on columns (like English translations or Pinyin) to test yourself. hsk 1-6 vocabulary list excel

Introduction

  • HSK Level: The level of the vocabulary word (HSK 1-6)
  • Word: The Chinese vocabulary word
  • Pinyin: The Pinyin romanization of the vocabulary word
  • English Meaning: The English translation of the vocabulary word

: By including a "Status" column (e.g., New, Learning, Mastered), you can generate charts to see your advancement through the levels in real-time. Customizable Sorting Title: The Ultimate Tool for Mastery: Why You