Hsk 1-6 Vocabulary List Excel _verified_ Jun 2026
The phonetic system with tone marks (e.g., nǐ hǎo ). This teaches you how to pronounce the word correctly.
Basic, everyday phrases (e.g., 你好, 谢谢). HSK 2 (150 new, 300 total): Simple daily communication.
The ultimate use of an HSK Excel list is turning it into digital flashcards. You can export your Excel sheet as a CSV file and import it directly into , allowing you to use Spaced Repetition System (SRS) technology to memorize the entire HSK 1-6 vocabulary. Where to Find HSK 1-6 Excel Vocabulary Lists
Formula Example: =XLOOKUP(A2,MasterList!C∶C,MasterList!E∶E)Formula Example: equals cap X cap L cap O cap O cap K cap U cap P open paren cap A 2 comma MasterList exclamation mark cap C colon cap C comma MasterList exclamation mark cap E colon cap E close paren Transitioning to the New HSK 3.0 9-Level System hsk 1-6 vocabulary list excel
Filtering allows you to hide higher-level words so you can focus entirely on your current target level.
offers the most up-to-date PDF lists for the HSK 3.0 standards (Levels 1-9). Mandarin Bean 💡 Vocabulary Overview by Level
Below is a concise, actionable plan and a ready-to-build Excel layout for HSK 1–6 vocabulary lists, plus tips for sourcing, organizing, and using the file for study or teaching. The phonetic system with tone marks (e
Use Excel's conditional formatting feature to color-code your "Mastery Status" column. Set "New" to light red, "Reviewing" to light yellow, and "Mastered" to light green. Your ultimate psychological goal is to turn the entire sheet green. Step 3: Self-Testing with Hidden Columns
Prioritize words with a higher "frequency index" to learn the most useful vocabulary first. Self-Testing:
Fluently discuss a wide range of topics; converse with natives Read Chinese newspapers, watch movies, write long essays HSK 6 HSK 2 (150 new, 300 total): Simple daily communication
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)
Use conditional formatting to highlight words you struggle with.
If you possess basic coding skills, you can scrape public HSK tables from online dictionaries directly into an Excel format using Python tools like Beautiful Soup or Pandas. Final Thoughts
While mobile applications like Anki or Pleco are excellent for on-the-go review, a centralized Excel spreadsheet offers distinct advantages for macro-level planning and deep analytical study. 1. Complete Customization
If you want, I can: