If you are reviewing a specific Excel file, check for these three things:
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.
For students of Chinese, an HSK 1-6 vocabulary list in Excel is a powerful alternative to standard PDFs or apps. While a PDF is static, a spreadsheet allows you to filter by word type, track your personal progress, and even generate your own study materials like flashcards or practice quizzes. HSK 1-6 Vocabulary Breakdown
The traditional HSK 2.0 system (still widely used for current exams) requires a cumulative total of 5,000 words across six levels. Words to Learn Difficulty Focus Areas Level 1 Basic phrases and daily life items Level 2 Basic daily communication and conversations Level 3 Navigating daily life with more complex expressions Level 4 Intermediate Discussing social and cultural topics Level 5 Intermediate Communicating confidently in diverse situations Level 6 Professional terms (medicine, finance) and culture
Note: The newer HSK 3.0 standard has adjusted these counts (e.g., Level 1 now requires 300 words), but many Excel templates still follow the 2.0 structure. Why Use Excel for HSK Study?
Spreadsheets provide a level of organization that static lists cannot match: New HSK Exam (Explained For 2026) // Full Word List & Quiz
Finding a solid HSK 1-6 vocabulary list in Excel is a game-changer for tracking your progress. Here are the best ways to get your hands on a comprehensive spreadsheet, whether you want a pre-made tracker or a free raw list. Top Ready-to-Use HSK Spreadsheets
If you want something already formatted with progress trackers and categorization, professional templates are a great choice.
HSK 1-6 Vocabulary Spreadsheet (SoulfulSystems): This is a highly-rated option available on Etsy that includes English translations, pinyin, and a categorization system. It features:
Level-specific tabs: Separate sheets for HSK 1 through 6 to keep your study organized.
Progress Tracking: Includes drop-down menus to mark your familiarity with each word.
Full Coverage: Contains all words required for the standard HSK 1-6 curriculum.
New HSK 3.0 1-9 Vocabulary Spreadsheet: For those looking ahead, sellers on Etsy offer updated lists that cover the new 9-level standard, including character trackers and frequency data. Where to Find Free HSK Data
If you prefer to build your own Excel sheet, you can find the raw data from these authoritative sources:
GlobalExam: They provide downloadable vocabulary lists per level, which you can easily copy and paste into Excel.
Dig Mandarin: Offers detailed HSK level guides, including the 2,500 words required for HSK 5.
HSK Academy: Typically offers free PDF or CSV downloads of the official word lists that are perfect for importing into a spreadsheet. Recommended Excel Structure
If you're putting the "piece" together yourself, I recommend setting up your columns like this: Hanzi (Simplified) English Meaning Status (Known/Learning/New) to prepare
Pro Tip: 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.
Using an Excel spreadsheet to manage HSK 1-6 vocabulary transforms a daunting list of 5,000 words into a structured, actionable study plan. It moves beyond simple memorization by providing a customizable framework for tracking progress, identifying weak spots, and integrating active recall techniques. The Role of Structure in Language Acquisition
Mastering the HSK (Hanyu Shuiping Kaoshi) levels 1 through 6 requires a systematic transition from basic daily interactions to complex, professional discourse. An Excel-based HSK 1-6 vocabulary list
serves as a digital backbone for this journey, offering several advantages over traditional physical flashcards: Progress Visualization
: By including a "Status" column (e.g., New, Learning, Mastered), you can generate charts to see your advancement through the levels in real-time. Customizable Sorting hsk 1-6 vocabulary list excel
: Unlike static lists, Excel allows you to sort by Radical, Pinyin, or Part of Speech, helping you find patterns in how Chinese characters are constructed. Active Recall Integration
: You can hide the "Meaning" or "Pinyin" columns to test yourself, effectively creating a self-correcting study tool. Efficiency and Personalization
A major hurdle in HSK 1-6 prep is the sheer volume of "synonyms" and nuanced terms in the higher levels. A spreadsheet allows you to add a "Notes" column where you can record specific sentence examples or personal mnemonics. This turns a generic word list into a personalized linguistic map tailored to your specific learning hurdles. Transitioning to HSK 3.0
It is worth noting that while the 1-6 system remains a standard, many learners are now looking toward the new HSK 3.0 1-9 system
. Using an Excel format makes it easy to update your existing data or cross-reference words between the two systems without starting from scratch. list the specific columns
you should include to make your spreadsheet as effective as possible for HSK prep?
Title: The Ultimate Tool for Mastery: Why You Need an HSK 1-6 Vocabulary List in Excel (And How to Use It)
Introduction If you are learning Mandarin Chinese, you have probably stared at the official HSK vocabulary list until your eyes crossed. From the 150 words required for HSK 1 to the daunting 5,000+ for HSK 6, the journey feels like climbing a mountain.
But here is the secret that top scorers know: A PDF is for reading; an Excel spreadsheet is for mastering.
Let’s talk about why the humble Excel sheet is the best weapon for conquering the new or standard HSK 1-6 vocabulary lists.
Why Excel beats Flashcards (Sometimes) While apps like Anki or Pleco are great for Spaced Repetition Systems (SRS), they lack the "helicopter view." An Excel file allows you to:
What Should Your HSK Excel Sheet Contain? Don't just download a list with "Chinese, Pinyin, English." A professional-grade HSK 1-6 Excel file should include these 7 columns:
How to Download a High-Quality List You have two options:
Option A: The "Old HSK" (1-6) This is the classic standard. Many legacy resources use this 5,000-word structure. It is widely available for free via university resources or GitHub repositories. Search for: "HSK 1-6 vocabulary Excel GitHub."
Option B: The "New HSK 3.0" (1-9) China updated the standards in 2021. The new "Level 6" is roughly equivalent to the old "Level 4/5," and it goes up to Level 9. If you are starting fresh, use the new standard. However, most current textbooks still use the old 1-6 standard.
5 Smart Ways to Use Your Excel Sheet
1. The Traffic Light System Add a column for "Status." Color code:
2. Random Generator
Use the =RAND() function in Excel to sort your list randomly. This prevents you from "guessing" the word based on the previous word's context.
3. Custom Exam Builder Filter for "HSK 4" + "Verbs." Copy those 300 rows into a new tab. Print it. Now you have a targeted study guide for next week's verb quiz.
4. Pronunciation Drill Hide the Pinyin column. Try to read the Hanzi aloud. If you hesitate, unhide the Pinyin and highlight the row red. This is much faster than flipping pages in a book.
5. Merge with ChatGPT Export your "Red" (weak) words as a CSV. Upload them to ChatGPT and ask: "Create a short story using only these 20 HSK 5 words."
Where to Find the File (Free Sources) I cannot host the file directly here due to copyright variations, but here are three reliable places to download the HSK 1-6 vocabulary list in Excel format right now: If you are reviewing a specific Excel file,
Pro Tip: Don't Just Collect. Schedule. It is easy to download the HSK 1-6 Excel sheet, look at the 5,000 rows, and feel overwhelmed. Don't try to eat the whole elephant.
Open the sheet today. Hide Levels 2-6. Focus only on Level 1. Once you have 5 green checkmarks, unhide Level 2 row by row.
Conclusion The HSK 1-6 vocabulary list is a marathon, not a sprint. A PDF is a static snapshot. An Excel spreadsheet is a living, breathing tool that adapts to your brain. Download the sheet, add your color codes, and start sorting your way to fluency.
Have you found a better way to organize your HSK words in Excel? Let me know in the comments below!
Note: Always verify that your downloaded Excel file matches the official Hanban standards, especially if you are taking the test soon.
To generate a comprehensive HSK 1–6 vocabulary list in Excel, you should organize your spreadsheet into separate tabs for each level (HSK 1, HSK 2, etc.) to manage the word count effectively, which ranges from 150 words at HSK 1 to 5,000 words at HSK 6. Recommended Excel Structure
For each tab, use the following columns to ensure the list is study-ready:
Column A: HSK Level — Useful for filtering if you later combine tabs. Column B: Hanzi (Simplified) — The Chinese characters.
Column C: Pinyin — The pronunciation guide with tone marks. Column D: English Definition — Clear translations.
Column E: Word Category — Part of speech (e.g., Noun, Verb, Adjective, Measure Word) to help with grammar.
Column F: Mastery Status — Use a dropdown menu (e.g., "Unseen," "Learning," "Memorized") to track progress. Where to Source Data
You can download pre-made lists or copy data from these authoritative sources:
Official List (HSK 2.0): Most current exams still follow the 2012 syllabus (5,000 words total for levels 1–6). Complete lists are available on HSK Academy or downloadable as spreadsheets from Konfuzius-Institut Leipzig.
New HSK (3.0): If you are preparing for the updated curriculum, note that word counts have increased (e.g., HSK 1 now requires 300 words). You can find these updated lists on Mandarin Bean or hskcourse.com.
Ready-to-Use Templates: Premium spreadsheets with built-in tracking and categorization are available on platforms like Etsy. Advanced Excel Tips for Learners
The official HSK (Hanyu Shuiping Kaoshi) vocabulary lists are the foundation for mastering Mandarin Chinese, transitioning from basic survival phrases to academic fluency. With the upcoming implementation of the HSK 3.0 standard in July 2026, learners must distinguish between the current 6-level system and the new 9-level structure. HSK 1–6 Vocabulary Overview
Historically, the HSK system was capped at Level 6, comprising roughly 5,000 words. The new HSK 3.0 system significantly expands these requirements to better align with international CEFR standards. HSK 2.0 (Current) HSK 3.0 (New) Key Competencies HSK 1 Basic greetings, numbers, and survival Chinese HSK 2 Daily routines, simple hobbies, and basic opinions HSK 3 1,000 words Travel, health, and social relationships (B1 level) HSK 4 1,200 words 1,978 words Reading contemporary fiction and news (B2 level) HSK 5 2,500 words 3,557 words
Business, formal writing, and nuanced expressions (C1 level) HSK 6 5,000 words 5,456 words
Specialized fields, literature, and academic fluency (C2 level) Why Use an Excel Vocabulary List?
Excel is a preferred tool for serious learners because it allows for: HSK Level 6 vocabulary list - Konfuzius-Institut Leipzig
HSK 1-6 Vocabulary List in Excel is a versatile digital tool used to track and master the thousands of words required for the Chinese Proficiency Test. By organizing these words in a spreadsheet, learners can create custom study schedules, filter by topic, and easily import data into flashcard apps like Vocabulary Breakdown by Level
The standard HSK 2.0 curriculum includes a total of 5,000 words. Many Excel templates are organized into tabs representing each level: Word Count Difficulty / Goal Basic greetings, numbers, and family Daily situations and simple personal info Intermediate communication for work/travel 1,200 words Discussing diverse topics fluently with natives 2,500 words Reading newspapers and watching movies 5,000 words Understanding professional and complex info Key Benefits of the Excel Format Actionable Advice: Do not try to study inside Excel
HSK 1-6 Vocabulary Story
Imagine you are a young professional, 我 (wǒ), living in Beijing. You've just been promoted to a new role as a marketing manager (经理, jīnglǐ) at a tech company (公司, gōngsī). Your goal is to learn Chinese and improve your career prospects.
You start by learning basic phrases like 你好 (nǐ hǎo), 谢谢 (xiè xiè), and 再见 (zài jiàn). Your teacher, 老师 (lǎo shī), recommends an Excel spreadsheet with the HSK 1-6 vocabulary list. You decide to learn one word per day, using flashcards (卡片, kǎ piàn) and practicing with native speakers (本地人, běndì rén).
As you progress, you learn words like 家庭 (jiā tíng), 学校 (xué xiào), and 工作 (gōng zuò). You start to notice Chinese characters (汉字, hàn zì) everywhere in your daily life, from street signs (路标, lù biāo) to restaurant menus (菜单, cài dān).
One day, your company sends you to Shanghai for a business trip (出差, chū chā). You're excited to practice your Chinese with locals and try delicious food (美食, měi shí) like dumplings (饺子, jiǎo zi) and hot pot (火锅, huǒ guō).
During your trip, you meet a friendly Chinese colleague, 同事 (tóng shì), who takes you to a traditional tea house (茶馆, chá guǎn). You learn about Chinese culture (文化, wén huà) and try various teas (茶叶, chá yè).
As you continue to learn and improve your Chinese, you start to read Chinese books (书籍, shū jí) and watch Chinese movies (电影, diàn yǐng). Your vocabulary expands, and you become more confident in your language skills.
HSK 1-6 Vocabulary List ( partial )
| HSK Level | Vocabulary | | --- | --- | | 1 | 我 (wǒ), 你 (nǐ), 好 (hǎo), 谢谢 (xiè xiè) | | 2 | 家庭 (jiā tíng), 学校 (xué xiào), 工作 (gōng zuò) | | 3 | 卡片 (kǎ piàn), 本地人 (běndì rén), 街道 (jiē dào) | | 4 | 经理 (jīnglǐ), 公司 (gōngsī), 市场 (shì chǎng) | | 5 | 美食 (měi shí), 饺子 (jiǎo zi), 火锅 (huǒ guō) | | 6 | 文化 (wén huà), 茶叶 (chá yè), 书籍 (shū jí) |
Most Excel lists are organized by HSK Level (Columns) or grouped into rows by level.
An HSK 1-6 vocabulary list in Excel is not a textbook. It’s a database. Your job is not to memorize the database. Your job is to query it.
Use filters to ignore what you don’t need. Use date tracking to review at the right time. Use sentences to build context.
Do that, and those 5,000 words will stop looking like a mountain and start looking like a checklist.
What’s your current HSK level? Drop a comment below and I’ll send you an Excel template with the filters pre-built.
The most reliable source for a free, downloadable HSK 1-6 vocabulary list in Excel format is the Konfuzius-Institut Leipzig
, which provides a comprehensive spreadsheet including Hanzi, Pinyin, and English definitions. For more interactive or filtered lists, MandarinZone
offers a dedicated HSK 6 Excel file that includes additional quiz sheets. Mandarin Zone 📊 Quick Access HSK Vocabulary Links Excel Direct Download: HSK 1-6 Full List (Konfuzius-Institut) Interactive Web View: HSK东西 (Word Lists)
– View frequency indexes and expand definitions without downloading. PDF Alternatives: Mandarin Bean
offers the most up-to-date PDF lists for the HSK 3.0 standards (Levels 1-9). Mandarin Bean 💡 Vocabulary Overview by Level
As of 2026, many students are transitioning from the "Old" HSK (2.0) to the "New" HSK (3.0). If you are using the 2.0 curriculum (the standard 1-6 levels), the word counts are: Cumulative Word Count Basic daily greetings and numbers Routine tasks and simple exchanges Daily life, work, and travel topics Fluency on a wide range of topics Reading newspapers and watching films Understanding complex native materials 🛠️ How to Use These Lists Effectively Filter by Difficulty: In Excel, use the "Filter" tool on the column to isolate specific HSK stages. Frequency Order:
Prioritize words with a higher "frequency index" to learn the most useful vocabulary first. Self-Testing:
Add a blank column to your spreadsheet to track "Learning Progress" (e.g., Not Started, In Progress, Mastered). , or are you looking for Anki flashcard decks that match these Excel files? HSK 6 Vocabulary + Excel (with 3 Free Quiz Sheets)
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.