Flashcard apps like Anki and Pleco are excellent for mobile review, but spreadsheets offer unique advantages for structured, long-term curriculum planning.
The standard written form used in mainland China and the HSK exam.
Here are the three most reliable sources (historically verified by the Chinese learning community):
When looking for an HSK 1-6 vocabulary list Excel file, it is important to understand which version of the test you are preparing for. hsk 1-6 vocabulary list excel
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).
Expands into a 9-level structure (Beginner, Intermediate, Advanced) containing over 11,000 words.
The phonetic system with tone marks (e.g., nǐ hǎo ) to guide your pronunciation. Flashcard apps like Anki and Pleco are excellent
When setting up your spreadsheet, keep in mind that Hanban introduced the , which restructures the levels into a 9-band system (Beginner, Intermediate, Advanced).
You can test yourself directly inside Excel using simple formatting tricks:
You can find pre-made, professionally organized Excel and Google Sheets templates from these providers: : Offers various digital downloads, including the HSK 1-6 Vocabulary Spreadsheet and more advanced HSK 3.0 1-9 versions LTL Mandarin School As you progress, you learn words like 家庭
The HSK 1-6 vocabulary list Excel is a spreadsheet that contains the complete list of vocabulary words for all six levels of the HSK test. The Excel format allows users to easily sort, filter, and search for words, making it a convenient and user-friendly resource.
A complete HSK 1-6 vocabulary list Excel file will contain roughly 5,000 rows of data. Assuming 8 columns of data per row (Character, Pinyin, English, Part of Speech, HSK Level, Frequency, Example Sentence, Notes), that is a database of 40,000 data points.
If you are ready to start organizing your study plan, let me know if you would like me to generate a of an HSK vocabulary table, or if you need the exact step-by-step instructions for importing CSV data into Anki . Share public link
Create columns for "Last Reviewed Date" and "Next Review Date" (e.g., in 1, 3, 7, 21 days). Use Excel's date functions to automatically calculate when you should review each word based on your initial review date and proficiency level. This is a basic but highly effective way to implement SRS principles in Excel.