Sentence structures, complex conjunctions, and functional workplace expressions.
Clear, concise definitions. Keep these brief to avoid cluttered rows.
Most Excel lists are organized by HSK Level (Columns) or grouped into rows by level.
Start adding a "Part of Speech" column. Understanding whether a word is a measure word, adverb, or preposition prevents grammatical errors. HSK 5 & HSK 6: Advanced Fluency hsk 1-6 vocabulary list excel
While textbook glossaries and flashcard apps like Anki are useful, they lack the ultimate flexibility that spreadsheet software offers. Excel allows you to become the architect of your own learning process.
Clear, concise definitions. For words with multiple meanings, list the most common HSK-tested definitions first.
Once your spreadsheet is populated, avoid just reading down the list line by line. Instead, use Excel’s native data tools to study smarter. 1. The "Randomize and Hide" Strategy (Self-Testing) Most Excel lists are organized by HSK Level
Change the font color to white (matching the cell background) to make it invisible.
(Note: If you are focusing on the newer HSK 3.0 standards, the total vocabulary bands scale up to 11,092 words across 9 levels, which makes the organizational power of Excel even more vital.) Tips for Creating or Finding the Perfect List
| HSK Level | Vocabulary | | --- | --- | | 1 | 我 (wǒ), 你 (nǐ), 好 (hǎo), 谢谢 (xiè xiè) | | 2 | 家庭 (jiā tíng), 学校 (xué xiào), 工作 (gōng zuò) | | 3 | 卡片 (kǎ piàn), 本地人 (běndì rén), 街道 (jiē dào) | | 4 | 经理 (jīnglǐ), 公司 (gōngsī), 市场 (shì chǎng) | | 5 | 美食 (měi shí), 饺子 (jiǎo zi), 火锅 (huǒ guō) | | 6 | 文化 (wén huà), 茶叶 (chá yè), 书籍 (shū jí) | HSK 5 & HSK 6: Advanced Fluency While
If you are aiming for the newer standard, simply add an extra column titled to your Excel file. This allows you to cross-reference the classic 1–6 vocabulary with the updated bands, ensuring that your study material stays relevant no matter which version of the test you take. Conclusion
Do not manually type your study status. Use to create a clean dropdown menu for your "Status" column. Select your status column. Go to the Data tab →right arrow Data Validation . Choose List and type: Not Started, In Progress, Mastered . 2. Conditional Formatting for Visual Clues
Having an Excel file of the HSK 1-6 vocabulary list provides several benefits:
: Provides detailed breakdowns of the 2026 HSK word counts and levels for exam preparation LTL Language School Mandarin Bean