Hsk 1-6 Vocabulary List Excel Portable May 2026

HSK 1-6 Vocabulary Story

| HSK Level | Required Vocabulary | Approximate CEFR Level | What you can do | | :--- | :--- | :--- | :--- | | HSK 1 | 150 words | A1 | Basic phrases, self-introduction | | HSK 2 | 300 words (150 new) | A2 | Simple daily conversations | | HSK 3 | 600 words (300 new) | B1 | Travel, work, basic fluency | | HSK 4 | 1,200 words (600 new) | B2 | Discuss complex topics, news | | HSK 5 | 2,500 words (1,300 new) | C1 | Read newspapers, give speeches | | HSK 6 | 5,000+ words (2,500 new) | C2 (near-native) | Professional literature, idioms | hsk 1-6 vocabulary list excel

Phase 3: Pivot Tables for Strategy (Day 3)

Insert a Pivot Table.
Put "HSK Level" in Rows and "Part of Speech" in Columns.
Value Field Setting: Count of Words.
Actionable insight: You will see that HSK 5 introduces 300 new measure words, while HSK 6 introduces 800 literary idioms. Adjust your memorization strategy accordingly.

File layout suggestions

Sheet1: "All levels" — full master list filtered by Level column.
Sheet2..Sheet7: "HSK1" ... "HSK6" — level-specific lists for focused review.
Sheet "Decks": columns for Anki import (Front, Back, Tags) generated via formulas.
Sheet "Stats": pivot table or formulas showing counts by level, mastered %, and most common parts of speech.
Use Excel tables (Insert → Table) so filters/sorting work easily.

Red = Don't know at all.
Yellow = Vaguely remember.
Green = Mastered.
Result: You can visually see your weaknesses. A long red column means you need to focus on HSK 4-6.

Actionable Advice: Do not try to study inside Excel. Use Excel to organize data, clean it up, and export it to Anki or Pleco for actual learning. HSK 1-6 Vocabulary Story | HSK Level |

If you are at the HSK 1 or HSK 2 level, building your own list can actually be a great learning exercise. Typing the characters, looking up the Pinyin, and writing the definitions yourself forces active engagement with the vocabulary, making the words stick better in your memory. Strategies for Studying HSK Vocabulary in Excel Insert a Pivot Table

AliExpress: Similar digital downloads are available, often marketed as all-in-one progress trackers.