Hsk 1-6 Vocabulary List Excel Exclusive

The Excel list includes the following columns:

Let me know how you'd like to narrow down your vocabulary goals! AI responses may include mistakes. Learn more

A unique number (1–5000) to keep the original order intact The primary characters tested on mainland China exams Traditional Chinese

You can instantly filter words by parts of speech, HSK levels, or your own difficulty ratings. hsk 1-6 vocabulary list excel

HSK Vocabulary Lists: New HSK Level 1 - 9 Words Explained - Migaku

Essential for learning pronunciation and tones. Include tone marks (e.g., mā, má, mǎ, mà ).

The power of Excel lies in its sorting capabilities. Instead of studying words in alphabetical order (which creates artificial associations), use Excel’s random number generator to shuffle the list. This forces your brain to recognize characters in isolation. Furthermore, you can use the filter tool to isolate specific parts of speech—such as filtering for all HSK 3 verbs—to do targeted grammar and sentence-building drills. Create Your Own Digital Hide-and-Seek Flashcards The Excel list includes the following columns: Let

Expressing fluency. Covers a wide range of topics, including business, minor idioms, and abstract concepts. At this point, you can converse with native speakers on most familiar topics.

Use Data Validation in Excel to create a drop-down menu for the "Status" column so you can filter by words you still need to learn.

If you want to quiz yourself, utilize the VLOOKUP or XLOOKUP formulas. Keep your master list on Sheet 1, and build a "Quiz Machine" on Sheet 2. Entering the Chinese character can automatically pull the hidden Pinyin or English definition when you click to reveal it. HSK Vocabulary Lists: New HSK Level 1 -

If you want to take your digital vocabulary notebook to the next level, incorporate these advanced spreadsheet techniques:

HSK Level | Entry No. | Simplified | Traditional | Pinyin | POS | English | Example (CN) | Example (Pinyin) | Example (EN) 1 | 1 | 我 | 我 | wǒ | pron. | I; me | 我是学生。 | Wǒ shì xuéshēng. | I am a student. 1 | 2 | 你 | 你 | nǐ | pron. | you | 你好吗？ | Nǐ hǎo ma? | How are you?

Download your preferred file today, use the strategies outlined here, and start turning a sea of characters into your own working vocabulary, one word at a time. Happy learning!

When setting up your spreadsheet, keep in mind that Hanban introduced the , which restructures the levels into a 9-band system (Beginner, Intermediate, Advanced).

Using simple formulas, you can hide columns (like Pinyin or English definitions) to test yourself directly within the sheet.