Downloading the list is just the first step. Here’s how to transform it into a powerful study tool.
Excel pairs perfectly with , a powerful spaced repetition system (SRS) app.
If you are interested, I can also provide tips on creating a study schedule, or show you how to set up flashcards using the spreadsheet. Just let me know what you need next. New HSK Vocabulary (2026 | PDF Available) - Mandarin Bean hsk 1-6 vocabulary list excel
When building or downloading your Excel sheet, verify which version of the HSK exam it targets.
Use the =RAND() function to generate a random number next to each word. Then, sort your table by this column to create a fresh, randomized word list for each study session, helping you avoid the "order memorization" trap. Downloading the list is just the first step
Clear, concise translations. Keep definitions short for quicker memorization.
This version features a total of 5,000 words spanning from HSK 1 (150 words) to HSK 6 (2,500 words). It remains the standard reference for many historical exam papers and legacy learning materials. If you are interested, I can also provide
Create a "Box" or "Level" column numbered 1 to 5 in your spreadsheet. New words start at 1. If you remember a word during review, upgrade it to 2. If you forget it, drop it back to 1. Use Excel’s tool to isolate only the rows marked "1" or "2" for daily intensive review. 2. Leverage Conditional Formatting Set up automated color coding to keep you motivated: