Hsk 1-6 Vocabulary List Excel
Introduction
The HSK (Hanyu Shuiping Kaoshi) is a Chinese proficiency test that assesses the language skills of non-native speakers. The test consists of six levels, and each level has a corresponding vocabulary list. In this report, we will provide an Excel list of vocabulary for HSK levels 1-6.
HSK 1-6 Vocabulary List
Below is a summary of the number of vocabulary words for each HSK level:
| HSK Level | Number of Vocabulary Words | | --- | --- | | HSK 1 | 150 | | HSK 2 | 300 | | HSK 3 | 600 | | HSK 4 | 1,200 | | HSK 5 | 2,500 | | HSK 6 | 5,000 |
Excel List
The Excel list includes the following columns:
- HSK Level: The level of the vocabulary word (HSK 1-6)
- Word: The Chinese vocabulary word
- Pinyin: The Pinyin romanization of the vocabulary word
- English Meaning: The English translation of the vocabulary word
Here is a sample of the Excel list:
| HSK Level | Word | Pinyin | English Meaning | | --- | --- | --- | --- | | HSK 1 | (nǐ hǎo) | nǐ hǎo | hello | | HSK 1 | (xiè xiè) | xiè xiè | thank you | | HSK 2 | (māma) | māma | mother | | ... | ... | ... | ... |
Complete List
The complete list of HSK 1-6 vocabulary words in Excel format is as follows:
[Insert actual Excel list or provide a link to download it]
Conclusion
The HSK 1-6 vocabulary list in Excel format provides a comprehensive and organized resource for learners of Chinese to study and review vocabulary for the HSK test. With this list, learners can easily track their progress and focus on specific areas of vocabulary.
Recommendations
- Use this list as a study resource to prepare for the HSK test
- Review vocabulary regularly to improve language skills
- Practice using the vocabulary in context to enhance language proficiency
Limitations
This list only includes vocabulary words for HSK levels 1-6 and does not include other aspects of language learning, such as grammar, listening, and speaking.
Future Development
Future updates to this list could include: hsk 1-6 vocabulary list excel
- Addition of example sentences for each vocabulary word
- Inclusion of audio files for pronunciation practice
- Development of a mobile app for easy access to the vocabulary list
Mastering the Mandarin Chinese HSK (Hanyu Shuiping Kaoshi) exam requires a disciplined approach to vocabulary. An HSK 1-6 vocabulary list in Excel is one of the most effective tools for tracking progress, as it allows learners to sort, filter, and customize their study plan across the 5,000 words required for the highest level. Why Use an Excel-Based Vocabulary List?
Unlike static PDFs, a spreadsheet format provides dynamic utility for self-study:
Progress Tracking: Create status columns such as "Unseen," "Memorized," or "Active Use" to visualize your journey.
Custom Filtering: Focus on specific word types (e.g., verbs, measure words) or group words by themes like business, nature, or daily life.
Active Recall: Use the "hide" feature on columns (like English translations or Pinyin) to test yourself.
Spaced Repetition: You can build simple formulas or use conditional formatting to highlight words you haven't reviewed in over a month. Vocabulary Requirements by Level
The HSK 2.0 standard (the most common version for 1-6 lists) scales significantly at each stage: Cumulative Word Count CEFR Equivalent HSK 1 HSK 2 HSK 3 HSK 4 1,200 words HSK 5 2,500 words HSK 6 5,000 words
Note: The newer HSK 3.0 standard is also becoming available, which expands levels 1-9 and requires 3,000 characters by level 6. Where to Find HSK Lists
You can find comprehensive, pre-formatted Excel and Google Sheets trackers on several platforms: Introduction The HSK (Hanyu Shuiping Kaoshi) is a
Etsy: Numerous creators offer specialized HSK 1-6 Vocabulary Spreadsheets that include Pinyin, English translations, and built-in tracking systems. Check out popular options from SoulfulSystems or FrogiaryStudio.
AliExpress: Similar digital downloads are available, often marketed as all-in-one progress trackers.
GlobalExam: Offers downloadable vocabulary lists per level that can be copied into Excel. Organizing Your Workbook
To get the most out of your file, consider setting up separate tabs for each level (HSK1, HSK2, etc.) and a Review Log tab to track the dates of your study sessions.
Here’s a step-by-step guide to obtaining and using an HSK 1–6 vocabulary list in Excel format, including where to find reliable lists, how to structure your file, and tips for effective study.
📊 Progress Tracking
- Use Pivot Tables to see how many words you know per HSK level.
- Create a Dashboard with charts:
- % known per level
- Words added per week
Additional columns for advanced tracking:
- Known? (Yes/No checkbox)
- Review Date (for spaced repetition)
- Mistakes (count)
- Tags (e.g., verb, noun, measure word)
Column H: User Status (For your tracking)
- Data: Not Started, Learning, Review, Mastered.
- Use Excel Data Validation to create a dropdown menu here.
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.
First, What’s Inside the Standard HSK 1-6 Excel File?
A good HSK vocabulary Excel sheet should include these 5 columns:
| HSK Level | Word (汉字) | Pinyin | Definition | Part of Speech | | :--- | :--- | :--- | :--- | :--- | | HSK 1 | 我 | wǒ | I, me | Pronoun | | HSK 4 | 然而 | rán ér | however | Conjunction |
Pro tip: The new HSK 3.0 standards differ from the old HSK 2.0. This post focuses on the classic HSK 1-6 (2.0 version, ~5,000 words), which remains the most common benchmark for intermediate learners.
Column C: Pinyin (with tone marks)
- Data: Nǐ hǎo (not Ni hao).
- Crucial: Avoid files that use numbered tones (Ni3 hao3). Your brain needs visual tone marks.
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.
Column F: Word Frequency Rank (Advanced)
- Data: 1 to 5000 (based on corpus linguistics).
- Why: This tells you which words to memorize first. The word "的" (de) is HSK 1 but also frequency rank #1.